Starting up in Single user mode

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Starting up in Single user mode

11 posts, Page 1 of 2

1 2 »»

Starting up in Single user mode

Rate Topic

Display Mode

Topic Options

Author

Message

tboggiano

Posted Tuesday, January 19, 2010 9:15 AM

Valued Member

Group: General Forum Members
Last Login: Monday, February 04, 2013 12:24 PM
Points: 50, Visits: 136

I am testing a disaster recovery process but am unable to restart any 2008 systems in single user mode so that I can restore the master db. The sql server instance is stopped when I issue the command. I have tried this on three systems so far with no luck please help.

D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn>sqlservr.ex
e -m
2010-01-19 11:09:35.82 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:35.82 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2010-01-19 11:09:36.12 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:36.12 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2010-01-19 11:09:36.42 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:36.42 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2010-01-19 11:09:36.72 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:36.72 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2010-01-19 11:09:37.03 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:37.03 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2010-01-19 11:09:37.33 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:37.33 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2010-01-19 11:09:37.63 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:37.63 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2010-01-19 11:09:37.93 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:37.93 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2010-01-19 11:09:38.24 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:38.24 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2010-01-19 11:09:38.54 Server Error: 17058, Severity: 16, State: 1.
2010-01-19 11:09:38.54 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).

Post #849836

Shawn Melton

Posted Tuesday, January 19, 2010 10:05 AM

Right there with Babe

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:56 PM
Points: 754, Visits: 1,891

I take it you restored to another server? Are the drive letters available the same on the restored server as what was on the original?

--------------------------------------------------------------
Shawn Melton
@wshawnmelton

Post #849898

Ramdas Baghel

Posted Wednesday, January 20, 2010 12:29 AM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:06 AM
Points: 224, Visits: 826

Hi;

Please pass required parameters

http://msdn.microsoft.com/en-us/library/ms190737.aspx

Ram
MSSQL DBA

Post #850259

tboggiano

Posted Wednesday, January 20, 2010 6:43 AM

Valued Member

Group: General Forum Members
Last Login: Monday, February 04, 2013 12:24 PM
Points: 50, Visits: 136

I copied the parameters from the SQL Configuration Manager and now I get so other weird messages.

D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn>sqlservr.exe -m -sMSSQLSERVER -d"D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf" -e"D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG" -l"D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf"

2010-01-20 08:22:00.45 Server Microsoft SQL Server 2008 (SP1) - 10.0.2746.0
(X64)
Nov 9 2009 16:37:47
Copyright (c) 1988-2008 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (VM)

2010-01-20 08:22:00.45 Server (c) 2005 Microsoft Corporation.
2010-01-20 08:22:00.45 Server All rights reserved.
2010-01-20 08:22:00.45 Server Server process ID is 3840.
2010-01-20 08:22:00.45 Server System Manufacturer: 'Microsoft Corporation', System Model: 'Virtual Machine'.
2010-01-20 08:22:00.45 Server Authentication mode is MIXED.
2010-01-20 08:22:00.45 Server Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2010-01-20 08:22:00.45 Server This instance of SQL Server last reported using a process ID of 2004 at 1/20/2010 8:21:49 AM (local) 1/20/2010 1:21:49 PM UTC). This is an informational message only; no user action is required.
2010-01-20 08:22:00.45 Server Error: 17053, Severity: 16, State: 1.
2010-01-20 08:22:00.45 Server UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
2010-01-20 08:22:00.45 Server Command Line Startup Parameters:
-m
-s MSSQLSERVER
-d D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
-e D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2010-01-20 08:22:00.47 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-01-20 08:22:00.47 Server Detected 1 CPUs. This is an informational message; no user action is required.
2010-01-20 08:22:00.50 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2010-01-20 08:22:00.50 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.
2010-01-20 08:22:00.52 Server Node configuration: node 0: CPU mask: 0x0000000000000001 Active CPU mask: 0x0000000000000001. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2010-01-20 08:22:00.54 Server Database Mirroring Transport is disabled in the endpoint configuration.
2010-01-20 08:22:00.54 spid7s Warning ******************
2010-01-20 08:22:00.54 spid7s SQL Server started in single-user mode. This an informational message only. No user action is required.
2010-01-20 08:22:00.55 spid7s Starting up database 'master'.
2010-01-20 08:22:00.61 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

