rsInternalError

I recently installed SQL Reporting Services on a Windows Server 2003.
Whenever i try to open the repot Manager, i get the following error :
An internal error occured on the report Server. See error log for more
details (rsInternalError). The system cannot find the file specified.
Attached is my log file.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__07_22_2005_09_31_30.log</Path>
<SystemName>QA-DMPWIN01</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!208!7/22/2005-09:31:30:: i INFO: Reporting Web Server
started
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
ConnectionType to '0' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing MemoryLimit
to '60' percent as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing RecycleTime
to '720' minute(s) as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing InstanceName
to 'MSSQLSERVER' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it
was not specified in Configuration file.
w3wp!resourceutilities!208!7/22/2005-09:31:31:: i INFO: Running on 2
physical processors, 2 logical processors
w3wp!resourceutilities!208!7/22/2005-09:31:31:: i INFO: Reporting
Services starting SKU: Standard
w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Running Requests
Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Running Requests DB
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Memory stats update
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!crypto!208!07/22/2005-09:31:32:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!07/22/2005-09:31:32:: i INFO: Exporting public key
w3wp!webserver!208!07/22/2005-09:31:32:: e ERROR: Internal error:
System.IO.FileNotFoundException: The system cannot find the file
specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at
Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at
Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!208!07/22/2005-09:31:32:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at
Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at
Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
w3wp!crypto!5d0!7/22/2005-09:32:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!5d0!7/22/2005-09:32:31:: i INFO: Exporting public key
w3wp!library!5d0!7/22/2005-09:32:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!5d0!7/22/2005-09:33:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!5d0!7/22/2005-09:33:31:: i INFO: Exporting public key
w3wp!library!5d0!7/22/2005-09:33:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:34:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:34:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:34:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:35:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:35:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:35:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:36:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:36:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:36:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!db4!7/22/2005-09:37:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!db4!7/22/2005-09:37:31:: i INFO: Exporting public key
w3wp!library!db4!7/22/2005-09:37:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:38:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:38:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:38:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:39:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:39:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:39:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:40:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:40:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:40:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:41:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:41:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:41:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error doing timer action for Database Cleanup (Web
Service);
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.CleanBatchRecords()
at Microsoft.ReportingServices.Library.RSService.CleanBatch()
at
Microsoft.ReportingServices.Library.DatabaseCleanupTimer.DoTimerAction()
at
Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
unused)
-- End of inner exception stack trace --
w3wp!crypto!8e8!7/22/2005-09:41:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!8e8!7/22/2005-09:41:31:: i INFO: Exporting public key
w3wp!library!8e8!7/22/2005-09:41:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:42:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:42:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:42:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!b50!7/22/2005-09:43:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!b50!7/22/2005-09:43:31:: i INFO: Exporting public key
w3wp!library!b50!7/22/2005-09:43:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!d70!7/22/2005-09:44:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!d70!7/22/2005-09:44:31:: i INFO: Exporting public key
w3wp!library!d70!7/22/2005-09:44:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:45:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:45:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:45:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:46:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:46:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:46:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!a38!7/22/2005-09:47:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!a38!7/22/2005-09:47:31:: i INFO: Exporting public key
w3wp!library!a38!7/22/2005-09:47:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:48:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:48:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:48:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!9f0!7/22/2005-09:49:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!9f0!7/22/2005-09:49:31:: i INFO: Exporting public key
w3wp!library!9f0!7/22/2005-09:49:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:50:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:50:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:50:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at
Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!webserver!3fc!7/22/2005-09:51:24:: i INFO: Reporting Web Server
stopped
Please help me in resolving the above issue.
Thanks,The best recommendation I have is to remove each item one at a time and test
your report. Make sure to undo your delet if its removal does not solve the
problem. I had this same error and found that one of my charts was causing
the issue. Some setting that I could never find was causing the problem. I
had to recreate the chart and all was well.
=====================Thanks!
Keith
p.s. Get off the couch and exercise!
"sss" wrote:
> I recently installed SQL Reporting Services on a Windows Server 2003.
> Whenever i try to open the repot Manager, i get the following error :
> An internal error occured on the report Server. See error log for more
> details (rsInternalError). The system cannot find the file specified.
> Attached is my log file.
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.1038.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServer__07_22_2005_09_31_30.log</Path>
> <SystemName>QA-DMPWIN01</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> w3wp!webserver!208!7/22/2005-09:31:30:: i INFO: Reporting Web Server
> started
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> ConnectionType to '0' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> IsSchedulingService to 'True' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> IsEventService to 'True' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> PollingInterval to '10' second(s) as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing MemoryLimit
> to '60' percent as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing RecycleTime
> to '720' minute(s) as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaximumMemoryLimit to '80' percent as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaxQueueThreads to '0' thread(s) as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaxScheduleWait to '5' second(s) as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> DatabaseQueryTimeout to '120' second(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing InstanceName
> to 'MSSQLSERVER' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> ProcessRecycleOptions to '0' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> RunningRequestsDbCycle to '60' second(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> RunningRequestsAge to '30' second(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> CleanupCycleMinutes to '10' minute(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> SecureConnectionLevel to '0' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> DisplayErrorLink to 'True' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it
> was not specified in Configuration file.
> w3wp!resourceutilities!208!7/22/2005-09:31:31:: i INFO: Running on 2
> physical processors, 2 logical processors
> w3wp!resourceutilities!208!7/22/2005-09:31:31:: i INFO: Reporting
> Services starting SKU: Standard
> w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Database Cleanup (Web
> Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
> w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Running Requests
> Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Running Requests DB
> timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Memory stats update
> timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!crypto!208!07/22/2005-09:31:32:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!208!07/22/2005-09:31:32:: i INFO: Exporting public key
> w3wp!webserver!208!07/22/2005-09:31:32:: e ERROR: Internal error:
> System.IO.FileNotFoundException: The system cannot find the file
> specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at
> Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at
> Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!library!208!07/22/2005-09:31:32:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at
> Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at
> Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> w3wp!crypto!5d0!7/22/2005-09:32:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!5d0!7/22/2005-09:32:31:: i INFO: Exporting public key
> w3wp!library!5d0!7/22/2005-09:32:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at
> Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!crypto!5d0!7/22/2005-09:33:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!5d0!7/22/2005-09:33:31:: i INFO: Exporting public key
> w3wp!library!5d0!7/22/2005-09:33:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at
> Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!crypto!208!7/22/2005-09:34:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!208!7/22/2005-09:34:31:: i INFO: Exporting public key
> w3wp!library!208!7/22/2005-09:34:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at
> Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!crypto!208!7/22/2005-09:35:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!208!7/22/2005-09:35:31:: i INFO: Exporting public key
> w3wp!library!208!7/22/2005-09:35:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at
> Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!crypto!208!7/22/2005-09:36:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!208!7/22/2005-09:36:31:: i INFO: Exporting public key
> w3wp!library!208!7/22/2005-09:36:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot

rserroropeningconnection SQL RS 2000

I have configured a user as content manager in security settings for a data source and trying to execute the report under his credentials, but i keep getting the error

RSErrorOpeningConnection login failed for user <domain>\<username>

I have set windows authentication for the data source

Can anyone please help...

have u selected the checkbox in your datasource like this....

Use as Windows credentials when connecting to the data source..

|||

I selected the last but one option --

Windows NT Integrated Security

rsAccessDenied even for the Content Manager role

I have the Content Manager rights on a folder and on a report for my user.
When I try to edit ther report properties I got the error
the permissions granted to user `domain\user` are insufficient for
performing this operation (rsAccessDenied)
I am able to upload, create folders, create data source, upload file, but
not to view the report properties
--
AlexSounds like someone changed the Security for that Particular report, so you
can't mess with it...
All of the things you can do, have perms at the folder level...Report
properties can be set at the report level, so if someone removed
ContentManager Role from the specific report, you'd get the behaviour you are
seeing..
Hope this helps.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
See you at the PASS Conference!
"Alex" wrote:
> I have the Content Manager rights on a folder and on a report for my user.
> When I try to edit ther report properties I got the error
> the permissions granted to user `domain\user` are insufficient for
> performing this operation (rsAccessDenied)
> I am able to upload, create folders, create data source, upload file, but
> not to view the report properties
> --
> Alex|||I just verified it and It has the Content Manager perms
I even created a new folder with the builtin\Administrators Content
Manager and the Server\user Content Manager too.
I checked the report's security tab, and in all the reports in that folder I
have both, the Builtin\Administrators Content Manager and the Server\user
Content Manager permissions.
But Still having the rsAccessDenied Error
I would appreciate very much any help about it
Thanks
--
Alex
"Wayne Snyder" wrote:
> Sounds like someone changed the Security for that Particular report, so you
> can't mess with it...
> All of the things you can do, have perms at the folder level...Report
> properties can be set at the report level, so if someone removed
> ContentManager Role from the specific report, you'd get the behaviour you are
> seeing..
> Hope this helps.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
> See you at the PASS Conference!
>
> "Alex" wrote:
> > I have the Content Manager rights on a folder and on a report for my user.
> >
> > When I try to edit ther report properties I got the error
> > the permissions granted to user `domain\user` are insufficient for
> > performing this operation (rsAccessDenied)
> >
> > I am able to upload, create folders, create data source, upload file, but
> > not to view the report properties
> >
> > --
> > Alex|||I had the same problem you described and fixed it by granting the NT group
the 'Content Manager' permissions at the 'Root' of the Report Server site.
After doing this the permissions were applied correctly to the Folders
underneath this.
Hope this helps.
Diran
"Alex" wrote:
> I just verified it and It has the Content Manager perms
> I even created a new folder with the builtin\Administrators Content
> Manager and the Server\user Content Manager too.
> I checked the report's security tab, and in all the reports in that folder I
> have both, the Builtin\Administrators Content Manager and the Server\user
> Content Manager permissions.
> But Still having the rsAccessDenied Error
> I would appreciate very much any help about it
> Thanks
> --
> Alex
>
> "Wayne Snyder" wrote:
> > Sounds like someone changed the Security for that Particular report, so you
> > can't mess with it...
> >
> > All of the things you can do, have perms at the folder level...Report
> > properties can be set at the report level, so if someone removed
> > ContentManager Role from the specific report, you'd get the behaviour you are
> > seeing..
> >
> > Hope this helps.
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> >
> > I support the Professional Association for SQL Server ( PASS) and it''s
> > community of SQL Professionals.
> > See you at the PASS Conference!
> >
> >
> > "Alex" wrote:
> >
> > > I have the Content Manager rights on a folder and on a report for my user.
> > >
> > > When I try to edit ther report properties I got the error
> > > the permissions granted to user `domain\user` are insufficient for
> > > performing this operation (rsAccessDenied)
> > >
> > > I am able to upload, create folders, create data source, upload file, but
> > > not to view the report properties
> > >
> > > --
> > > Alex|||Thanks Diran,
It worked, I just granted the "My Reports" permissions.
Thanks again!
--
Alex
"Diran" wrote:
> I had the same problem you described and fixed it by granting the NT group
> the 'Content Manager' permissions at the 'Root' of the Report Server site.
> After doing this the permissions were applied correctly to the Folders
> underneath this.
> Hope this helps.
> Diran
>
> "Alex" wrote:
> > I just verified it and It has the Content Manager perms
> >
> > I even created a new folder with the builtin\Administrators Content
> > Manager and the Server\user Content Manager too.
> >
> > I checked the report's security tab, and in all the reports in that folder I
> > have both, the Builtin\Administrators Content Manager and the Server\user
> > Content Manager permissions.
> >
> > But Still having the rsAccessDenied Error
> >
> > I would appreciate very much any help about it
> > Thanks
> >
> > --
> > Alex
> >
> >
> > "Wayne Snyder" wrote:
> >
> > > Sounds like someone changed the Security for that Particular report, so you
> > > can't mess with it...
> > >
> > > All of the things you can do, have perms at the folder level...Report
> > > properties can be set at the report level, so if someone removed
> > > ContentManager Role from the specific report, you'd get the behaviour you are
> > > seeing..
> > >
> > > Hope this helps.
> > > --
> > > Wayne Snyder MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > >
> > > I support the Professional Association for SQL Server ( PASS) and it''s
> > > community of SQL Professionals.
> > > See you at the PASS Conference!
> > >
> > >
> > > "Alex" wrote:
> > >
> > > > I have the Content Manager rights on a folder and on a report for my user.
> > > >
> > > > When I try to edit ther report properties I got the error
> > > > the permissions granted to user `domain\user` are insufficient for
> > > > performing this operation (rsAccessDenied)
> > > >
> > > > I am able to upload, create folders, create data source, upload file, but
> > > > not to view the report properties
> > > >
> > > > --
> > > > Alex

rsAccessDenied and

I have installed Reporting Services on a production server that host a
website using SQL Express. I have set up RS in the RS configuration manager
and got green button all the way down
Requesting http://www.xx.dk/reports replies:
The request failed with HTTP status 400: Bad Request.
Requesting http://www.xx.dk/reportserver replies:
The permissions granted to user 'TF4\ms' are insufficient for performing
this operation. (rsAccessDenied)
Any idea what the problem might be ?
--
Paul SHello Paul,
Based on my research, please check the following settings:
1. Make sure you disable the Anynomous Access on IIS for the reporting
services virtual directory.
2. Make sure you enable Windows Authentication on IIS
3. Make sure you have use the rsconfig utility to connect to the correct
SQL Instance for the report server.
4. Make sure you are using a correct identity for the application pool the
reporting services using. Please try to use a domain account with local
admin privilage to have a check.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||1)
Anynomous Access is disabled for the reportServer dir. and the reports dir.
but not for the parent dir - the original dir for the website.
2)
Windows Authentication is enabled for the reports and the reportserver dir.
3)
I only have one - it's correct
4)
The application pool for both the ReportServer and the Report manager is
DefaultAppPool
ps. In database setup the credentials type is Service credentials
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> Based on my research, please check the following settings:
> 1. Make sure you disable the Anynomous Access on IIS for the reporting
> services virtual directory.
> 2. Make sure you enable Windows Authentication on IIS
> 3. Make sure you have use the rsconfig utility to connect to the correct
> SQL Instance for the report server.
> 4. Make sure you are using a correct identity for the application pool the
> reporting services using. Please try to use a domain account with local
> admin privilage to have a check.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hello Paul,
1. Please run the rsconfig utility to specify a new connection to the sql
server:
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
2. Please recreate an application pool for the report server and use a
domain account which have local admin privilage as the identity to have a
try.
Please let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei Lu
Your suggestions gave the follwing:
1)
No Reporting Services instance found on localhost.
2)
I created a new user with local admin rights and used him when I created a
new app pool for the reports server - the report manager still uses
DefaultAppPool.
Why is it talking about localhost - I'm not using localhost. The values
specifid in the RS Configuration manager for Report Server Virtual Directory
is:
Name: ReportServer, Website xxx
accessing http://www.xxx.dk/reports gives
The request failed with HTTP status 400: Bad Request.
acessing http://www.xxx.dk/reportserver still gives The permissions granted
to user 'TF4\ms' are insufficient for performing this operation.
(rsAccessDenied)|||Hello Paul,
I would like to get the RSWebApplication.config file and
rsreportserver.config file in the report manager and report server folder.
By default, these two folders is located at :C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\
Also, please send me the screenshot for the Configuration Tool. Make sure
you have a default instance installed in the server.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you. To get my real email addresss, please
remove the ONLINE in my display mail.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I've send you the information needed
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Paul,
From your rsreportserver.config file, I did not see the LogonUser
credential is applied. So please use the rsconfig utility to specify the
credential to connect to SQL Server Report Server.
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Hello Wei
I get an error message saying
'No reporting services instance found on localhost'
when I run the rsconfig utility
I have been going through this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=143931&SiteID=1
but I have the folders mentioned.
Paul S
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> From your rsreportserver.config file, I did not see the LogonUser
> credential is applied. So please use the rsconfig utility to specify the
> credential to connect to SQL Server Report Server.
> rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================.
>|||Hello Paul,
According to your email, I found that you are going to configure your
Express instance in your computer.
Please try the following:
rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
<SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Issuing that command was what gave me the
'No reporting services instance found on localhost'
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> According to your email, I found that you are going to configure your
> Express instance in your computer.
> Please try the following:
> rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
> <SAPASSWORD>
>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hello Paul,
I would like to know how many instances you installed in the machine.
Pleas run the MPS Report .
--
a. Download MPSReport tool from below URL:
<
http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9
15706/MPSRPT_SETUPPerf.EXE>
b. Execute the tool on the computer, and if you are prompted "Include the
MSINFO32 report?", please type Y.
c. Please send the result file (CAB file) to me
To reach me, please remove the ONLINE in my display email address.
For detailed information about the MPS Report Tools, please refer to the
following link:
Microsoft Product Support's Reporting Tools
<http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F
-88B7-F9C79B7306C0&displaylang=en>
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi
I have just send you the described CAB file
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

