Dear All,
I am not able to start the sql server 2005 database engine services...
Sql server 2005 server is installed in one machine(SERVER) and we have 10 client machine connecting to the server
When i try to start the service from the Service.msc in the SERVER i am getting the following error
===================================
Cannot connect to KEYSKILL.
===================================
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
Error Number: 2
Severity: 20
State: 0
Program Location:
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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
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.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Could any one help me to resolve the error
Thanks in Advance
Lalitha
Look in the Windows event log, there might be a hardware failure which is described in the event log. If you are not sure what to do with the log, send them over for investigation.Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Could you post Errorlog & Event log information which will provide more info to sort out the problem.|||
HI Vidya,
This is the ERROR LOG information
2007-07-17 10:28:38.56 Server Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86)
Mar 3 2007 18:40:02
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-07-17 10:28:38.56 Server (c) 2005 Microsoft Corporation.
2007-07-17 10:28:38.56 Server All rights reserved.
2007-07-17 10:28:38.56 Server Server process ID is 3332.
2007-07-17 10:28:38.56 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-07-17 10:28:38.56 Server This instance of SQL Server last reported using a process ID of 6000 at 7/17/2007 10:28:33 AM (local) 7/17/2007 4:58:33 AM (UTC). This is an informational message only; no user action is required.
2007-07-17 10:28:38.56 Server Registry startup parameters:
2007-07-17 10:28:38.56 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-07-17 10:28:38.56 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-07-17 10:28:38.56 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-07-17 10:28:38.57 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-07-17 10:28:38.57 Server Detected 2 CPUs. This is an informational message; no user action is required.
2007-07-17 10:28:38.75 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-07-17 10:28:38.76 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-07-17 10:28:39.79 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-07-17 10:28:39.79 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-07-17 10:28:39.81 spid5s Starting up database 'master'.
2007-07-17 10:28:39.93 spid5s SQL Trace ID 1 was started by login "sa".
2007-07-17 10:28:39.95 spid5s Starting up database 'mssqlsystemresource'.
2007-07-17 10:28:39.98 spid5s Error: 17207, Severity: 16, State: 1.
2007-07-17 10:28:39.98 spid5s FCB:
pen: Operating system error 21(The device is not ready.) occurred while creating or opening file 'E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf'. Diagnose and correct the operating system error, and retry the operation.
2007-07-17 10:28:39.98 spid5s Error: 17204, Severity: 16, State: 1.
2007-07-17 10:28:39.98 spid5s FCB:pen failed: Could not open file E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf for file number 1. OS error: 21(The device is not ready.).
2007-07-17 10:28:39.98 spid5s Error: 5120, Severity: 16, State: 101.
2007-07-17 10:28:39.98 spid5s Unable to open the physical file "E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf". Operating system error 21: "21(The device is not ready.)".
2007-07-17 10:28:40.00 spid5s Error: 17207, Severity: 16, State: 1.
2007-07-17 10:28:40.00 spid5s FileMgr:
tartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf'. Diagnose and correct the operating system error, and retry the operation.
2007-07-17 10:28:40.00 spid5s File activation failure. The physical file name "E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf" may be incorrect.
2007-07-17 10:28:40.00 spid5s Error: 945, Severity: 14, State: 2.
2007-07-17 10:28:40.00 spid5s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
2007-07-17 10:28:40.00 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
and i didnt find the event log file....
could u please tell me the path...
Regards
Lalitha
|||Examine the location
E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.*"
Does the file exist ?
Does the service account have the appropiate permissions to access it ?
Does the directory exists ?
is the directory on a shared network drive ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment