Solved

Starting sql server 2005 in single user mode

Posted on 2011-09-12
7
324 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

623 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