Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ned
Starting Member
16 Posts |
 Posted - 2007-06-06 : 11:38:47
|
| Hi,I'm trying to move the master database via this article:http://msdn2.microsoft.com/en-us/library/ms345408.aspxOne of the steps is to start MSSQL is single user admin mode so that you can move the resource database (after moving master)NET START MSSQLSERVER /f /T3608This statement works, but I then need to execute a sql statement. When I try to connect to sql, (either sqlcmd or Management Studio), it fails since it states only one admin can be connected at a time. I had just stopped the service so I no one else is logged on. I don't know how to be "the one" admin user. I'm sure it is something obvious, but I just don't know.Once setting it in single user mode, how do you actuall access the server? (to be the one single user).Thanks,Ned |
|
|
Ned
Starting Member
16 Posts |
Posted - 2007-06-06 : 17:57:50
|
| Well in case anyone cares, I figured out the issue. Obviously something was taking control of the "single" admin account before I could connect. Well, that server is running Team Foundation Server (TFS). So I disabled the following services:TFSServerSchedulerSharePoint Timer ServiceSQLServer Reporting serviceThen when I started sql in the single user mode, I was able to connect and run the necessary scripts.Thanks,Ned |
 |
|
|
|
|
|
single user admin mode