Solved

Starting sql server 2005 in single user mode

Posted on 2011-09-12
7
323 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

710 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