Solved

Starting sql server 2005 in single user mode

Posted on 2011-09-12
7
317 Views
Last Modified: 2012-05-12
We have a sql server 2005 cluster on a Windows 2003 server.  I need to move the master and resource
databases to a new drive.  I was able to move the master fine...but when I tried to start sql server
in single user mode using the following command:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlservr.exe -f -c -T3608 -sMSSQLSERVER
It runs thru a bunch of different users not allowing me to connect.  See the screen shot below.  
Any idea on how I can start the server in single user mode or just move the resource database?
singlemode.bmp
0
Comment
Question by:tbailey2011
7 Comments
 
LVL 13

Expert Comment

by:khairil
ID: 36524588
Hi,

Try add -m option to the command line.
0
 
LVL 25

Expert Comment

by:TempDBA
ID: 36524672
From the message it is clear that the service is already started using other account and so you can't login as the database is running in single user mode. Can you check how the service is started?
0
 

Author Comment

by:tbailey2011
ID: 36524695
Thats an issue..because I'm not sure what service is connecting.  I even changed the port number so apps couldn't connect.  Would that be a good way of locking out all the users..changing the port number?
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 13

Expert Comment

by:khairil
ID: 36524722
why not just disabled/pull off the network cable if you do troubleshooting on the server.
0
 

Author Comment

by:tbailey2011
ID: 36524731
Its at a remote location and I don't have physical access to it.
0
 
LVL 5

Accepted Solution

by:
VENKAT KOKULLA earned 500 total points
ID: 36527621
it seems that when you login to SQL Management Studio, the Summary tab takes up the initial connection, hence, your query window is a second connection.  Just disconnect and click 'New Query' which will open your only connection.

Management Studio takes more than one connection if you have additional windows opened than the query window. Object Explorer is another window that will take its own connection.

Please go through the below article:
http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/
0
 

Author Closing Comment

by:tbailey2011
ID: 37030653
good
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question