sql report manager: trace

Showing posts with label trace. Show all posts

Thursday, March 29, 2012

cant start Trace

I just created a server side Trace with no filters for testing but Im not
able to start it. I call sp_trace_setstatus 1,1 and it says completed
successfully. It then creates the file it writes too but never writes to it
when I generate activity. Any ideas why?
TIA, ChrisR
sql2k sp3aHi Chris
With server side traces, SQL Server writes to the file in 128K chunks, so
you won't see anything written until you have 128K worth of activity.
Look at fn_trace_getinfo( ) to check that your trace really is running.
Then try stopping and closing the trace:
sp_trace_setstatus 1, 0 -- stop the trace
sp_trace_setstatus 1, 2 -- close the trace
You must stop before closing or the close won't do anything. Only after
closing SQL Server write to the file.
Or, you can stop the SQL Server services, and that will also flush the
collected trace events to the file.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ChrisR" <noemail@.bla.com> wrote in message
news:u0nrZLfOFHA.904@.tk2msftngp13.phx.gbl...
>I just created a server side Trace with no filters for testing but Im not
>able to start it. I call sp_trace_setstatus 1,1 and it says completed
>successfully. It then creates the file it writes too but never writes to it
>when I generate activity. Any ideas why?
> TIA, ChrisR
> sql2k sp3a
>|||Kalen I know this will sound odd, but it almost seems as though nothing gets
written ubtil the box is rebooted. It stays at 0kb until I reboot, at which
time there is a larger size.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:OUzjYPfOFHA.2728@.TK2MSFTNGP15.phx.gbl...
> Hi Chris
> With server side traces, SQL Server writes to the file in 128K chunks, so
> you won't see anything written until you have 128K worth of activity.
> Look at fn_trace_getinfo( ) to check that your trace really is running.
> Then try stopping and closing the trace:
> sp_trace_setstatus 1, 0 -- stop the trace
> sp_trace_setstatus 1, 2 -- close the trace
> You must stop before closing or the close won't do anything. Only after
> closing SQL Server write to the file.
> Or, you can stop the SQL Server services, and that will also flush the
> collected trace events to the file.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:u0nrZLfOFHA.904@.tk2msftngp13.phx.gbl...
>>I just created a server side Trace with no filters for testing but Im not
>>able to start it. I call sp_trace_setstatus 1,1 and it says completed
>>successfully. It then creates the file it writes too but never writes to
>>it when I generate activity. Any ideas why?
>> TIA, ChrisR
>> sql2k sp3a
>|||Are you saying you have stopped and closed the trace, and still nothing gets
written?
If so, can you show the output of fn_trace_getinfo and then exact commands
you are running to stop and close the trace?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ChrisR" <noemail@.bla.com> wrote in message
news:uOTRg8iOFHA.2568@.TK2MSFTNGP14.phx.gbl...
> Kalen I know this will sound odd, but it almost seems as though nothing
> gets written ubtil the box is rebooted. It stays at 0kb until I reboot, at
> which time there is a larger size.
>
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:OUzjYPfOFHA.2728@.TK2MSFTNGP15.phx.gbl...
>> Hi Chris
>> With server side traces, SQL Server writes to the file in 128K chunks, so
>> you won't see anything written until you have 128K worth of activity.
>> Look at fn_trace_getinfo( ) to check that your trace really is running.
>> Then try stopping and closing the trace:
>> sp_trace_setstatus 1, 0 -- stop the trace
>> sp_trace_setstatus 1, 2 -- close the trace
>> You must stop before closing or the close won't do anything. Only after
>> closing SQL Server write to the file.
>> Or, you can stop the SQL Server services, and that will also flush the
>> collected trace events to the file.
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:u0nrZLfOFHA.904@.tk2msftngp13.phx.gbl...
>>I just created a server side Trace with no filters for testing but Im not
>>able to start it. I call sp_trace_setstatus 1,1 and it says completed
>>successfully. It then creates the file it writes too but never writes to
>>it when I generate activity. Any ideas why?
>> TIA, ChrisR
>> sql2k sp3a
>>
>|||--Status before stopping
traceid property value
-- -- -----------
1 1 0
1 2 c:\JobTrace
1 3 5
1 4 NULL
1 5 1
--stopping trace
sp_trace_setstatus 1,0
--status after stopping
traceid property value
-- -- -----------
1 1 0
1 2 c:\JobTrace
1 3 5
1 4 NULL
1 5 0
I dont see a command to close the Trace, Im just closing Query Anyalyzer.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eatZvLjOFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Are you saying you have stopped and closed the trace, and still nothing
> gets written?
> If so, can you show the output of fn_trace_getinfo and then exact
> commands you are running to stop and close the trace?
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:uOTRg8iOFHA.2568@.TK2MSFTNGP14.phx.gbl...
>> Kalen I know this will sound odd, but it almost seems as though nothing
>> gets written ubtil the box is rebooted. It stays at 0kb until I reboot,
>> at which time there is a larger size.
>>
>> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
>> news:OUzjYPfOFHA.2728@.TK2MSFTNGP15.phx.gbl...
>> Hi Chris
>> With server side traces, SQL Server writes to the file in 128K chunks,
>> so you won't see anything written until you have 128K worth of activity.
>> Look at fn_trace_getinfo( ) to check that your trace really is running.
>> Then try stopping and closing the trace:
>> sp_trace_setstatus 1, 0 -- stop the trace
>> sp_trace_setstatus 1, 2 -- close the trace
>> You must stop before closing or the close won't do anything. Only after
>> closing SQL Server write to the file.
>> Or, you can stop the SQL Server services, and that will also flush the
>> collected trace events to the file.
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:u0nrZLfOFHA.904@.tk2msftngp13.phx.gbl...
>>I just created a server side Trace with no filters for testing but Im
>>not able to start it. I call sp_trace_setstatus 1,1 and it says
>>completed successfully. It then creates the file it writes too but never
>>writes to it when I generate activity. Any ideas why?
>> TIA, ChrisR
>> sql2k sp3a
>>
>>
>|||Closing Qa will not stop or close the trace and the file size may not update
that often while it is running. If you look at sp_trace_setstatus in BOL
you will see hope to stop and close the trace.
--
Andrew J. Kelly SQL MVP
"ChrisR" <noemail@.bla.com> wrote in message
news:u$QxpVjOFHA.1396@.TK2MSFTNGP10.phx.gbl...
> --Status before stopping
> traceid property value
> -- -- -----------
> 1 1 0
> 1 2 c:\JobTrace
> 1 3 5
> 1 4 NULL
> 1 5 1
> --stopping trace
> sp_trace_setstatus 1,0
> --status after stopping
> traceid property value
> -- -- -----------
> 1 1 0
> 1 2 c:\JobTrace
> 1 3 5
> 1 4 NULL
> 1 5 0
> I dont see a command to close the Trace, Im just closing Query Anyalyzer.
>
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:eatZvLjOFHA.1396@.TK2MSFTNGP10.phx.gbl...
>> Are you saying you have stopped and closed the trace, and still nothing
>> gets written?
>> If so, can you show the output of fn_trace_getinfo and then exact
>> commands you are running to stop and close the trace?
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:uOTRg8iOFHA.2568@.TK2MSFTNGP14.phx.gbl...
>> Kalen I know this will sound odd, but it almost seems as though nothing
>> gets written ubtil the box is rebooted. It stays at 0kb until I reboot,
>> at which time there is a larger size.
>>
>> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
>> news:OUzjYPfOFHA.2728@.TK2MSFTNGP15.phx.gbl...
>> Hi Chris
>> With server side traces, SQL Server writes to the file in 128K chunks,
>> so you won't see anything written until you have 128K worth of
>> activity.
>> Look at fn_trace_getinfo( ) to check that your trace really is running.
>> Then try stopping and closing the trace:
>> sp_trace_setstatus 1, 0 -- stop the trace
>> sp_trace_setstatus 1, 2 -- close the trace
>> You must stop before closing or the close won't do anything. Only after
>> closing SQL Server write to the file.
>> Or, you can stop the SQL Server services, and that will also flush the
>> collected trace events to the file.
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:u0nrZLfOFHA.904@.tk2msftngp13.phx.gbl...
>>I just created a server side Trace with no filters for testing but Im
>>not able to start it. I call sp_trace_setstatus 1,1 and it says
>>completed successfully. It then creates the file it writes too but
>>never writes to it when I generate activity. Any ideas why?
>> TIA, ChrisR
>> sql2k sp3a
>>
>>
>>
>|||As noted earlier I did this:
--stopping trace
sp_trace_setstatus 1,0
Was I supposed to do this:
--stopping trace
sp_trace_setstatus 1,2
I was hoping to avoid that because BOL say it will delete the definition
from the server. I was hoping to be able to reuse it. Will info not be
written until closed/ deleted?
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:ui3XxrjOFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Closing Qa will not stop or close the trace and the file size may not
> update that often while it is running. If you look at sp_trace_setstatus
> in BOL you will see hope to stop and close the trace.
> --
> Andrew J. Kelly SQL MVP
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:u$QxpVjOFHA.1396@.TK2MSFTNGP10.phx.gbl...
>> --Status before stopping
>> traceid property value
>> -- -- -----------
>> 1 1 0
>> 1 2 c:\JobTrace
>> 1 3 5
>> 1 4 NULL
>> 1 5 1
>> --stopping trace
>> sp_trace_setstatus 1,0
>> --status after stopping
>> traceid property value
>> -- -- -----------
>> 1 1 0
>> 1 2 c:\JobTrace
>> 1 3 5
>> 1 4 NULL
>> 1 5 0
>> I dont see a command to close the Trace, Im just closing Query Anyalyzer.
>>
>> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
>> news:eatZvLjOFHA.1396@.TK2MSFTNGP10.phx.gbl...
>> Are you saying you have stopped and closed the trace, and still nothing
>> gets written?
>> If so, can you show the output of fn_trace_getinfo and then exact
>> commands you are running to stop and close the trace?
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:uOTRg8iOFHA.2568@.TK2MSFTNGP14.phx.gbl...
>> Kalen I know this will sound odd, but it almost seems as though nothing
>> gets written ubtil the box is rebooted. It stays at 0kb until I reboot,
>> at which time there is a larger size.
>>
>> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
>> news:OUzjYPfOFHA.2728@.TK2MSFTNGP15.phx.gbl...
>> Hi Chris
>> With server side traces, SQL Server writes to the file in 128K chunks,
>> so you won't see anything written until you have 128K worth of
>> activity.
>> Look at fn_trace_getinfo( ) to check that your trace really is
>> running.
>> Then try stopping and closing the trace:
>> sp_trace_setstatus 1, 0 -- stop the trace
>> sp_trace_setstatus 1, 2 -- close the trace
>> You must stop before closing or the close won't do anything. Only
>> after closing SQL Server write to the file.
>> Or, you can stop the SQL Server services, and that will also flush the
>> collected trace events to the file.
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:u0nrZLfOFHA.904@.tk2msftngp13.phx.gbl...
>>I just created a server side Trace with no filters for testing but Im
>>not able to start it. I call sp_trace_setstatus 1,1 and it says
>>completed successfully. It then creates the file it writes too but
>>never writes to it when I generate activity. Any ideas why?
>> TIA, ChrisR
>> sql2k sp3a
>>
>>
>>
>>
>|||This is what I said in my first reply to you. Nothing will be written to the
file until the trace is CLOSED.
Please read my first reply again. You must first stop (set status to 0) and
then close (set status to 2).
If you want to save the trace definition, save the SQL commands that you
used to start it, and write them to a file that you can load up again.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ChrisR" <noemail@.bla.com> wrote in message
news:uZ8STvjOFHA.3512@.TK2MSFTNGP15.phx.gbl...
> As noted earlier I did this:
> --stopping trace
> sp_trace_setstatus 1,0
> Was I supposed to do this:
> --stopping trace
> sp_trace_setstatus 1,2
> I was hoping to avoid that because BOL say it will delete the definition
> from the server. I was hoping to be able to reuse it. Will info not be
> written until closed/ deleted?
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:ui3XxrjOFHA.2788@.TK2MSFTNGP09.phx.gbl...
>> Closing Qa will not stop or close the trace and the file size may not
>> update that often while it is running. If you look at sp_trace_setstatus
>> in BOL you will see hope to stop and close the trace.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:u$QxpVjOFHA.1396@.TK2MSFTNGP10.phx.gbl...
>> --Status before stopping
>> traceid property value
>> -- -- -----------
>> 1 1 0
>> 1 2 c:\JobTrace
>> 1 3 5
>> 1 4 NULL
>> 1 5 1
>> --stopping trace
>> sp_trace_setstatus 1,0
>> --status after stopping
>> traceid property value
>> -- -- -----------
>> 1 1 0
>> 1 2 c:\JobTrace
>> 1 3 5
>> 1 4 NULL
>> 1 5 0
>> I dont see a command to close the Trace, Im just closing Query
>> Anyalyzer.
>>
>> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
>> news:eatZvLjOFHA.1396@.TK2MSFTNGP10.phx.gbl...
>> Are you saying you have stopped and closed the trace, and still nothing
>> gets written?
>> If so, can you show the output of fn_trace_getinfo and then exact
>> commands you are running to stop and close the trace?
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:uOTRg8iOFHA.2568@.TK2MSFTNGP14.phx.gbl...
>> Kalen I know this will sound odd, but it almost seems as though
>> nothing gets written ubtil the box is rebooted. It stays at 0kb until
>> I reboot, at which time there is a larger size.
>>
>> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
>> news:OUzjYPfOFHA.2728@.TK2MSFTNGP15.phx.gbl...
>> Hi Chris
>> With server side traces, SQL Server writes to the file in 128K
>> chunks, so you won't see anything written until you have 128K worth
>> of activity.
>> Look at fn_trace_getinfo( ) to check that your trace really is
>> running.
>> Then try stopping and closing the trace:
>> sp_trace_setstatus 1, 0 -- stop the trace
>> sp_trace_setstatus 1, 2 -- close the trace
>> You must stop before closing or the close won't do anything. Only
>> after closing SQL Server write to the file.
>> Or, you can stop the SQL Server services, and that will also flush
>> the collected trace events to the file.
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:u0nrZLfOFHA.904@.tk2msftngp13.phx.gbl...
>>>I just created a server side Trace with no filters for testing but Im
>>>not able to start it. I call sp_trace_setstatus 1,1 and it says
>>>completed successfully. It then creates the file it writes too but
>>>never writes to it when I generate activity. Any ideas why?
>>>
>>> TIA, ChrisR
>>>
>>> sql2k sp3a
>>>
>>
>>
>>
>>
>>
>|||Woops! Thanks Kalen.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:ursw1NkOFHA.3292@.TK2MSFTNGP12.phx.gbl...
> This is what I said in my first reply to you. Nothing will be written to
> the file until the trace is CLOSED.
> Please read my first reply again. You must first stop (set status to 0)
> and then close (set status to 2).
> If you want to save the trace definition, save the SQL commands that you
> used to start it, and write them to a file that you can load up again.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:uZ8STvjOFHA.3512@.TK2MSFTNGP15.phx.gbl...
>> As noted earlier I did this:
>> --stopping trace
>> sp_trace_setstatus 1,0
>> Was I supposed to do this:
>> --stopping trace
>> sp_trace_setstatus 1,2
>> I was hoping to avoid that because BOL say it will delete the definition
>> from the server. I was hoping to be able to reuse it. Will info not be
>> written until closed/ deleted?
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:ui3XxrjOFHA.2788@.TK2MSFTNGP09.phx.gbl...
>> Closing Qa will not stop or close the trace and the file size may not
>> update that often while it is running. If you look at
>> sp_trace_setstatus in BOL you will see hope to stop and close the trace.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:u$QxpVjOFHA.1396@.TK2MSFTNGP10.phx.gbl...
>> --Status before stopping
>> traceid property value
>> -- -- -----------
>> 1 1 0
>> 1 2 c:\JobTrace
>> 1 3 5
>> 1 4 NULL
>> 1 5 1
>> --stopping trace
>> sp_trace_setstatus 1,0
>> --status after stopping
>> traceid property value
>> -- -- -----------
>> 1 1 0
>> 1 2 c:\JobTrace
>> 1 3 5
>> 1 4 NULL
>> 1 5 0
>> I dont see a command to close the Trace, Im just closing Query
>> Anyalyzer.
>>
>> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
>> news:eatZvLjOFHA.1396@.TK2MSFTNGP10.phx.gbl...
>> Are you saying you have stopped and closed the trace, and still
>> nothing gets written?
>> If so, can you show the output of fn_trace_getinfo and then exact
>> commands you are running to stop and close the trace?
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "ChrisR" <noemail@.bla.com> wrote in message
>> news:uOTRg8iOFHA.2568@.TK2MSFTNGP14.phx.gbl...
>> Kalen I know this will sound odd, but it almost seems as though
>> nothing gets written ubtil the box is rebooted. It stays at 0kb until
>> I reboot, at which time there is a larger size.
>>
>> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
>> news:OUzjYPfOFHA.2728@.TK2MSFTNGP15.phx.gbl...
>>> Hi Chris
>>>
>>> With server side traces, SQL Server writes to the file in 128K
>>> chunks, so you won't see anything written until you have 128K worth
>>> of activity.
>>>
>>> Look at fn_trace_getinfo( ) to check that your trace really is
>>> running.
>>>
>>> Then try stopping and closing the trace:
>>> sp_trace_setstatus 1, 0 -- stop the trace
>>> sp_trace_setstatus 1, 2 -- close the trace
>>>
>>> You must stop before closing or the close won't do anything. Only
>>> after closing SQL Server write to the file.
>>> Or, you can stop the SQL Server services, and that will also flush
>>> the collected trace events to the file.
>>> --
>>> HTH
>>> --
>>> Kalen Delaney
>>> SQL Server MVP
>>> www.SolidQualityLearning.com
>>>
>>>
>>> "ChrisR" <noemail@.bla.com> wrote in message
>>> news:u0nrZLfOFHA.904@.tk2msftngp13.phx.gbl...
>>>I just created a server side Trace with no filters for testing but
>>>Im not able to start it. I call sp_trace_setstatus 1,1 and it says
>>>completed successfully. It then creates the file it writes too but
>>>never writes to it when I generate activity. Any ideas why?
>>>
>>> TIA, ChrisR
>>>
>>> sql2k sp3a
>>>
>>>
>>>
>>
>>
>>
>>
>>
>

Sunday, March 25, 2012

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.
> >>
> >>
> >>
> >>
> >>
> >>
> >
>
>

Sunday, March 11, 2012

Can't Run any DM Until Delete Lost Cube?

I (unsuccessfully) made a cube named, MSR TRANCHES. I can't find any trace of it anymore. However, I can't make a new Mining Structure because VS complains of:

Error 1 File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the MSR TRANCHES ~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml'. 0 0

I can't find any cube anywhere, nor do I find this missing file. How does Visual Studio know to look and how do I clear this up.

Thank you very much,

I obtain the same error when I try to develop a mining structure. Anybody know the solution?

Thanks in advance.

|||The error you're seeing indicates that the database is corrupt (internal files associated with certain system objects are missing). If you don't have any other database/objects you need to save on the server, the workaround would be to shut down the AS2005 service (SQL Server Analysis Service (<instancename>)), delete the "\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Data" folder and restart the service.

Thursday, March 29, 2012

cant start Trace

cant start Trace

cant start Trace

Sunday, March 25, 2012

Can't start engine

Sunday, March 11, 2012

Can't Run any DM Until Delete Lost Cube?

sql report manager

Blog Archive

About Me