RS2005 setup blues

I installed RS2005(SP2) with a SQL2000(sp4) db. Both are on seperate Windoes 2003 servers. I configured the reports manager to connect to a different web site on the same server instead of default web site. There were no installation prohlems. The RS server is up and running , all the virtual directories setup etc. When I try to access the reports directory via: http://dev2/Reports or browse the reports virtual directory from IIS, I get a 401 access denied error. The RS log reads:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>D:\ReportingServices2005\MSSQL.1\Reporting Services\LogFiles\ReportServerWebApp__07_10_2007_11_29_21.log</Path>
<SystemName>NWISTCST99</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!7/10/2007-11:29:30:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!5!7/10/2007-11:29:31:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

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 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.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!7/10/2007-11:29:32:: 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)

Please advise.

The RSweApplication.config in the ReportManager folder has the fully qualified URL to ReportServer<ReportServerUrl> and I have blanked out the <ReportServerVirtualDirectory>

Also the <UrlRoot> in rsreportserver.config in ReportServer folder points to the fully qualified URL to ReportServer.

What am I missing here ..?

Hello,

Can you hit http://<server>/ReportServer? This is the underlying worker site for the Web Application found at http://<server>/Reports.

Here is a blog post on troubleshooting 401 errors with IIS: http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx

You could be having a Kerberos issue because SQL and IIS are on different servers. Here is an blog post from Brian Kelley on troubleshooting Kerberos: http://blogs.sqlservercentral.com/blogs/brian_kelley/archive/2006/04/05/568.aspx.