2010-01-20 08:22:00.71 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2010-01-20 08:22:00.77 spid7s SQL Trace ID 1 was started by login "sa".
2010-01-20 08:22:00.88 spid7s Starting up database 'mssqlsystemresource'.
2010-01-20 08:22:00.89 spid7s The resource database build version is 10.00.2746. This is an informational message only. No user action is required.
2010-01-20 08:22:01.40 spid7s Error: 15466, Severity: 16, State: 1.
2010-01-20 08:22:01.40 spid7s An error occurred during decryption. RegOpenKeyEx of "Software\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSS
QLServer" failed.
2010-01-20 08:22:01.43 spid7s Failed to check for new installation or a renamed server at startup. The logic for this check has failed unexpectedly. Run setup again, or fix the problematic registry key.
2010-01-20 08:22:01.43 Server Error: 17182, Severity: 16, State: 1.
2010-01-20 08:22:01.43 Server TDSSNIClient initialization failed with error 0x5, status code 0x51. Reason: Unable to configure MDAC-compatibility Named Pipes protocol pipe name in registry. Access is denied.

2010-01-20 08:22:01.43 spid9s Starting up database 'model'.
2010-01-20 08:22:01.43 Server Error: 17182, Severity: 16, State: 1.
2010-01-20 08:22:01.43 Server TDSSNIClient initialization failed with error 0x5, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Access is denied.

2010-01-20 08:22:01.43 Server Error: 17826, Severity: 18, State: 3.
2010-01-20 08:22:01.43 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2010-01-20 08:22:01.44 Server Error: 17120, Severity: 16, State: 1.
2010-01-20 08:22:01.44 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Post #850437

Shawn Melton

Posted Wednesday, January 20, 2010 9:27 AM

Right there with Babe

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:56 PM
Points: 754, Visits: 1,891

2010-01-20 08:22:00.45 Server UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.

2010-01-20 08:22:01.43 spid7s Failed to check for new installation or a renamed server at startup. The logic for this check has failed unexpectedly. Run setup again, or fix the problematic registry key.
2010-01-20 08:22:01.43 Server Error: 17182, Severity: 16, State: 1.
2010-01-20 08:22:01.43 Server TDSSNIClient initialization failed with error 0x5, status code 0x51. Reason: Unable to configure MDAC-compatibility Named Pipes protocol pipe name in registry. Access is denied.

This tells me the account being used for the service does not have write/modify permissions to the registry in some way. It wants to update the UpdateUptimeRegKey.

--------------------------------------------------------------
Shawn Melton
@wshawnmelton

Post #850592

Saravanan T

Posted Thursday, January 21, 2010 3:52 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:54 AM
Points: 493, Visits: 653

Hi ,

Stop all the services related to SQL. Eg: SQL server,Agent,Analysis,Integration etc.

Got to Command promt.
Type as :

Step 1 : net stop mssqlserver
Step 2 : net start mssqlserver /f /T3608

Mssqlserver is your Instancename.

Once the Services started , type SQLCMD to check the connectivity as a single user mode.

Hope it will help you.

Regards,
Saravanan

Post #851122

Markus

Posted Thursday, January 21, 2010 6:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 12:10 PM
Points: 1,046, Visits: 2,211

I faced this EXACT issue two weeks ago. The resolution I found myself was that when you goto CMD prompt do not just open it, right click and say RUN AS ADMINISTRATOR. Then start SQL Server as you state. It will work that way. Security on WIn2008 is tighter and you have to do the RUN AS ADMIN for it to work correctly.

Post #851183

tboggiano

Posted Thursday, January 21, 2010 6:24 AM

Valued Member

Group: General Forum Members
Last Login: Monday, February 04, 2013 12:24 PM
Points: 50, Visits: 136

Thanks that was the problem.

Post #851189

Saravanan T

Posted Thursday, January 21, 2010 6:34 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:54 AM
Points: 493, Visits: 653

Markus,

We do all activities in administrator login. So i dint get this issue. Any way thks.

Regards,
Saravanan

Post #851196

Markus

Posted Thursday, January 21, 2010 6:57 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 12:10 PM
Points: 1,046, Visits: 2,211

I know. The ID I was using is a full admin to the server too so I did not understand. However, when you open it up as RUN AS Admin it works.

Post #851219

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions