Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
kulfi
Starting Member
33 Posts |
Posted - 2011-02-08 : 11:15:17
|
what should be the settings in sql configuration manager for network server thanksEhsan |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
kulfi
Starting Member
33 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
kulfi
Starting Member
33 Posts |
Posted - 2011-02-09 : 13:19:48
|
HI, WHEN I SELECT SQL SERVER CONFIGURATION MANAGER AND SELECT SQL SERVER SERVICES IN THE LEFT PORTION AND IN THE RIGHT PORTION ARESQL SERVER INTEGRATION SERVICES 10.0 " IT IS running"SQL SERVER (sqlexpress) "it is stopped"sql full-text filter daemon luncher (mssqlserver)"It is running"sql server (mssqlserver) "it is stopped"sql server Analysis services (mssqlserver)"it is running"sql server reporting services (mssqlserver)"it is running"sql server agent (sqlexpress)"it is stopped"sql server browser"It is running"sql server agent (mssqlserver) "it is stopped"these are the parameters i can see in my manager please can u tell me what is wrong.thanksquote: Originally posted by tkizer You haven't provided the error, so how could I tell you why?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Ehsan |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
kulfi
Starting Member
33 Posts |
|
kulfi
Starting Member
33 Posts |
Posted - 2011-02-10 : 08:46:34
|
<Header> <Product>Microsoft SQL Server Reporting Services Version 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )</Product> <Locale>English (United Kingdom)</Locale> <TimeZone></TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__02_10_2011_16_20_36.log</Path> <SystemName>ABDULREHMAN</SystemName> <OSName>Microsoft Windows NT 6.1.7600</OSName> <OSVersion>6.1.7600</OSVersion> <ProcessID>3504</ProcessID></Header>rshost!rshost!dd8!02/10/2011-16:20:36:: i INFO: CLR runtime is initialized.rshost!rshost!dd8!02/10/2011-16:20:36:: i INFO: Derived memory configuration based on physical memory as 2097024 KBappdomainmanager!DefaultDomain!df8!02/10/2011-16:20:37:: i INFO: Entered managed ServiceMain in DefaultDomain.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing AuthenticationTypes to '5' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing EnableAuthPersistence to 'True' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.library!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Initializing IsReportManagerEnabled to 'True' as specified in Configuration file.configmanager!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Using report server internal url http://localhost:80/ReportServer.configmanager!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Using report server external url http://ABDULREHMAN:80/ReportServer.configmanager!DefaultDomain!e00!02/10/2011-16:20:37:: i INFO: Using url root http://ABDULREHMAN:80/ReportServer.library!DefaultDomain!e00!02/10/2011-16:20:58:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---appdomainmanager!DefaultDomain!e00!02/10/2011-16:20:58:: i INFO: Appdomain:2 WindowsService_0 started.resourceutilities!WindowsService_0!e00!02/10/2011-16:20:58:: i INFO: Reporting Services starting SKU: Enterpriseresourceutilities!WindowsService_0!e00!02/10/2011-16:20:58:: i INFO: Evaluation copy: 0 days leftresourceutilities!WindowsService_0!e00!02/10/2011-16:20:58:: i INFO: Running on 2 physical processors, 4 logical processorsrshost!rshost!e7c!02/10/2011-16:20:58:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer.rshost!rshost!e7c!02/10/2011-16:20:58:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2rshost!rshost!f28!02/10/2011-16:20:58:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.rshost!rshost!f28!02/10/2011-16:20:58:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3rshost!rshost!102c!02/10/2011-16:20:58:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.rshost!rshost!e00!02/10/2011-16:20:58:: i INFO: Derived memory configuration based on physical memory as 2097024 KBservicecontroller!DefaultDomain!e7c!02/10/2011-16:20:58:: i INFO: Total Physical memory: 3210330112rpcserver!DefaultDomain!102c!02/10/2011-16:20:58:: i INFO: Process monitoring started.library!WindowsService_0!e6c!02/10/2011-16:21:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!WindowsService_0!e6c!02/10/2011-16:21:17:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart)library!WindowsService_0!e6c!02/10/2011-16:21:17:: e ERROR: ServiceStartThread: Attempting to start service again...rpcserver!DefaultDomain!e6c!02/10/2011-16:21:17:: i INFO: RPC Server started.servicecontroller!DefaultDomain!e6c!02/10/2011-16:21:17:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10.MSSQLSERVER'library!DefaultDomain!f28!02/10/2011-16:36:51:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!DefaultDomain!1028!02/10/2011-16:37:22:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!DefaultDomain!1028!02/10/2011-16:37:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!DefaultDomain!fa4!02/10/2011-16:37:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!DefaultDomain!fa4!02/10/2011-16:37:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!DefaultDomain!fa4!02/10/2011-16:37:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!DefaultDomain!fa4!02/10/2011-16:38:44:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!DefaultDomain!1028!02/10/2011-16:39:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!DefaultDomain!1028!02/10/2011-16:39:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---quote: Originally posted by kulfi when i run the stopped service this is the message i get the request failed or the service did not respond in a timely fashion. consult the event log or other applicable error logs for detailsquote: Originally posted by tkizer You haven't provided the error. What happens when you try to start them? Have you checked the Application Log in Event Viewer?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Ehsan
Ehsan |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-02-10 : 09:02:45
|
Why are you sending the Reporting Services log, when it's SQL Agent that won't start?quote: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__02_10_2011_16_20_36.log
N 56°04'39.26"E 12°55'05.63" |
 |