Let me know if this doesn't help.

Larry

|||

When I try http://<web site>/ReportServer, I can get to it. It comes up with a version number:

10.32.12.204/ReportServer - /

Microsoft SQL Server Reporting Services Version 9.00.3042.00

I had the virtual directories set up for Integtated windows authentication only.

When I enable anonymous access, I do not get the 401 error but there is no way I can create folders, subscriptions set up users etc. There are only 3 links: Home (to the reports directory). My subscriptions that is empty (There are no items to show in this view) and a help link.

Something is missing here ...

|||

Setting the sites to use anonymous and having it work means that it is an IIS permissions issue, thus, a SSRS configuration issue. Your installation worked. Try changing the configuration file to use the IP address or the Fully Qualified Domain Name for the Report Server location. Take a look at the 401 troubleshooting article and see if it can help you track down the problem.

The reason that you can't do anything as anonymous is that the anonymous user does not have any rights in SSRS by default. For testing purposes, you could change the accound used for anonymous access (IUSR_<machine name>) to an account with Admin rights and you would be able to manage SSRS. By default, all Admins are given full rights to an SSRS installation.

Larry

|||

thanks a lot Larry,

change the config files from name to hard coded IP address resolved the issue. I had already re-installed RS and IIS and was running out of options.

|||

No problem! Glad to hear that it worked out!

