restoring master database - single user mode

I am trying to restore a backup of a master database from one server to a
new server.
I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a command
prompt to start it in single user mode. It finished with "SQL Global
counter collection task is created." It appears to stop at this point -
there is no prompt.
While in single-user mode, I open Query Analyzer and attempt to log in both
with Windows Authentication and with SQL Server authentication, using the sa
login.
In both cases, I get an error "Login failed for user '(login)'. Reason:
Server is in single user mode. Only one administrator can connect at this
time."
Thanks for any suggestions.
-Bill
There might be an EM connection that is already open.
"bill" <belgie@.datamti.com> wrote in message
news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> I am trying to restore a backup of a master database from one server to a
> new server.
> I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
command
> prompt to start it in single user mode. It finished with "SQL Global
> counter collection task is created." It appears to stop at this point -
> there is no prompt.
> While in single-user mode, I open Query Analyzer and attempt to log in
both
> with Windows Authentication and with SQL Server authentication, using the
sa
> login.
> In both cases, I get an error "Login failed for user '(login)'. Reason:
> Server is in single user mode. Only one administrator can connect at this
> time."
> Thanks for any suggestions.
> -Bill
>
|||Good thought, but that's not it.
Thanks!
"Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> There might be an EM connection that is already open.
> "bill" <belgie@.datamti.com> wrote in message
> news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
a[vbcol=seagreen]
> command
> both
the[vbcol=seagreen]
> sa
this
>
|||Agent? Other services or users? You need to find who is connected...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> Good thought, but that's not it.
> Thanks!
> "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> a
> the
> this
>
|||How can I do this? I can't connect to SQL Server to see the connections.
Thanks
Bill
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> Agent? Other services or users? You need to find who is connected...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "bill" <belgie@.datamti.com> wrote in message
news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
to[vbcol=seagreen]
Global[vbcol=seagreen]
point -[vbcol=seagreen]
in[vbcol=seagreen]
using[vbcol=seagreen]
Reason:
>
|||Start stopping SQL server Agent, and other possible services that might use SQL server. You might
need to get physical access to the machine, or terminal services, so you can work locally on the
machine stopping services and perhaps even disabling network access (which isn't doable over
terminal services, of course).
Another thing you can try is to login using OSQL.EXE instead of Query Analyzer. QA *might* try to
open a connection for Object Browser and that *might* get connected before your query window.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:emBg4NEuEHA.348@.tk2msftngp13.phx.gbl...
> How can I do this? I can't connect to SQL Server to see the connections.
> Thanks
> Bill
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> to
> Global
> point -
> in
> using
> Reason:
>