Issue while connecting to SQLServer
Found the error below
And I have a look on this C:\Program Files\Microsoft SQL Server\MSSQL10_50.EUEPRD\MSSQL\Log
Error I got 
2013-06-20 18:54:27.70 Logon       Error: 18401, Severity: 14, State: 1.
2013-06-20
 18:54:27.70 Logon       Login failed for user 'sa'. Reason: Server is 
in script upgrade mode. Only administrator can connect at this time. 
[CLIENT: <local machine>]
2013-06-20 18:54:28.43 spid7s      Signing sps ...
2013-06-20 18:54:28.43 spid7s      Dropping existing Agent certificate ...
2013-06-20
 18:54:28.44 spid7s      DBCC TRACEON 4606, server process ID (SPID) 7. 
This is an informational message only; no user action is required.
2013-06-20 18:54:28.44 spid7s      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
2013-06-20
 18:54:28.92 spid7s      DBCC TRACEOFF 4606, server process ID (SPID) 7.
 This is an informational message only; no user action is required.
2013-06-20 18:54:28.92 spid7s      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
2013-06-20 18:54:29.09 spid7s      Error: 5123, Severity: 16, State: 1.
2013-06-20
 18:54:29.09 spid7s      CREATE FILE encountered operating system error 
3(The system cannot find the path specified.) while attempting to open 
or create the physical file 
'C;\data\temp_MS_AgentSigningCertificate_database_log.LDF'.
2013-06-20 18:54:29.09 spid7s      Error: 5123, Severity: 16, State: 1.
2013-06-20
 18:54:29.09 spid7s      CREATE FILE encountered operating system error 
3(The system cannot find the path specified.) while attempting to open 
or create the physical file 
'C;\data\temp_MS_AgentSigningCertificate_database_log.LDF'.
2013-06-20 18:54:29.10 spid7s      Error: 1802, Severity: 16, State: 4.
2013-06-20 18:54:29.10 spid7s      CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
2013-06-20 18:54:29.10 spid7s      Error: 912, Severity: 21, State: 2.
2013-06-20 18:54:29.10 spid7s
      Script level upgrade for database 'master' failed because upgrade 
step 'sqlagent100_msdb_upgrade.sql' encountered error 598, state 1, 
severity 25. This is a serious error condition which might interfere 
with regular operation and the database will be taken offline. If
 the error happened during upgrade of the 'master' database, it will 
prevent the entire SQL Server instance from starting. Examine the 
previous errorlog entries for errors, take the appropriate corrective 
actions and re-start the database so that the script upgrade steps run 
to completion.
2013-06-20 18:54:29.11 spid7s      Error: 3417, Severity: 21, State: 3.
2013-06-20
 18:54:29.11 spid7s      Cannot recover the master database. SQL Server 
is unable to run. Restore master from a full backup, repair it, or 
rebuild it. For more information about how to rebuild the master 
database, see SQL Server Books Online.
2013-06-20
 18:54:29.60 spid7s      SQL Trace was stopped due to server shutdown. 
Trace ID = '1'. This is an informational message only; no user action is
 required.
And tried C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\Binn>sqlservr.exe
But no luck
Again try one more Option:-
If your Database is still in the upgrade script mode as soon as it starts up . Do the following.
- Enable trace flag 902 on the instance of SQL Server 2008 . To do this, follow these steps:
 a. Open SQL Server Configuration Manager.
 b. In SQL Server Configuration Manager, click SQL Server Services.
 c. Double-click the SQL Serverservice.
 d. In the SQL Server Properties dialog box, click the Advanced tab.
 e. On click the Advanced tab, locate the Startup Parameters item.
f. Add –T902 to the end of the existing string value, and then click OK.
g. Right-click the SQL Serverservice, and then click Start.
- Open SQL Server Management Studio, and then connect to the instance of SQL Server 2008.
- Run the following statements:
EXEC sp_configure 'affinity mask',0
RECONFIGURE;
GO
RECONFIGURE;
GO
- In SQL Server Configuration Manager, right-click the SQL Serverservice, and then click Stop.
- Remove trace flag 902 on the instance of SQL Server 2008. To do this, delete –T902 from the string value that you updated in step 1f.
- Right-click the SQL Serverservice, and then click Start.
Note:-
Suppose this is also not working you needs to restore the master database from backup.
 
 
No comments:
Post a Comment