Larry

RS2005 June CTP Reserved.ReportViewerWebControl.axd - what is it?

Running a simple report in Report Manager. Try to export to Web Archive and
it wants to download Reserved.ReportViewerWebControl.axd but I can't seem to
find any information about how to use this file. What is AXD - it's not
listed on the internet.Most likely this is happening because you don't have any application
registered for the .MHTML file extension on the machine where you are
exporting. You should still be able to export by just typing in a file name
with a .mhtml file extension.
This should be fixed in later RS 2005 builds.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in message
news:96E0FDED-02A1-49BA-AB1E-37DDAF4B84BA@.microsoft.com...
> Running a simple report in Report Manager. Try to export to Web Archive
> and
> it wants to download Reserved.ReportViewerWebControl.axd but I can't seem
> to
> find any information about how to use this file. What is AXD - it's not
> listed on the internet.|||Thanks for the reply. However I've tried this on 2 machines now both with
MHTML as a registered file type.
On the server (Win2003), MHTML is registered to iexplore. On my own dev PC
(Win XP) it's msohtmed. The symptoms remain the same on both.
I do have another issue with url access crashing (bug 564712370)
Exception type: InvalidConfigFileTypeException
Exception message: The type
Microsoft.ReportingServices.UI.WebControlConnection,
ReportingServicesWebUserInterface
Could these be related?
Chris
"Robert Bruckner [MSFT]" wrote:
> Most likely this is happening because you don't have any application
> registered for the .MHTML file extension on the machine where you are
> exporting. You should still be able to export by just typing in a file name
> with a .mhtml file extension.
> This should be fixed in later RS 2005 builds.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in message
> news:96E0FDED-02A1-49BA-AB1E-37DDAF4B84BA@.microsoft.com...
> > Running a simple report in Report Manager. Try to export to Web Archive
> > and
> > it wants to download Reserved.ReportViewerWebControl.axd but I can't seem
> > to
> > find any information about how to use this file. What is AXD - it's not
> > listed on the internet.
>
>

