Error when trying to access http://localhost/Reports

Hello,

I just recently installed SQL Express 2005 Reporting Services on a new OS "Vista Ultimate". I used for reference the video # 10 Getting Started with Reporting Services found in

SQL Server Videos - SQL Server 2005 Express for Beginners. I was finally able to install everthing, including creating a new project using Report Server Project Wizard.

The only problem I recieve when fallowing the video is opening IE and enteringhttp://localhost/Reports. What I recieve is an error"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

I checked to see if the SQL Server Reporting Services was running which it was. I also checked the Default Web Site in IIS manger which was also running.

Any help would be much appreciated

Regards

Karl

May be the problem is just configuration check this link it might help you

http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx

Error when starting Report Manager

When trying to start report manager (http://localhost/reports) I get the following error. I have since given access to ASPNET and IUSR_<machinename> rights to the listed path & file, but still get same error. Any ideas? Thanks.

Parser Error Message: An error occurred loading a configuration file: Access to the path 'C:\Inetpub\wwwroot_sps2003\web.config' is denied.

Source Error:

[No relevant source lines]

Source File: C:\Inetpub\wwwroot_sps2003\web.config Line: 0

Try giving the report server web service account read permission on the folder in the error message.

-Lukasz

|||

It's working. Since we have Sharepoint and other things on there I had to specify the port and sql instance: http://someservername:8080/Reports$sql2005 this worked! Report manager comes up now.

Thanks!

|||

You'll need to do some more work to make things work reliably:

1) in the rsreportserver.config file, change URLRoot to include the URL above. This allows links in e-mail deliveries to be accurate.

2) check your report manager configuration file and see if you need to set the reportserverurl property rather than the reportservervirtualdirectory property - when using a custom port you usually need to use reportserverurl. Note that these elements are mutually exclusive.

Good to hear you're up and running.

-Lukasz

Error when open Report Manager

RS is installed on the same server with the WebServer. I run this from a
domain network PC:
http://WebServerName/Reports/Pages/Folder.aspx
and I receive this error:
The request failed with HTTP status 401: Unauthorized.
What I checked:
1.On the WebServer go in IIS , then Default Web Site, then Reports, then
Proprieties, then Security and ONLY Integrated Windows Authentication is
checked
2. The save as above for ReportService under Default Web Site
3. Open Windows Explorer on the Web Server and go to C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer where
ReportService.asmx file is located. In the same folder have a look in
web.config file and:
<authentication mode="Windows" />
<identity impersonate="false" />
4 IIS is version 6
5. Web Server is Windows 2003
6. Went in Logs for RS and this is what I found:
w3wp!ui!1860!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
status 401: Unauthorized.
w3wp!ui!1acc!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
status 401: Unauthorized.
w3wp!ui!1acc!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 401:
Unauthorized.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!1860!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
--Details--
7. Changed in IIS to use Anonymous access and then Report Manager opens
without error but there is no report there (only Home directory and that's
all).After working on this problem for a week, I found posting from Jonny W.
and it worked for me.
If anyone else is having the same problem this KB article applies:
http://support.microsoft.com/default.aspx/kb/896861/en-us
Eddy wrote:
> RS is installed on the same server with the WebServer. I run this from a
> domain network PC:
> http://WebServerName/Reports/Pages/Folder.aspx
> and I receive this error:
> The request failed with HTTP status 401: Unauthorized.
> What I checked:
> 1.On the WebServer go in IIS , then Default Web Site, then Reports, then
> Proprieties, then Security and ONLY Integrated Windows Authentication is
> checked
> 2. The save as above for ReportService under Default Web Site
> 3. Open Windows Explorer on the Web Server and go to C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer where
> ReportService.asmx file is located. In the same folder have a look in
> web.config file and:
> <authentication mode="Windows" />
> <identity impersonate="false" />
> 4 IIS is version 6
> 5. Web Server is Windows 2003
> 6. Went in Logs for RS and this is what I found:
> w3wp!ui!1860!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
> status 401: Unauthorized.
> w3wp!ui!1acc!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
> status 401: Unauthorized.
> w3wp!ui!1acc!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 401:
> Unauthorized.
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!1860!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
> --Details--
> 7. Changed in IIS to use Anonymous access and then Report Manager opens
> without error but there is no report there (only Home directory and that's
> all).

Error when moving a report server database to another server

We have a new server (SRV63) and I followed the instructions at http://msdn2.microsoft.com/en-us/library/ms156421.aspx to move the report server database from our old server (SRV38). Everything appeared OK, however, when I went to initialize the instance in the Reporting Services Configuration tool, it shows an initialized instance (checkbox is checked) for SRV38 and and uninitialized instance for SRV63 (checkbox is not checked). Please note that I am not trying to create a scale-out deployment. I tried to initialize SRV63 but received the error below.

--

ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)

This is the only thing stopping me from shutting down SRV38 and bringing SRV63 into production. Can someone assist me with this issue?

Chuck-

Just curious if you figured this out. I have the exact same problem and can't figure out how to resolve it.

Thanks!

Laura

|||

Hi Laura. I was a bit surprised that I did not receive any response to help me with this issue as I was sure I was not the first to have experienced this issue. As I was short on time; I opted to reinstall Reporting Services and recreated all my user / group folders and securities and re-registered all my reports to the correct report folders. It was like starting from scratch; however it works and I do not have to worry about legacy items from the old server causing issues now. I believe I could have avoided this issue by turning off the Reporting Services on the old server before installing them on the new server therefore only the new Reporting Services instance would show. You might give this a try and see if it works. Sorry I don't have a more definitive answer for you.

Good luck.

|||

I was also able to solve the problem by deleting the report databases and then recreating them through the Reporting Services Configuration. Thanks for your response!

Laura

sql

error when i try the link http://localhost/reportserver

Dear All,

i face a problem when i try the link http://localhost/reportserver

an error message appear as the following

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied

and i check the server log file and it is as the following ( i hope anyone help to solve that problem)

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Egypt Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__07_30_2007_16_46_58.log</Path>
<SystemName>KKHALIFA-XP-588</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!7/30/2007-16:46:59:: w WARN: WebServiceAccount is not specified in the config file. Using default: KKHALIFA-XP-588\ASPNET
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!7/30/2007-16:46:59:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!4!7/30/2007-16:46:59:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 33180 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: SQM timer timer enabled: Next Event: 36780 seconds. Cycle: 86400 seconds
ReportingServicesService!library!8!7/30/2007-16:47:00:: i INFO: Catalog SQL Server Edition = Developer
ReportingServicesService!library!8!7/30/2007-16:47:00:: e ERROR: Sql errorystem.Data.SqlClient.SqlException: Could not find stored procedure 'GetDBVersion'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
ReportingServicesService!library!8!7/30/2007-16:47:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights.
ReportingServicesService!library!8!7/30/2007-16:47:00:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights.
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!8!7/30/2007-16:47:00:: Attempting to start service again...

http://prologika.com/CS/blogs/blog/archive/2007/07/12/ssrs-setup-woes.aspx

|||

About the Question i had asked ,

i found its solution and know what was the problem,

so i like to share it with You all ,

all i have done is setting the Reporting Services Configuration that was need to be configure

you can find it in the following path:

from the start menu ==> All program ==>Microsoft SQL Server 2005 ==>Configuration Tools ==>Reporting Services Configuration

in my case most of the configration Was invalid and not configure right so i Reconfigure it and then everything is great after that.

Regards,

Maylo

Error when browsing the page http://localhost/reports

I have installed SQL Server Reporting service 2005 and when I am trying to
browse the page http://localhost/reports, it is giving me following error:
System.Web.Services.Protocols.SoapException: Server was unable to process
request. --> System.IO.FileNotFoundException:
C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
at
Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
at
Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
SQL Server 2005 is installed on different machine. I am installing SQL
Server Reporting service 2005 on CRM server. I have install/uninstall for a
number of times. Previously, it was working properly and after some
installaion/uninstallation, it has started giving the above error.Just to be sure where is can be the problem (network config, or installation
issue), have you tried to use the IP Address of the machine instead of
localhost?
http://yourip/reports
or
http://127.0.0.1/Reports
Good luck
Braulio
/// --
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// --
"Bhumit" wrote:
> I have installed SQL Server Reporting service 2005 and when I am trying to
> browse the page http://localhost/reports, it is giving me following error:
> System.Web.Services.Protocols.SoapException: Server was unable to process
> request. --> System.IO.FileNotFoundException:
> C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
> at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
> SQL Server 2005 is installed on different machine. I am installing SQL
> Server Reporting service 2005 on CRM server. I have install/uninstall for a
> number of times. Previously, it was working properly and after some
> installaion/uninstallation, it has started giving the above error.
>|||Another thing to do is go to your Reporting Services Configuration Tool and
make sure all your Settings are pointing to the correct location. I found
this area to be extremely sensitive.
"Braulio Diez" wrote:
> Just to be sure where is can be the problem (network config, or installation
> issue), have you tried to use the IP Address of the machine instead of
> localhost?
> http://yourip/reports
> or
> http://127.0.0.1/Reports
> Good luck
> Braulio
> /// --
> /// Braulio Diez
> ///
> /// http://www.tipsdotnet.com
> /// --
>
>
> "Bhumit" wrote:
> > I have installed SQL Server Reporting service 2005 and when I am trying to
> > browse the page http://localhost/reports, it is giving me following error:
> >
> > System.Web.Services.Protocols.SoapException: Server was unable to process
> > request. --> System.IO.FileNotFoundException:
> > C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
> > at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
> >
> > SQL Server 2005 is installed on different machine. I am installing SQL
> > Server Reporting service 2005 on CRM server. I have install/uninstall for a
> > number of times. Previously, it was working properly and after some
> > installaion/uninstallation, it has started giving the above error.
> >
> >

Error when assigning Dimension Data Permissions using AMO

Hello,

I am using AMO example posted on MSDN: http://msdn2.microsoft.com/en-us/library/ms345081.aspx

I followed this example very closely. I can create a role, assign read permissions to it, but when I try to

assign AllowedSet to Dimension Attribute (see code below):

// Get dimension and attribute

Dimension dim = dataBase.Dimensions.GetByName(dimName);

DimensionAttribute attr = dim.Attributes.GetByName("Group Name");

CubeDimensionPermission cubeDimPerm = cubePerm.DimensionPermissions.Add(dim.ID);

cubeDimPerm.Read = ReadAccess.Allowed;

AttributePermission attrPerm = cubeDimPerm.AttributePermissions.Add(attr.ID);

attrPerm.AllowedSet = "{[GroupUsers].[Group Name].&[0]}";

cubePerm.Update();

I am getting this error: Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj,
ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions o
ptions, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection
impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptio
ns options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollect
ion impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, Updat
eMode mode, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.MajorObject.Update()
at IHS.Datawarehouse.CubeUtility.Program.AssignDimensionData(Database dataBas
e, String roleName, String dimName) in C:\IHS\WWBA\Development\Applications\IHS.
Datawarehouse.CubeUtility\IHS.Datawarehouse.CubeUtility\IHS.Datawarehouse.CubeUt
ility\Program.cs:line 99
at IHS.Datawarehouse.CubeUtility.Program.Main(String[] args) in C:\IHS\WWBA\D
evelopment\Applications\IHS.Datawarehouse.CubeUtility\IHS.Datawarehouse.CubeUtil
ity\IHS.Datawarehouse.CubeUtility\Program.cs:line 32

Has anyone experienced this error. What's causing this?

Actual error message in the event viewer:

The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured..

Error Viewing reports

Hi everybody,

first i am having problem viewing the reports, when i go to http://localhost/ReportServer/ i get a list of files and folders as follow:

[To Parent Directory]

01 ?????, 2007 11:14 ? <dir> bin
06 ??????, 2005 01:12 ? 488278 Catalog.sql

06 ??????, 2005 01:12 ? 14738 CatalogTempDB.sql04 ?????, 2007 05:26 ? 76 global.asax

04 ?????, 2007 05:38 ? 10540 rsreportserver.config
13 ?????, 2005 02:07 ? 11845 rssrvpolicy.config
01 ?????, 2007 11:14 ? <dir> Styles
08 ?????, 2007 09:58 ? 2776 web.config
and when i try to open any folder it shows its content, then i select any report and click on it, it gives me the following error:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Invalid object name 'ReportServerTempDB.dbo.PersistedStream'.

could anyone help me please?

thanks in advance....

go instead to
http://localhost/reports

Error using Reporting services

Greetings,

Iam new to reporting services. When I try to launch http:\\localhost\reports

I get the following error

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

Please help

Thanks/Regards

I get the same message. Only the version is different.

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

By profiler I saw the trying to use of SP GetDBVersion, but this SP not present.

What is it and where can I download the update?

Thanks/Regards

|||This is usually an issue where RS is configured to the wrong DB. You should use the config tool to configure RS to a ReportServer DB.|||What is "wrong DB"? I create NEW DB for RS from RS config.|||Did you ensure that RS is configured to use that DB? Just creating the DB does not configure RS to use it.|||So how do we do that? Pardon my ignorance with SQL, it's my weakest point. The error I personally get is: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) In the Configure Report Server SSRS is configured properly, & I can log into that account in the Management Studio, but I cannot open http://localhost/reports. Any ideas? Thanks!|||In the ReportServer Configuration tool, does the Database tab have a green check? If not you need to go to that tab and choose the Report Server Database that you want to use.|||Thank you for your kind reply. Yes, I have a successful connection in the Report Server Configuration. I think I may have 2 instances of Reporting Server, however, & one didn't get the green icon. I figured when I re-installed, it overwrote the existing files, but as I'm poking around I see 2 instances. Would this be causing the problem?|||

Daniel,

Your last post asking if I got the green icon for the database connection made me think about the fact that perhaps I was trying to connect to the old instance of ssrs (as you can see in my post made about a half hour ago). Thanks for leading me in the right direction, because that was it!! It didn't make sense that it wasn't connecting to the database if that connection was configured properly in the Configuration Manager. I now can view the Report page.

Thanks again,

Kim

|||

I did step by step in RS config. When I came to configure DB, RS created DB, but coundn't configure it. By first it coundn't create RSRoleExec, I did this. Next it began show the message about virsion. But the left mark is green, and "Initialization" is not enabled.

|||

Sir ,

I get the same error and i use the SQL server 2000 version. Where can i find the configuration tool. I tried to run the rsconfig.exe with the requisite details but it did not work. Please let me know what is to be done.

Thanks a lot

Vijay

|||This issue can be also due to Report Server is configured to the wrong Database, choose Report Server Database that you want to use with the help of Report Server Configuration tool.

Error using Reporting services

Greetings,

Iam new to reporting services. When I try to launch http:\\localhost\reports

I get the following error

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

Please help

Thanks/Regards

I get the same message. Only the version is different.

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

By profiler I saw the trying to use of SP GetDBVersion, but this SP not present.

What is it and where can I download the update?

Thanks/Regards

|||This is usually an issue where RS is configured to the wrong DB. You should use the config tool to configure RS to a ReportServer DB.|||What is "wrong DB"? I create NEW DB for RS from RS config.|||Did you ensure that RS is configured to use that DB? Just creating the DB does not configure RS to use it.|||So how do we do that? Pardon my ignorance with SQL, it's my weakest point. The error I personally get is: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) In the Configure Report Server SSRS is configured properly, & I can log into that account in the Management Studio, but I cannot open http://localhost/reports. Any ideas? Thanks!|||In the ReportServer Configuration tool, does the Database tab have a green check? If not you need to go to that tab and choose the Report Server Database that you want to use.|||Thank you for your kind reply. Yes, I have a successful connection in the Report Server Configuration. I think I may have 2 instances of Reporting Server, however, & one didn't get the green icon. I figured when I re-installed, it overwrote the existing files, but as I'm poking around I see 2 instances. Would this be causing the problem?|||

Daniel,

Your last post asking if I got the green icon for the database connection made me think about the fact that perhaps I was trying to connect to the old instance of ssrs (as you can see in my post made about a half hour ago). Thanks for leading me in the right direction, because that was it!! It didn't make sense that it wasn't connecting to the database if that connection was configured properly in the Configuration Manager. I now can view the Report page.

Thanks again,

Kim

|||

I did step by step in RS config. When I came to configure DB, RS created DB, but coundn't configure it. By first it coundn't create RSRoleExec, I did this. Next it began show the message about virsion. But the left mark is green, and "Initialization" is not enabled.

|||

Sir ,

I get the same error and i use the SQL server 2000 version. Where can i find the configuration tool. I tried to run the rsconfig.exe with the requisite details but it did not work. Please let me know what is to be done.

Thanks a lot

Vijay

|||This issue can be also due to Report Server is configured to the wrong Database, choose Report Server Database that you want to use with the help of Report Server Configuration tool.

Error using Reporting services

Greetings,

Iam new to reporting services. When I try to launch http:\\localhost\reports

I get the following error

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

Please help

Thanks/Regards

I get the same message. Only the version is different.

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

By profiler I saw the trying to use of SP GetDBVersion, but this SP not present.

What is it and where can I download the update?

Thanks/Regards

|||This is usually an issue where RS is configured to the wrong DB. You should use the config tool to configure RS to a ReportServer DB.|||What is "wrong DB"? I create NEW DB for RS from RS config.|||Did you ensure that RS is configured to use that DB? Just creating the DB does not configure RS to use it.|||So how do we do that? Pardon my ignorance with SQL, it's my weakest point. The error I personally get is: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) In the Configure Report Server SSRS is configured properly, & I can log into that account in the Management Studio, but I cannot open http://localhost/reports. Any ideas? Thanks!|||In the ReportServer Configuration tool, does the Database tab have a green check? If not you need to go to that tab and choose the Report Server Database that you want to use.|||Thank you for your kind reply. Yes, I have a successful connection in the Report Server Configuration. I think I may have 2 instances of Reporting Server, however, & one didn't get the green icon. I figured when I re-installed, it overwrote the existing files, but as I'm poking around I see 2 instances. Would this be causing the problem?|||

Daniel,

Your last post asking if I got the green icon for the database connection made me think about the fact that perhaps I was trying to connect to the old instance of ssrs (as you can see in my post made about a half hour ago). Thanks for leading me in the right direction, because that was it!! It didn't make sense that it wasn't connecting to the database if that connection was configured properly in the Configuration Manager. I now can view the Report page.

Thanks again,

Kim

|||

I did step by step in RS config. When I came to configure DB, RS created DB, but coundn't configure it. By first it coundn't create RSRoleExec, I did this. Next it began show the message about virsion. But the left mark is green, and "Initialization" is not enabled.

|||

Sir ,

I get the same error and i use the SQL server 2000 version. Where can i find the configuration tool. I tried to run the rsconfig.exe with the requisite details but it did not work. Please let me know what is to be done.

Thanks a lot

Vijay

|||This issue can be also due to Report Server is configured to the wrong Database, choose Report Server Database that you want to use with the help of Report Server Configuration tool.

Error running SQL 2005 Performance Dashboard reportDonwload the sample from the site

Donwload the sample from the site

http://www.microsoft.com/downloads/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc&DisplayLang=en

, follow the inftruction and run the setup.sql script to create requried sp and udf at msdb, SQL server is on WIN2003 and SP2 for sql server 2005.

But I got the following error when running performance_dashboard_main reports and I got the following error

"Difference of two datetime columns caused overflow at runtime"

It looks like the

procedure [MS_PerfDashboard].[usp_Main_GetSessionInfo]