|
kulfi
Starting Member
33 Posts |
Posted - 2011-02-10 : 23:37:17
|
hi, this is what u need can u please let me knoe what is the problemthanks<Header> <Product>Microsoft SQL Server Reporting Services Version 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )</Product> <Locale>English (United Kingdom)</Locale> <TimeZone></TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__02_11_2011_07_30_22.log</Path> <SystemName>ABDULREHMAN</SystemName> <OSName>Microsoft Windows NT 6.1.7600</OSName> <OSVersion>6.1.7600</OSVersion> <ProcessID>3424</ProcessID></Header>rshost!rshost!d88!02/11/2011-07:30:22:: i INFO: CLR runtime is initialized.rshost!rshost!d88!02/11/2011-07:30:22:: i INFO: Derived memory configuration based on physical memory as 2097024 KBappdomainmanager!DefaultDomain!da8!02/11/2011-07:30:23:: i INFO: Entered managed ServiceMain in DefaultDomain.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing AuthenticationTypes to '5' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing EnableAuthPersistence to 'True' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.library!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Initializing IsReportManagerEnabled to 'True' as specified in Configuration file.configmanager!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Using report server internal url http://localhost:80/ReportServer.configmanager!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Using report server external url http://ABDULREHMAN:80/ReportServer.configmanager!DefaultDomain!db0!02/11/2011-07:30:24:: i INFO: Using url root http://ABDULREHMAN:80/ReportServer.library!DefaultDomain!db0!02/11/2011-07:30:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---appdomainmanager!DefaultDomain!db0!02/11/2011-07:30:45:: i INFO: Appdomain:2 WindowsService_0 started.resourceutilities!WindowsService_0!db0!02/11/2011-07:30:45:: i INFO: Reporting Services starting SKU: Enterpriseresourceutilities!WindowsService_0!db0!02/11/2011-07:30:45:: i INFO: Evaluation copy: 0 days leftresourceutilities!WindowsService_0!db0!02/11/2011-07:30:45:: i INFO: Running on 2 physical processors, 4 logical processorsrshost!rshost!e2c!02/11/2011-07:30:45:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer.rshost!rshost!e2c!02/11/2011-07:30:45:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2rshost!rshost!ee0!02/11/2011-07:30:45:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.rshost!rshost!ee0!02/11/2011-07:30:45:: i INFO: Registered url=http://192.168.1.69:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.rshost!rshost!ee0!02/11/2011-07:30:45:: i INFO: Currently registered url http://192.168.1.69:80/Reports/ on endpoint 3rshost!rshost!ee0!02/11/2011-07:30:45:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3rshost!rshost!113c!02/11/2011-07:30:45:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.rshost!rshost!db0!02/11/2011-07:30:45:: i INFO: Derived memory configuration based on physical memory as 2097024 KBservicecontroller!DefaultDomain!e2c!02/11/2011-07:30:45:: i INFO: Total Physical memory: 3210330112rpcserver!DefaultDomain!113c!02/11/2011-07:30:45:: i INFO: Process monitoring started.library!WindowsService_0!e1c!02/11/2011-07:31:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---library!WindowsService_0!e1c!02/11/2011-07:31:04:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart)library!WindowsService_0!e1c!02/11/2011-07:31:04:: e ERROR: ServiceStartThread: Attempting to start service again...rpcserver!DefaultDomain!e1c!02/11/2011-07:31:04:: i INFO: RPC Server started.servicecontroller!DefaultDomain!e1c!02/11/2011-07:31:04:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10.MSSQLSERVER'quote: Originally posted by Peso Why are you sending the Reporting Services log, when it's SQL Agent that won't start?quote: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__02_10_2011_16_20_36.log
N 56°04'39.26"E 12°55'05.63"
Ehsan |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
kulfi
Starting Member
33 Posts |
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-12 : 00:43:57
|
quote: Originally posted by kulfi HI, WHEN I SELECT SQL SERVER CONFIGURATION MANAGER AND SELECT SQL SERVER SERVICES IN THE LEFT PORTION AND IN THE RIGHT PORTION ARESQL SERVER INTEGRATION SERVICES 10.0 " IT IS running"SQL SERVER (sqlexpress) "it is stopped"sql full-text filter daemon luncher (mssqlserver)"It is running"sql server (mssqlserver) "it is stopped"sql server Analysis services (mssqlserver)"it is running"sql server reporting services (mssqlserver)"it is running"sql server agent (sqlexpress)"it is stopped"sql server browser"It is running"sql server agent (mssqlserver) "it is stopped"these are the parameters i can see in my manager please can u tell me what is wrong.thanksquote: Originally posted by tkizer You haven't provided the error, so how could I tell you why?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Ehsan
Well Ehsan i think what we are trying to ask you is about the EXACT problem you are facing .. OK You provided the details of SQL Configuration Manager stating about the services which are running and the services that are not running(Stopped). Most of the time you are not Required to run all services at a time .. However it the SQL Server Engine specific service MUST be running if you want to access a database. In this whole discussion you didn't specify what is the problem you are facing and which service you want to start Let us know about this? also it seems that two SQL Server instances are installed on your machine? Once of them is SQL Server Express Edition is it so? Guessing this from the highlighted section of your response. |
 |
|
|
|
|
|
|