API tools faq
paste
Advertisement
Guest User

Diagnosing Intermittent SSRS 2008 Report Error

a guest
Mar 28th, 2012
310
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.37 KB | None | 0 0
raw download clone embed print report
  1. appdomainmanager!DefaultDomain!14cc!05/30/2011-15:57:19:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-129512086394759387 started.
  2.  
  3. appdomainmanager!ReportManager_0-1!14cc!05/30/2011-15:57:19:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/Reports.
  4.  
  5. appdomainmanager!DefaultDomain!14cc!05/30/2011-15:57:19:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-129512086394759387 initialized (#1).
  6.  
  7. library!WindowsService_0!18c8!05/30/2011-15:57:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.;
  8.  
  9. library!WindowsService_0!18c8!05/30/2011-15:57:20:: e ERROR: Sql error while calling GetDBVersion:Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
  10.  
  11. dbpolling!WindowsService_0!18c8!05/30/2011-15:57:20:: e ERROR: PollingMaintenance: Restarting maintenance thread for the following exception: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.).
  12.  
  13. appdomainmanager!DefaultDomain!1600!05/30/2011-15:57:21:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-129512086415541036 started.
  14.  
  15. appdomainmanager!ReportServer_0-2!1600!05/30/2011-15:57:21:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
  16.  
  17. appdomainmanager!DefaultDomain!1600!05/30/2011-15:57:22:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-129512086415541036 initialized (#1).
  18.  
  19. library!WindowsService_0!18c8!05/30/2011-15:57:23:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
  20. Login failed for user 'NSWDOHsys_NS_SQLServer2k8'.
  21. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  22. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  23. at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  24. at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
  25. at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
  26. at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
  27. at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
  28. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
  29. at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
  30. at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
  31. at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
  32. at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
  33. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
  34. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
  35. at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
  36. at System.Data.SqlClient.SqlConnection.Open()
  37. at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
  38. --- End of inner exception stack trace ---;
  39.  
  40. dbpolling!WindowsService_0!18c8!05/30/2011-15:57:23:: e ERROR: PollingMaintenance: Restarting maintenance thread for the following exception: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
  41. Login failed for user 'NSWDOHsys_NS_SQLServer2k8'..
  42.  
  43. webserver!ReportServer_0-2!1600!05/30/2011-15:57:26:: i INFO: Reporting Web Server started
  44.  
  45. resourceutilities!ReportServer_0-2!1600!05/30/2011-15:57:26:: i INFO: Reporting Services starting SKU: Developer
  46.  
  47. library!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Catalog SQL Server Edition = Developer
  48.  
  49. crypto!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Initializing crypto as user: NSWDOHsys_NS_SQLServer2k8
  50.  
  51. crypto!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Exporting public key
  52.  
  53. crypto!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Performing sku validation
  54.  
  55. crypto!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Importing existing encryption key
  56.  
  57. library!WindowsService_0!18c8!05/30/2011-15:57:29:: i INFO: PollingMaintenance: Polling cycle completed.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!