creating error, could you please take a look?

Thanks

The problem occurs on my system if I have a login that has been connected for over 24 days. I "fixed" it by giving up a little precision if the connection is old by changing the query to:

select count(*) as num_sessions,
sum(convert(bigint, s.total_elapsed_time)) as total_elapsed_time,
sum(convert(bigint, s.cpu_time)) as cpu_time,
sum(convert(bigint, s.total_elapsed_time)) - sum(convert(bigint, s.cpu_time)) as wait_time,
sum(convert(bigint, case when datediff(day, login_time, getdate()) < 24
then datediff(ms, login_time, getdate())
else datediff(s, login_time, getdate()) * 1000
end)) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,
case when sum(s.logical_reads) > 0 then (sum(s.logical_reads) - isnull(sum(s.reads), 0)) / convert(float, sum(s.logical_reads))
else NULL
end as cache_hit_ratio
from sys.dm_exec_sessions s
where s.is_user_process = 0x1

You still get millisecond precision if the connection is younger than 24 days but only second precision if older than 24 days. This will support connections that have beem in for about 65 years. That's a long time between reboots

I agree it would be better if they corrected the download, but if you change it in the setup.sql in your local PerformanceDashboard folder it is idempotent and you can redeploy when you see the error on any server.

fwiw: staying connected for 24 days is not a generally recognized best practice for a user SPID.

|||

Hi Bwunder,

Thanks for your tips, I will test it out right away!

By the way, since staying connected for more that 24 days is not good practices, how do you normally handle this if you don't mind.

|||Depends on what you are doing with the connection.

One good place to investigate the answers would be the in the .NET Data Access Architecture Guide
http://msdn2.microsoft.com/en-us/library/ms978510.aspx#daag_managingdatabaseconnections

Error running RS 2005.

I just finished to install Sql server 2005 with Reporting Services but
when I try to open http://localhost/Reports/Pages/Folder.aspx I get
the following error:
The underlying connection was closed: An unexpected error occurred on
a receive.
System.Net.WebException: The underlying connection was closed: An
unexpected error occurred on a receive. --> System.IO.IOException:
Unable to read data from the transport connection: An established
connection was aborted by the software in your host machine. -->
System.Net.Sockets.SocketException: An established connection was
aborted by the software in your host machine
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset,
Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32
offset, Int32 size)
-- End of inner exception stack trace --
at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32
size)
at System.Net.HttpWebRequest.MakeMemoryStream(Stream stream)
-- End of inner exception stack trace --
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
leve)
at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!1!3/22/2007-17:43:59:: e ERROR: Exception in
ShowErrorPage: System.Threading.ThreadAbortException: Thread was being
aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at
Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at
Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: The underlying connection
was closed: An unexpected error occurred on a receive.
aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: HTTP status code --> 500
Please, can someone help me?
Thank you!!On Mar 22, 4:20 pm, "Gabe" <vasgabr...@.gmail.com> wrote:
> I just finished to install Sql server 2005 with Reporting Services but
> when I try to openhttp://localhost/Reports/Pages/Folder.aspxI get
> the following error:
> The underlying connection was closed: An unexpected error occurred on
> a receive.
> System.Net.WebException: The underlying connection was closed: An
> unexpected error occurred on a receive. --> System.IO.IOException:
> Unable to read data from the transport connection: An established
> connection was aborted by the software in your host machine. -->
> System.Net.Sockets.SocketException: An established connection was
> aborted by the software in your host machine
> at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset,
> Int32 size, SocketFlags socketFlags)
> at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32
> offset, Int32 size)
> -- End of inner exception stack trace --
> at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32
> size)
> at System.Net.HttpWebRequest.MakeMemoryStream(Stream stream)
> -- End of inner exception stack trace --
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> leve)
> at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> aspnet_wp!ui!1!3/22/2007-17:43:59:: e ERROR: Exception in
> ShowErrorPage: System.Threading.ThreadAbortException: Thread was being
> aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at
> Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at
> Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
> aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: The underlying connection
> was closed: An unexpected error occurred on a receive.
> aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: HTTP status code --> 500
> Please, can someone help me?
> Thank you!!
You might want 2 try re-installing SQL Server 2005.
Regards,
Enrique Martinez
Sr. Software Consultant|||Please see if this helpful:
http://support.microsoft.com/default.aspx/kb/919797
"Gabe" wrote:
> I just finished to install Sql server 2005 with Reporting Services but
> when I try to open http://localhost/Reports/Pages/Folder.aspx I get
> the following error:
> The underlying connection was closed: An unexpected error occurred on
> a receive.
> System.Net.WebException: The underlying connection was closed: An
> unexpected error occurred on a receive. --> System.IO.IOException:
> Unable to read data from the transport connection: An established
> connection was aborted by the software in your host machine. -->
> System.Net.Sockets.SocketException: An established connection was
> aborted by the software in your host machine
> at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset,
> Int32 size, SocketFlags socketFlags)
> at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32
> offset, Int32 size)
> -- End of inner exception stack trace --
> at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32
> size)
> at System.Net.HttpWebRequest.MakeMemoryStream(Stream stream)
> -- End of inner exception stack trace --
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> leve)
> at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> aspnet_wp!ui!1!3/22/2007-17:43:59:: e ERROR: Exception in
> ShowErrorPage: System.Threading.ThreadAbortException: Thread was being
> aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at
> Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at
> Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
> aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: The underlying connection
> was closed: An unexpected error occurred on a receive.
> aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: HTTP status code --> 500
> Please, can someone help me?
> Thank you!!
>|||Thanks for response. The above link did not help me because I have Window
2000 professional with SP 4. Besides, I installed again both, SQL Server
2005 and VS 2005 and http://localhost/Reports worked in correct way. But
today I got the same error than before. I don't know what is happening. Can
someone help me please?
Thank you.
"Bruce Johnson [MSFT]" <BruceJohnsonMSFT@.discussions.microsoft.com> wrote in
message news:C02AD249-71FD-4A77-B813-CB150E6BEC0D@.microsoft.com...
> Please see if this helpful:
> http://support.microsoft.com/default.aspx/kb/919797
>
> "Gabe" wrote:
> > I just finished to install Sql server 2005 with Reporting Services but
> > when I try to open http://localhost/Reports/Pages/Folder.aspx I get
> > the following error:
> >
> > The underlying connection was closed: An unexpected error occurred on
> > a receive.
> >
> > System.Net.WebException: The underlying connection was closed: An
> > unexpected error occurred on a receive. --> System.IO.IOException:
> > Unable to read data from the transport connection: An established
> > connection was aborted by the software in your host machine. -->
> > System.Net.Sockets.SocketException: An established connection was
> > aborted by the software in your host machine
> > at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset,
> > Int32 size, SocketFlags socketFlags)
> > at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32
> > offset, Int32 size)
> > -- End of inner exception stack trace --
> > at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32
> > size)
> > at System.Net.HttpWebRequest.MakeMemoryStream(Stream stream)
> > -- End of inner exception stack trace --
> > at
> >
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> > at
> >
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> > at
> >
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> > methodname)
> > at
> >
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> > at
> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > leve)
> > at
> > Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > sender, EventArgs args)
> > at System.EventHandler.Invoke(Object sender, EventArgs e)
> > at System.Web.UI.Control.OnInit(EventArgs e)
> > at System.Web.UI.Page.OnInit(EventArgs e)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > aspnet_wp!ui!1!3/22/2007-17:43:59:: e ERROR: Exception in
> > ShowErrorPage: System.Threading.ThreadAbortException: Thread was being
> > aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> > preserveForm)
> > at
> > Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> > preserveForm)
> > at
> > Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)
> > aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: The underlying connection
> > was closed: An unexpected error occurred on a receive.
> > aspnet_wp!ui!1!3/22/2007-18:04:08:: e ERROR: HTTP status code --> 500
> >
> > Please, can someone help me?
> > Thank you!!
> >
> >