Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Starting up in Single user mode Expand / Collapse
Author
Message
Posted Tuesday, January 19, 2010 9:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 27, 2013 2:21 PM
Points: 50, Visits: 137
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
Posted Tuesday, January 19, 2010 10:05 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 11:58 AM
Points: 794, Visits: 2,085
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
PS C:\>(Find-Me).TwitterUri
@wshawnmelton
PS C:\>(Find-Me).BlogUri
meltondba.wordpress.com
Post #849898
Posted Wednesday, January 20, 2010 12:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 20, 2014 11:33 AM
Points: 237, Visits: 880
Hi;

Please pass required parameters

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


Ram
MSSQL DBA
Post #850259
Posted Wednesday, January 20, 2010 6:43 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 27, 2013 2:21 PM
Points: 50, Visits: 137
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
Posted Wednesday, January 20, 2010 9:27 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 11:58 AM
Points: 794, Visits: 2,085
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
PS C:\>(Find-Me).TwitterUri
@wshawnmelton
PS C:\>(Find-Me).BlogUri
meltondba.wordpress.com
Post #850592
Posted Thursday, January 21, 2010 3:52 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:06 AM
Points: 498, Visits: 701
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
Posted Thursday, January 21, 2010 6:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 1,201, Visits: 2,661
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
Posted Thursday, January 21, 2010 6:24 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 27, 2013 2:21 PM
Points: 50, Visits: 137
Thanks that was the problem.
Post #851189
Posted Thursday, January 21, 2010 6:34 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:06 AM
Points: 498, Visits: 701
Markus,

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


Regards,
Saravanan
Post #851196
Posted Thursday, January 21, 2010 6:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 1,201, Visits: 2,661
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 »

Add to briefcase 12»»

Permissions Expand / Collapse