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.
-BillThere 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...
> 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
> >
> >
>|||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...
> > 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
> > >
> > >
> >
> >
>|||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...
> > Good thought, but that's not it.
> >
> > Thanks!
> >
> > "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> > news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> > > 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
> > > >
> > > >
> > >
> > >
> >
> >
>|||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...
>> 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...
>> > > 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
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>