RS2005 insufficient permissions

So when I run the report in the Report Manager, everything is all good. When
I run it in a webform using report viewer for vs.net 2005 the view reports
this error.
"The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are
insufficient for performing this operation(rsAccessDenied)"
What interesting when RS2005 install on XP Professional setting for
webservice identity shows ASPNET and reports work on that machine in report
viewer control. But when running on Windows 2003 Server, it uses default pool
and NETWORK SERVICE ACCOUNT by default which I think is the problem. Any idea
or anyone run into this.Curious if anyone now the bare minimum to run 2005 report in a webform.aspx
using report viewer. ASPNET was enough on XP Pro runnng RS2005 locally. But
it's different on a Server. This is obviously a good thing, wondered how I
can find the bare minimum without assigning Everyone as I discovered fixed
the problem below:
Well thought post the hack on this one. So what I ended testing and showed
success, in report manager I temporarily aded new role, "Everyone" with
browse only rights on the Home directory security roles in report manager,
now the report loads.
----
I would like to let people now, we where in a crunch to get it working, but
would love to hear how RS2005 has maybe been change to use forms
authentication or some solution for people that now danger running ASPNET
identity to access sensitive data, but have their surround website secured.
---
So my next step:
1) revert securty at Home level on report manager to only Administrator role.
2) add folder for reports and deploy the reports to the new folder on the
report server
3) use seperate permissions on folder then the home root. For newbie, you do
this by clicking on the folder in report manager, click properties and
security. Then use new role and choose yes to warning that you want these
roles seperate from home security. This allows the report to run in our
webform.aspx as the website is protect with form authentications.
"Rob G" wrote:
> So when I run the report in the Report Manager, everything is all good. When
> I run it in a webform using report viewer for vs.net 2005 the view reports
> this error.
> "The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are
> insufficient for performing this operation(rsAccessDenied)"
> What interesting when RS2005 install on XP Professional setting for
> webservice identity shows ASPNET and reports work on that machine in report
> viewer control. But when running on Windows 2003 Server, it uses default pool
> and NETWORK SERVICE ACCOUNT by default which I think is the problem. Any idea
> or anyone run into this.
>|||When you were developing before (everything on one machine) you were the
administrator on the machine and that is why everything worked. What I do is
have a local group, I add domain users and groups to that (for instance add
a group called Reports). Give them browse rights at home. The other folders
will inherit. In most cases all the users have rights to all the folders. If
not, change for the specific folder.
You definitely do not want to do anonymous.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob G" <RobG@.discussions.microsoft.com> wrote in message
news:2C5D679B-E5CD-4ECF-8F44-00E47F5DAB3E@.microsoft.com...
> Curious if anyone now the bare minimum to run 2005 report in a
> webform.aspx
> using report viewer. ASPNET was enough on XP Pro runnng RS2005 locally.
> But
> it's different on a Server. This is obviously a good thing, wondered how I
> can find the bare minimum without assigning Everyone as I discovered fixed
> the problem below:
> Well thought post the hack on this one. So what I ended testing and showed
> success, in report manager I temporarily aded new role, "Everyone" with
> browse only rights on the Home directory security roles in report manager,
> now the report loads.
> ----
> I would like to let people now, we where in a crunch to get it working,
> but
> would love to hear how RS2005 has maybe been change to use forms
> authentication or some solution for people that now danger running ASPNET
> identity to access sensitive data, but have their surround website
> secured.
> ---
> So my next step:
> 1) revert securty at Home level on report manager to only Administrator
> role.
> 2) add folder for reports and deploy the reports to the new folder on the
> report server
> 3) use seperate permissions on folder then the home root. For newbie, you
> do
> this by clicking on the folder in report manager, click properties and
> security. Then use new role and choose yes to warning that you want these
> roles seperate from home security. This allows the report to run in our
> webform.aspx as the website is protect with form authentications.
>
>
> "Rob G" wrote:
>> So when I run the report in the Report Manager, everything is all good.
>> When
>> I run it in a webform using report viewer for vs.net 2005 the view
>> reports
>> this error.
>> "The permissions granted to the user 'NT AUTHORITY\NETWORK SERVICE' are
>> insufficient for performing this operation(rsAccessDenied)"
>> What interesting when RS2005 install on XP Professional setting for
>> webservice identity shows ASPNET and reports work on that machine in
>> report
>> viewer control. But when running on Windows 2003 Server, it uses default
>> pool
>> and NETWORK SERVICE ACCOUNT by default which I think is the problem. Any
>> idea
>> or anyone run into this.
>>

RS2005 Access Error Using Report Manager Via DNS

PROBLEM:
Created a DNS entry (reportsdev) to access reporting services.
I can NOT ACCESS the report manager and receive an error
http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
I CAN ACCESS the report server with out a problem via IE and VS2005.
http://reportsdev/ReportServer$SQLServer2005
ERROR:
â'The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.â'
This is a reporting services error with the reporting services UI wrapped
around the error and the link to Home. Clicking the link to Home generates
the same error.
NOTES & Tentative Solution:
I CAN ACCESS the report manager by configuring the report site with a port
rather then host header.
http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
If I restart IIS and then access the report manager using the DNS an error
is logged in the Application Log â'Report Manager cannot connect to the
ReportServer service.â'
Configuration:
Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
install of 2005). RS2000 was on the machine until a restore but after the
restore was not reinstalled the RS2000 databases have been removed from
SQL2000 after the restore.
Any help is appreciated,
TedTed,
Did you update the entry in RSWebApplication.config to match your
report server DNS entry?
Andy Potter|||the same problem persists to me although i have modified the entry in
RSWebApplication.config
when I first installed the reporting services 2005, I wanted to use as
server the older one (sql + reporting 2000). I couldn't figure out what's the
problem and I thought that may be an incompatibility beteen sql 200 and
RS2005 and RS 2000 all toghther on the same server. After this I have
installed a new instance of SQL 2005 and the RS 2005...but I had the same
error (The attempt to connect to the report server failed. Check your
connection
information and that the report server is a compatible version)
...until I droped the ideea of using host header (right now I use a simple
asp page to redirect...but this is not the final solution that I want).
still, I want to use a host header...anyone figure it out how to?
"Potter" wrote:
> Ted,
> Did you update the entry in RSWebApplication.config to match your
> report server DNS entry?
> Andy Potter
>|||I am havin the same problem!
I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
are using Windows Server 2003 SP1. I get the following error:
Microsoft Report Designer
A connection could not be made to the report server
Check your connection information and that the report server is a compatible
version.
nickpup
"tbarton" wrote:
> PROBLEM:
> Created a DNS entry (reportsdev) to access reporting services.
> I can NOT ACCESS the report manager and receive an error
> http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> I CAN ACCESS the report server with out a problem via IE and VS2005.
> http://reportsdev/ReportServer$SQLServer2005
>
> ERROR:
> â'The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.â'
> This is a reporting services error with the reporting services UI wrapped
> around the error and the link to Home. Clicking the link to Home generates
> the same error.
>
> NOTES & Tentative Solution:
> I CAN ACCESS the report manager by configuring the report site with a port
> rather then host header.
> http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> If I restart IIS and then access the report manager using the DNS an error
> is logged in the Application Log â'Report Manager cannot connect to the
> ReportServer service.â'
>
> Configuration:
> Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> install of 2005). RS2000 was on the machine until a restore but after the
> restore was not reinstalled the RS2000 databases have been removed from
> SQL2000 after the restore.
> Any help is appreciated,
> Ted
>|||I finally managed to solve this problem
open SQl Books Online at this page:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/a0134ef0-086c-443e-93b9-7213a3d76393.htm
and check the explanations about ReportServerVirtualDirectory and
ReportServerUrl
"ReportServerUrl and ReportServerVirtualDirectory are mutually exclusive. If
you specify ReportServerUrl, you must delete the entry for
ReportServerVirtualDirectory"
"nickpup" wrote:
> I am havin the same problem!
> I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
> are using Windows Server 2003 SP1. I get the following error:
> Microsoft Report Designer
> A connection could not be made to the report server
> Check your connection information and that the report server is a compatible
> version.
> nickpup
>
> "tbarton" wrote:
> > PROBLEM:
> > Created a DNS entry (reportsdev) to access reporting services.
> > I can NOT ACCESS the report manager and receive an error
> > http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> >
> > I CAN ACCESS the report server with out a problem via IE and VS2005.
> > http://reportsdev/ReportServer$SQLServer2005
> >
> >
> > ERROR:
> > â'The attempt to connect to the report server failed. Check your connection
> > information and that the report server is a compatible version.â'
> >
> > This is a reporting services error with the reporting services UI wrapped
> > around the error and the link to Home. Clicking the link to Home generates
> > the same error.
> >
> >
> > NOTES & Tentative Solution:
> > I CAN ACCESS the report manager by configuring the report site with a port
> > rather then host header.
> > http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> >
> > If I restart IIS and then access the report manager using the DNS an error
> > is logged in the Application Log â'Report Manager cannot connect to the
> > ReportServer service.â'
> >
> >
> > Configuration:
> > Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> > install of 2005). RS2000 was on the machine until a restore but after the
> > restore was not reinstalled the RS2000 databases have been removed from
> > SQL2000 after the restore.
> >
> > Any help is appreciated,
> >
> > Ted
> >|||also check this page:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/1571c3fb-53a1-4bdd-bde6-0b8d490bf823.htm
"dragoon" wrote:
> I finally managed to solve this problem
> open SQl Books Online at this page:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/a0134ef0-086c-443e-93b9-7213a3d76393.htm
> and check the explanations about ReportServerVirtualDirectory and
> ReportServerUrl
> "ReportServerUrl and ReportServerVirtualDirectory are mutually exclusive. If
> you specify ReportServerUrl, you must delete the entry for
> ReportServerVirtualDirectory"
> "nickpup" wrote:
> > I am havin the same problem!
> >
> > I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
> > are using Windows Server 2003 SP1. I get the following error:
> >
> > Microsoft Report Designer
> >
> > A connection could not be made to the report server
> >
> > Check your connection information and that the report server is a compatible
> > version.
> >
> > nickpup
> >
> >
> > "tbarton" wrote:
> >
> > > PROBLEM:
> > > Created a DNS entry (reportsdev) to access reporting services.
> > > I can NOT ACCESS the report manager and receive an error
> > > http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> > >
> > > I CAN ACCESS the report server with out a problem via IE and VS2005.
> > > http://reportsdev/ReportServer$SQLServer2005
> > >
> > >
> > > ERROR:
> > > â'The attempt to connect to the report server failed. Check your connection
> > > information and that the report server is a compatible version.â'
> > >
> > > This is a reporting services error with the reporting services UI wrapped
> > > around the error and the link to Home. Clicking the link to Home generates
> > > the same error.
> > >
> > >
> > > NOTES & Tentative Solution:
> > > I CAN ACCESS the report manager by configuring the report site with a port
> > > rather then host header.
> > > http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> > >
> > > If I restart IIS and then access the report manager using the DNS an error
> > > is logged in the Application Log â'Report Manager cannot connect to the
> > > ReportServer service.â'
> > >
> > >
> > > Configuration:
> > > Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> > > install of 2005). RS2000 was on the machine until a restore but after the
> > > restore was not reinstalled the RS2000 databases have been removed from
> > > SQL2000 after the restore.
> > >
> > > Any help is appreciated,
> > >
> > > Ted
> > >