Can't start engine

SQL Server 2000 cluster
While trying to move the master, model, etc db's I put trace flags into the
startup according to the instruction in:
http://support.microsoft.com/kb/224071
When that didn't work, I tried splitting the 3 args into 3 seperate options.
Now, I can't get in to change it back, the engine refuses to let me in:
Error:
A connection could not be established to _SERVER_
Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
in single user mode. Only one administrator can connect at a time.
I did get into the configuration settings once, though I'm not sure how, and
I thought I removed the options.How about removing "-m" from the startup parameters of your SQL Server
service?
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
"Jay" <nospan@.nospam.org> wrote in message
news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> SQL Server 2000 cluster
> While trying to move the master, model, etc db's I put trace flags into
> the startup according to the instruction in:
> http://support.microsoft.com/kb/224071
> When that didn't work, I tried splitting the 3 args into 3 seperate
> options. Now, I can't get in to change it back, the engine refuses to let
> me in:
> Error:
> A connection could not be established to _SERVER_
> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
> in single user mode. Only one administrator can connect at a time.
>
> I did get into the configuration settings once, though I'm not sure how,
> and I thought I removed the options.
>|||I can't get in!
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:FEC71DAB-8E4D-49B8-97B8-386038797D8A@.microsoft.com...
> How about removing "-m" from the startup parameters of your SQL Server
> service?
> --
> Ekrem Önsoy
> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
> MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to let
>> me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how,
>> and I thought I removed the options.
>|||I think I found the startup parameters in the registry (both nodes of the
cluster) in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\parameters
But I know better than to do more than look in regedit.
"Jay" <nospan@.nospam.org> wrote in message
news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> SQL Server 2000 cluster
> While trying to move the master, model, etc db's I put trace flags into
> the startup according to the instruction in:
> http://support.microsoft.com/kb/224071
> When that didn't work, I tried splitting the 3 args into 3 seperate
> options. Now, I can't get in to change it back, the engine refuses to let
> me in:
> Error:
> A connection could not be established to _SERVER_
> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
> in single user mode. Only one administrator can connect at a time.
>
> I did get into the configuration settings once, though I'm not sure how,
> and I thought I removed the options.
>|||With the Windows admin, I tried to remove the -c -m -T3608 from the
registry. The primary node in the cluster refused to let me remove the
parameter and the secondary allowed the delete. When we restarted the
server, it was still in single user and a refresh in regedit on the
secondary showed the deleted options were back.
"Jay" <nospan@.nospam.org> wrote in message
news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> SQL Server 2000 cluster
> While trying to move the master, model, etc db's I put trace flags into
> the startup according to the instruction in:
> http://support.microsoft.com/kb/224071
> When that didn't work, I tried splitting the 3 args into 3 seperate
> options. Now, I can't get in to change it back, the engine refuses to let
> me in:
> Error:
> A connection could not be established to _SERVER_
> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
> in single user mode. Only one administrator can connect at a time.
>
> I did get into the configuration settings once, though I'm not sure how,
> and I thought I removed the options.
>|||Stop other services which connect to SQL Server. SQL Server Agent for
example...
Then you'd be the one who connects to SQL Server and then you'd be able to
change the setting?
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
"Jay" <nospan@.nospam.org> wrote in message
news:OowRKaaHIHA.4808@.TK2MSFTNGP05.phx.gbl...
>I can't get in!
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:FEC71DAB-8E4D-49B8-97B8-386038797D8A@.microsoft.com...
>> How about removing "-m" from the startup parameters of your SQL Server
>> service?
>> --
>> Ekrem Önsoy
>> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
>> MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
>>
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how,
>> and I thought I removed the options.
>>
>|||I did stop everything else. listed in the SQL Server Service Manager: SQL
agent, DTC, Full Text search and sonething else I don't recall right now.
Unless it's got something to do with the Cluster manager? I know that
sub-system has some control over SQL Server, but I'm really unfamilar with
it, the Windows admin set it up.
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:E4CA655D-3777-4AAA-BB8F-F305A064816B@.microsoft.com...
> Stop other services which connect to SQL Server. SQL Server Agent for
> example...
> Then you'd be the one who connects to SQL Server and then you'd be able to
> change the setting?
> --
> Ekrem Önsoy
> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
> MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:OowRKaaHIHA.4808@.TK2MSFTNGP05.phx.gbl...
>>I can't get in!
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:FEC71DAB-8E4D-49B8-97B8-386038797D8A@.microsoft.com...
>> How about removing "-m" from the startup parameters of your SQL Server
>> service?
>> --
>> Ekrem Önsoy
>> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
>> MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
>>
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure
>> how, and I thought I removed the options.
>>
>>
>|||Still in need of help.
"Jay" <nospan@.nospam.org> wrote in message
news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> SQL Server 2000 cluster
> While trying to move the master, model, etc db's I put trace flags into
> the startup according to the instruction in:
> http://support.microsoft.com/kb/224071
> When that didn't work, I tried splitting the 3 args into 3 seperate
> options. Now, I can't get in to change it back, the engine refuses to let
> me in:
> Error:
> A connection could not be established to _SERVER_
> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
> in single user mode. Only one administrator can connect at a time.
>
> I did get into the configuration settings once, though I'm not sure how,
> and I thought I removed the options.
>|||Single user mode is the -m startup switch. Perhaps you removed that option in the registry from one
of the nodes but no the other. I would connect using regedit and verify the setting for all nodes...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospan@.nospam.org> wrote in message news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
> Still in need of help.
> "Jay" <nospan@.nospam.org> wrote in message news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into the startup according to
>> the instruction in: http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate options. Now, I can't get in
>> to change it back, the engine refuses to let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how, and I thought I removed
>> the options.
>|||If regedit allows me to change it, am I changing the registry in the correct
localtion? Sounds like it.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
> Single user mode is the -m startup switch. Perhaps you removed that option
> in the registry from one of the nodes but no the other. I would connect
> using regedit and verify the setting for all nodes...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how,
>> and I thought I removed the options.
>>
>|||I'm not sure you want to *change* it using regedit. My gut feeling was to check using regedit to
verify if this was the issue. I would assume that Enterprise Manager would change it for you on all
nodes. Or possibly the cluster support in Windows will take care of that for you (regardless of what
tool you use to make that change). I'd try EM first, and if that doesn't help, use regedit, and
verify all nodes...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospan@.nospam.org> wrote in message news:OqUUt58HIHA.4712@.TK2MSFTNGP04.phx.gbl...
> If regedit allows me to change it, am I changing the registry in the correct localtion? Sounds
> like it.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
>> Single user mode is the -m startup switch. Perhaps you removed that option in the registry from
>> one of the nodes but no the other. I would connect using regedit and verify the setting for all
>> nodes...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Jay" <nospan@.nospam.org> wrote in message news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into the startup according
>> to the instruction in: http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate options. Now, I can't get
>> in to change it back, the engine refuses to let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how, and I thought I
>> removed the options.
>>
>>
>|||OK Tibor, regedit did allow me to remove just the -m flag. I was then able
to get into properties and remove the other two. The genesis of my issue was
that I could not get into the properties in the first place. I would guess
that this is VERY unusual as both you and Ekrem continue to suggest I change
the options via properties\startup options, despite my continuing to repeat
that I couldn't get in.
I'm OK now, thanks Tibor and Ekrem. I suppose I can be a bit of a pill when
stressed.
The part that is very disturbing is that upon researching the command line
options provided and the experience applying them, there are three mistakes
in the Microsoft kb article.
1) The arguments are presented as if you put them all in, one entry when you
need to do each one separately.
2) -T3608 should be /T3608
3) -m is not necessary in SQL Server 2000 (and is what caused so much of the
problem)
The other two Admins (and our manager, who used to be an Admin) got a good
laugh at me for the faith I had in the Microsoft kb article. It seems that
they have gotten bad instructions many times before.
Last, kicking and screaming, I've now learned a little about the Windows
registry.
Thanks,
Jay
PS. I have now moved the model database and will do the others shortly.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
> Single user mode is the -m startup switch. Perhaps you removed that option
> in the registry from one of the nodes but no the other. I would connect
> using regedit and verify the setting for all nodes...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how,
>> and I thought I removed the options.
>>
>|||> I would guess that this is VERY unusual as both you and Ekrem continue to suggest I change the
> options via properties\startup options, despite my continuing to repeat that I couldn't get in.
Sorry, I missed that part...
> The part that is very disturbing is that upon researching the command line options provided and
> the experience applying them, there are three mistakes in the Microsoft kb article.
Was it KB 224071?
> 1) The arguments are presented as if you put them all in, one entry when you need to do each one
> separately.
Perhaps the article assumes that you use EM and EM represents the arguments as one on each line,
while you modified the registry directly which represents the information differently? I guess the
KB could have a few words about the difference between EM's representation and how it looks like in
regedit...
> 2) -T3608 should be /T3608
My experience is that dash or slash makes no difference for the various SQL Server exe files that
reads command line options...
A tip: Make sure that you managed to get the proper dbid for model (check sysdatabases). I believe
it need to be 3. As I remember, SQL Server uses the dbid for the model database, not the name of the
database. Which means that you will get whacky behavior when you create new databases if model isn't
3...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospan@.nospam.org> wrote in message news:eulAKH9HIHA.4296@.TK2MSFTNGP04.phx.gbl...
> OK Tibor, regedit did allow me to remove just the -m flag. I was then able to get into properties
> and remove the other two. The genesis of my issue was that I could not get into the properties in
> the first place. I would guess that this is VERY unusual as both you and Ekrem continue to suggest
> I change the options via properties\startup options, despite my continuing to repeat that I
> couldn't get in.
> I'm OK now, thanks Tibor and Ekrem. I suppose I can be a bit of a pill when stressed.
> The part that is very disturbing is that upon researching the command line options provided and
> the experience applying them, there are three mistakes in the Microsoft kb article.
> 1) The arguments are presented as if you put them all in, one entry when you need to do each one
> separately.
> 2) -T3608 should be /T3608
> 3) -m is not necessary in SQL Server 2000 (and is what caused so much of the problem)
> The other two Admins (and our manager, who used to be an Admin) got a good laugh at me for the
> faith I had in the Microsoft kb article. It seems that they have gotten bad instructions many
> times before.
> Last, kicking and screaming, I've now learned a little about the Windows registry.
> Thanks,
> Jay
> PS. I have now moved the model database and will do the others shortly.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
>> Single user mode is the -m startup switch. Perhaps you removed that option in the registry from
>> one of the nodes but no the other. I would connect using regedit and verify the setting for all
>> nodes...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Jay" <nospan@.nospam.org> wrote in message news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into the startup according
>> to the instruction in: http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate options. Now, I can't get
>> in to change it back, the engine refuses to let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how, and I thought I
>> removed the options.
>>
>>
>|||> Was it KB 224071?
yes.
...
> A tip: Make sure that you managed to get the proper dbid for model (check
> sysdatabases). I believe it need to be 3. As I remember, SQL Server uses
> the dbid for the model database, not the name of the database. Which means
> that you will get whacky behavior when you create new databases if model
> isn't 3...
Yes, model is dbid 3.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:eulAKH9HIHA.4296@.TK2MSFTNGP04.phx.gbl...
>> OK Tibor, regedit did allow me to remove just the -m flag. I was then
>> able to get into properties and remove the other two. The genesis of my
>> issue was that I could not get into the properties in the first place. I
>> would guess that this is VERY unusual as both you and Ekrem continue to
>> suggest I change the options via properties\startup options, despite my
>> continuing to repeat that I couldn't get in.
>> I'm OK now, thanks Tibor and Ekrem. I suppose I can be a bit of a pill
>> when stressed.
>> The part that is very disturbing is that upon researching the command
>> line options provided and the experience applying them, there are three
>> mistakes in the Microsoft kb article.
>> 1) The arguments are presented as if you put them all in, one entry when
>> you need to do each one separately.
>> 2) -T3608 should be /T3608
>> 3) -m is not necessary in SQL Server 2000 (and is what caused so much of
>> the problem)
>> The other two Admins (and our manager, who used to be an Admin) got a
>> good laugh at me for the faith I had in the Microsoft kb article. It
>> seems that they have gotten bad instructions many times before.
>> Last, kicking and screaming, I've now learned a little about the Windows
>> registry.
>> Thanks,
>> Jay
>> PS. I have now moved the model database and will do the others shortly.
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
>> Single user mode is the -m startup switch. Perhaps you removed that
>> option in the registry from one of the nodes but no the other. I would
>> connect using regedit and verify the setting for all nodes...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags
>> into the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure
>> how, and I thought I removed the options.
>>
>>
>>
>|||Just wanted to say thanks to all who contributed to this thread. I ran into
this exact same issue today and was able to fix it the same way Jay
ultimately did. You've saved me potentially countless hours of trial and
error. Many thanks!
"Jay" wrote:
> > Was it KB 224071?
> yes.
> ...
> >
> > A tip: Make sure that you managed to get the proper dbid for model (check
> > sysdatabases). I believe it need to be 3. As I remember, SQL Server uses
> > the dbid for the model database, not the name of the database. Which means
> > that you will get whacky behavior when you create new databases if model
> > isn't 3...
> Yes, model is dbid 3.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://sqlblog.com/blogs/tibor_karaszi
> >
> >
> > "Jay" <nospan@.nospam.org> wrote in message
> > news:eulAKH9HIHA.4296@.TK2MSFTNGP04.phx.gbl...
> >> OK Tibor, regedit did allow me to remove just the -m flag. I was then
> >> able to get into properties and remove the other two. The genesis of my
> >> issue was that I could not get into the properties in the first place. I
> >> would guess that this is VERY unusual as both you and Ekrem continue to
> >> suggest I change the options via properties\startup options, despite my
> >> continuing to repeat that I couldn't get in.
> >>
> >> I'm OK now, thanks Tibor and Ekrem. I suppose I can be a bit of a pill
> >> when stressed.
> >>
> >> The part that is very disturbing is that upon researching the command
> >> line options provided and the experience applying them, there are three
> >> mistakes in the Microsoft kb article.
> >>
> >> 1) The arguments are presented as if you put them all in, one entry when
> >> you need to do each one separately.
> >> 2) -T3608 should be /T3608
> >> 3) -m is not necessary in SQL Server 2000 (and is what caused so much of
> >> the problem)
> >>
> >> The other two Admins (and our manager, who used to be an Admin) got a
> >> good laugh at me for the faith I had in the Microsoft kb article. It
> >> seems that they have gotten bad instructions many times before.
> >>
> >> Last, kicking and screaming, I've now learned a little about the Windows
> >> registry.
> >>
> >> Thanks,
> >> Jay
> >>
> >> PS. I have now moved the model database and will do the others shortly.
> >>
> >> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> >> in message news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
> >> Single user mode is the -m startup switch. Perhaps you removed that
> >> option in the registry from one of the nodes but no the other. I would
> >> connect using regedit and verify the setting for all nodes...
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "Jay" <nospan@.nospam.org> wrote in message
> >> news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
> >> Still in need of help.
> >>
> >> "Jay" <nospan@.nospam.org> wrote in message
> >> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> >> SQL Server 2000 cluster
> >>
> >> While trying to move the master, model, etc db's I put trace flags
> >> into the startup according to the instruction in:
> >> http://support.microsoft.com/kb/224071
> >>
> >> When that didn't work, I tried splitting the 3 args into 3 seperate
> >> options. Now, I can't get in to change it back, the engine refuses to
> >> let me in:
> >>
> >> Error:
> >>
> >> A connection could not be established to _SERVER_
> >> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
> >> is
> >> in single user mode. Only one administrator can connect at a time.
> >>
> >>
> >> I did get into the configuration settings once, though I'm not sure
> >> how, and I thought I removed the options.
> >>
> >>
> >>
> >>
> >>
> >>
> >
>
>