• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Starting sql server 2005 in single user mode

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
tbailey2011
Asked:
tbailey2011
1 Solution
 
khairilCommented:
Hi,

Try add -m option to the command line.
0
 
TempDBACommented:
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
 
tbailey2011Author Commented:
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
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
khairilCommented:
why not just disabled/pull off the network cable if you do troubleshooting on the server.
0
 
tbailey2011Author Commented:
Its at a remote location and I don't have physical access to it.
0
 
VENKAT KOKULLASQL Server DBACommented:
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
 
tbailey2011Author Commented:
good
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now