|
|
You're in the
sql server reporting services
group:Problem accessing Report Server
sql server reporting services:
for testing. Already had SQL 2000 installed so I gave the new install an instance name of SQL2005. My problem is that I can't access the Report Server web pages. I have checked and IIS 5.1 is running, report services is started. In IIS MMC the viruall directories where created with Reports$SQL2005 and ReposrtServer$SQL2005. I get HTTP error 500. "There is a problem with the page you are trying to reach and it cannot be displayed." I get this error on anything I try to browse within IIS 5.1. Within VS2005 when I try to deploy a report I get the following: TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://joelaptop/Reportserver$SQL2005. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html', but expected 'text/xml'. The request failed with the error message: -- <html><head><title>Server Application Error</title></head> <body><h1>Server Application Error</h1>The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance.</body></html> --. (Microsoft.ReportingServices.Designer) ------------------------------ BUTTONS: OK ------------------------------
Joe,
What does the event log say? What version of the .NET framework is the Reportserver$SQL2005 virtual directory set up for (right click on the virtual directory and select the ASP.NET tab. It should be set to .NET 2.0)? I've got the same setup and don't have a problem. Andy Potter
ASP.Net is version 2.0.50727
I get this in the system log when attempting to browse either Reportserver or reports VD: Event Type: Warning Event Source: W3SVC Event Category: None Event ID: 36 Date: 12/30/2005 Time: 8:36:54 AM User: N/A Computer: JOELAPTOP Description: The server failed to load application '/LM/W3SVC'. The error was 'The specified metadata was not found. '. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. [quoted text, click to view] "Potter" wrote:
> Joe, > > What does the event log say? What version of the .NET framework is the > Reportserver$SQL2005 virtual directory set up for (right click on the > virtual directory and select the ASP.NET tab. It should be set to .NET > 2.0)? > > I've got the same setup and don't have a problem. > > Andy Potter >
You've got an IIS problem, not a RS problem
Try resetting your mappings http://support.microsoft.com/default.aspx?scid=KB;en-us;q306005 Andy Potter
I reset the mappings, but still get the same error.
[quoted text, click to view] "Potter" wrote:
> You've got an IIS problem, not a RS problem > > Try resetting your mappings > > http://support.microsoft.com/default.aspx?scid=KB;en-us;q306005 > > Andy Potter >
Is your Report Server initialized? Do you have green checks for everything
in the Reporting Services Configuration Manager? If everything is happy there, try deleting the virtual directories in IIS manager and then open the Reporting Services Configuration Manager and recreate the directories. -- Douglas McDowell douglas@nospam.solidqualitylearning.com [quoted text, click to view] "Joe S." <joecrew@news.postalias> wrote in message news:30D0F1F6-F637-4C07-A78D-6087A36E319E@microsoft.com... >I reset the mappings, but still get the same error. > > "Potter" wrote: > >> You've got an IIS problem, not a RS problem >> >> Try resetting your mappings >> >> http://support.microsoft.com/default.aspx?scid=KB;en-us;q306005 >> >> Andy Potter >> >>
RSCM had all Green checks. I deleted the VD and recreated them and still no
luck. [quoted text, click to view] "Douglas McDowell" wrote:
> Is your Report Server initialized? Do you have green checks for everything > in the Reporting Services Configuration Manager? > > If everything is happy there, try deleting the virtual directories in IIS > manager and then open the Reporting Services Configuration Manager and > recreate the directories. > > -- > Douglas McDowell douglas@nospam.solidqualitylearning.com > > > "Joe S." <joecrew@news.postalias> wrote in message > news:30D0F1F6-F637-4C07-A78D-6087A36E319E@microsoft.com... > >I reset the mappings, but still get the same error. > > > > "Potter" wrote: > > > >> You've got an IIS problem, not a RS problem > >> > >> Try resetting your mappings > >> > >> http://support.microsoft.com/default.aspx?scid=KB;en-us;q306005 > >> > >> Andy Potter > >> > >> > >
ALso I am unable to open the COM+ section of Component Service. I get
"Catalog Error An error occurred while processing the last operation Error code 80080005 - Server execution failed" And I get several of the folwoing errors: Event Type: Error Event Source: COM+ Event Category: (98) Event ID: 4863 Date: 1/6/2006 Time: 5:06:29 PM User: N/A Computer: JOELAPTOP Description: TransactionManager->GetWhereabouts failed. If Distributed Transaction Coordinator is configured to use remote host to coordinate transactions, it is likely that remote host cannot be contacted. You can configure MSDTC to use local coordinator by clicking MSDTC toolbar button in Component Services MMC snap-in. Since further execution is impossible at this time, server process has been terminated. Server Application ID: {02D4B3F1-FD88-11D1-960D-00805FC79235} Server Application Instance ID: {8472F8A4-FD08-4532-8E2A-361437FB3812} Server Application Name: System Application Error Code = 0x8004d01b : The Transaction Manager is not available. COM+ Services Internals Information: File: d:\qxp_slp\com\com1x\src\comsvcs\txprop\dtcinfo.cpp, Line: 164 Comsvcs.dll file version: ENU 2001.12.4414.308 shp [quoted text, click to view] "Joe S." wrote:
> RSCM had all Green checks. I deleted the VD and recreated them and still no > luck. > > "Douglas McDowell" wrote: > > > Is your Report Server initialized? Do you have green checks for everything > > in the Reporting Services Configuration Manager? > > > > If everything is happy there, try deleting the virtual directories in IIS > > manager and then open the Reporting Services Configuration Manager and > > recreate the directories. > > > > -- > > Douglas McDowell douglas@nospam.solidqualitylearning.com > > > > > > "Joe S." <joecrew@news.postalias> wrote in message > > news:30D0F1F6-F637-4C07-A78D-6087A36E319E@microsoft.com... > > >I reset the mappings, but still get the same error. > > > > > > "Potter" wrote: > > > > > >> You've got an IIS problem, not a RS problem > > >> > > >> Try resetting your mappings > > >> > > >> http://support.microsoft.com/default.aspx?scid=KB;en-us;q306005 > > >> > > >> Andy Potter > > >> > > >> > > > >
Found my problem. Needed to uninstall and then reinstall MSDTC. Then
reinstalled SQL2005 and everything works fine. [quoted text, click to view] "Joe S." wrote:
> ALso I am unable to open the COM+ section of Component Service. I get > "Catalog Error > > An error occurred while processing the last operation > Error code 80080005 - Server execution failed" > > And I get several of the folwoing errors: > > Event Type: Error > Event Source: COM+ > Event Category: (98) > Event ID: 4863 > Date: 1/6/2006 > Time: 5:06:29 PM > User: N/A > Computer: JOELAPTOP > Description: > TransactionManager->GetWhereabouts failed. If Distributed Transaction > Coordinator is configured to use remote host to coordinate transactions, it > is likely that remote host cannot be contacted. You can configure MSDTC to > use local coordinator by clicking MSDTC toolbar button in Component Services > MMC snap-in. Since further execution is impossible at this time, server > process has been terminated. > Server Application ID: {02D4B3F1-FD88-11D1-960D-00805FC79235} > Server Application Instance ID: > {8472F8A4-FD08-4532-8E2A-361437FB3812} > Server Application Name: System Application > Error Code = 0x8004d01b : The Transaction Manager is not available. > COM+ Services Internals Information: > File: d:\qxp_slp\com\com1x\src\comsvcs\txprop\dtcinfo.cpp, Line: 164 > Comsvcs.dll file version: ENU 2001.12.4414.308 shp > > > > "Joe S." wrote: > > > RSCM had all Green checks. I deleted the VD and recreated them and still no > > luck. > > > > "Douglas McDowell" wrote: > > > > > Is your Report Server initialized? Do you have green checks for everything > > > in the Reporting Services Configuration Manager? > > > > > > If everything is happy there, try deleting the virtual directories in IIS > > > manager and then open the Reporting Services Configuration Manager and > > > recreate the directories. > > > > > > -- > > > Douglas McDowell douglas@nospam.solidqualitylearning.com > > > > > > > > > "Joe S." <joecrew@news.postalias> wrote in message > > > news:30D0F1F6-F637-4C07-A78D-6087A36E319E@microsoft.com... > > > >I reset the mappings, but still get the same error. > > > > > > > > "Potter" wrote: > > > > > > > >> You've got an IIS problem, not a RS problem > > > >> > > > >> Try resetting your mappings > > > >> > > > >> http://support.microsoft.com/default.aspx?scid=KB;en-us;q306005 > > > >> > > > >> Andy Potter > > > >> > > > >> > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |