Hello:

I spent countless hours last night and this AM trying to move the
mssqlsystemresource database in concert with that knowledgebase article for
which I wish I had an identifying number to give to you. It's the article
that shows you how to move system databases.

I have started my steps all over again. And, I have followed them to the
letter, so regurgitating the steps for me here in this posting will do me no
good. My problem is that stupid message that comes up when you try to run
ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
Login failed for user.....Server is in single user mode...Only one
administrator can.....Effor 18461.

I have read tons of articles on Google, I have stopped all ancillary
services, I'm the only one on the server, etc.--no success

Any ideas at all?

SQL Programmer

Hi
check this

From the management studio, open the database property window
what is the value of
database properties->Resctrict Access option

vinu

"SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in message
news:7645C609-71EA-4B39-AE10-B3D80D8D4BEE@microsoft.com...
> Hello:
>
> I spent countless hours last night and this AM trying to move the
> mssqlsystemresource database in concert with that knowledgebase article
> for
> which I wish I had an identifying number to give to you. It's the article
> that shows you how to move system databases.
>
> I have started my steps all over again. And, I have followed them to the
> letter, so regurgitating the steps for me here in this posting will do me
> no
> good. My problem is that stupid message that comes up when you try to run
> ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
> Login failed for user.....Server is in single user mode...Only one
> administrator can.....Effor 18461.
>
> I have read tons of articles on Google, I have stopped all ancillary
> services, I'm the only one on the server, etc.--no success
>
> Any ideas at all?
>
> SQL Programmer

MULTI-USER

"vinu" wrote:

> Hi
> check this
>
> From the management studio, open the database property window
> what is the value of
> database properties->Resctrict Access option
>
> vinu
>
> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in message
> news:7645C609-71EA-4B39-AE10-B3D80D8D4BEE@microsoft.com...
> > Hello:
> >
> > I spent countless hours last night and this AM trying to move the
> > mssqlsystemresource database in concert with that knowledgebase article
> > for
> > which I wish I had an identifying number to give to you. It's the article
> > that shows you how to move system databases.
> >
> > I have started my steps all over again. And, I have followed them to the
> > letter, so regurgitating the steps for me here in this posting will do me
> > no
> > good. My problem is that stupid message that comes up when you try to run
> > ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
> > Login failed for user.....Server is in single user mode...Only one
> > administrator can.....Effor 18461.
> >
> > I have read tons of articles on Google, I have stopped all ancillary
> > services, I'm the only one on the server, etc.--no success
> >
> > Any ideas at all?
> >
> > SQL Programmer
>
>
>

also

close magement studio

--2005

open server configuration manger->SQL Server-> Advanced tab-> check the
startup parameter has -m value or not

-2000
http://www.cryer.co.uk/brian/sqlserv..._user_mode.htm


"vinu" <vinu.t.1976@gmail.com> wrote in message
news:O2ztxsT0IHA.1628@TK2MSFTNGP03.phx.gbl...
> Hi
> check this
>
> From the management studio, open the database property window
> what is the value of
> database properties->Resctrict Access option
>
> vinu
>
> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in
> message news:7645C609-71EA-4B39-AE10-B3D80D8D4BEE@microsoft.com...
>> Hello:
>>
>> I spent countless hours last night and this AM trying to move the
>> mssqlsystemresource database in concert with that knowledgebase article
>> for
>> which I wish I had an identifying number to give to you. It's the
>> article
>> that shows you how to move system databases.
>>
>> I have started my steps all over again. And, I have followed them to the
>> letter, so regurgitating the steps for me here in this posting will do me
>> no
>> good. My problem is that stupid message that comes up when you try to
>> run
>> ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
>> Login failed for user.....Server is in single user mode...Only one
>> administrator can.....Effor 18461.
>>
>> I have read tons of articles on Google, I have stopped all ancillary
>> services, I'm the only one on the server, etc.--no success
>>
>> Any ideas at all?
>>
>> SQL Programmer
>
>

if it has -m option, remove it and start the service again

"vinu" <vinu.t.1976@gmail.com> wrote in message
news:%23tSuzxT0IHA.5728@TK2MSFTNGP06.phx.gbl...
> also
>
> close magement studio
>
> --2005
>
> open server configuration manger->SQL Server-> Advanced tab-> check the
> startup parameter has -m value or not
>
> -2000
> http://www.cryer.co.uk/brian/sqlserv..._user_mode.htm
>
>
> "vinu" <vinu.t.1976@gmail.com> wrote in message
> news:O2ztxsT0IHA.1628@TK2MSFTNGP03.phx.gbl...
>> Hi
>> check this
>>
>> From the management studio, open the database property window
>> what is the value of
>> database properties->Resctrict Access option
>>
>> vinu
>>
>> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in
>> message news:7645C609-71EA-4B39-AE10-B3D80D8D4BEE@microsoft.com...
>>> Hello:
>>>
>>> I spent countless hours last night and this AM trying to move the
>>> mssqlsystemresource database in concert with that knowledgebase article
>>> for
>>> which I wish I had an identifying number to give to you. It's the
>>> article
>>> that shows you how to move system databases.
>>>
>>> I have started my steps all over again. And, I have followed them to
>>> the
>>> letter, so regurgitating the steps for me here in this posting will do
>>> me no
>>> good. My problem is that stupid message that comes up when you try to
>>> run
>>> ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
>>> Login failed for user.....Server is in single user mode...Only one
>>> administrator can.....Effor 18461.
>>>
>>> I have read tons of articles on Google, I have stopped all ancillary
>>> services, I'm the only one on the server, etc.--no success
>>>
>>> Any ideas at all?
>>>
>>> SQL Programmer
>>
>>
>
>

also if its hasn't got -m optipn then do this

1.. Use SP_Who to find the session ID of the active connection to the
database
2.. Use KILL <soid> to terminate the connection.
3.. Then do the Alter Database command you tried.


"vinu" <vinu.t.1976@gmail.com> wrote in message
news:%23tSuzxT0IHA.5728@TK2MSFTNGP06.phx.gbl...
> also
>
> close magement studio
>
> --2005
>
> open server configuration manger->SQL Server-> Advanced tab-> check the
> startup parameter has -m value or not
>
> -2000
> http://www.cryer.co.uk/brian/sqlserv..._user_mode.htm
>
>
> "vinu" <vinu.t.1976@gmail.com> wrote in message
> news:O2ztxsT0IHA.1628@TK2MSFTNGP03.phx.gbl...
>> Hi
>> check this
>>
>> From the management studio, open the database property window
>> what is the value of
>> database properties->Resctrict Access option
>>
>> vinu
>>
>> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in
>> message news:7645C609-71EA-4B39-AE10-B3D80D8D4BEE@microsoft.com...
>>> Hello:
>>>
>>> I spent countless hours last night and this AM trying to move the
>>> mssqlsystemresource database in concert with that knowledgebase article
>>> for
>>> which I wish I had an identifying number to give to you. It's the
>>> article
>>> that shows you how to move system databases.
>>>
>>> I have started my steps all over again. And, I have followed them to
>>> the
>>> letter, so regurgitating the steps for me here in this posting will do
>>> me no
>>> good. My problem is that stupid message that comes up when you try to
>>> run
>>> ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
>>> Login failed for user.....Server is in single user mode...Only one
>>> administrator can.....Effor 18461.
>>>
>>> I have read tons of articles on Google, I have stopped all ancillary
>>> services, I'm the only one on the server, etc.--no success
>>>
>>> Any ideas at all?
>>>
>>> SQL Programmer
>>
>>
>
>

Thanks!

"vinu" wrote:

> also if its hasn't got -m optipn then do this
>
> 1.. Use SP_Who to find the session ID of the active connection to the
> database
> 2.. Use KILL <soid> to terminate the connection.
> 3.. Then do the Alter Database command you tried.
>
>
> "vinu" <vinu.t.1976@gmail.com> wrote in message
> news:%23tSuzxT0IHA.5728@TK2MSFTNGP06.phx.gbl...
> > also
> >
> > close magement studio
> >
> > --2005
> >
> > open server configuration manger->SQL Server-> Advanced tab-> check the
> > startup parameter has -m value or not
> >
> > -2000
> > http://www.cryer.co.uk/brian/sqlserv..._user_mode.htm
> >
> >
> > "vinu" <vinu.t.1976@gmail.com> wrote in message
> > news:O2ztxsT0IHA.1628@TK2MSFTNGP03.phx.gbl...
> >> Hi
> >> check this
> >>
> >> From the management studio, open the database property window
> >> what is the value of
> >> database properties->Resctrict Access option
> >>
> >> vinu
> >>
> >> "SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in
> >> message news:7645C609-71EA-4B39-AE10-B3D80D8D4BEE@microsoft.com...
> >>> Hello:
> >>>
> >>> I spent countless hours last night and this AM trying to move the
> >>> mssqlsystemresource database in concert with that knowledgebase article
> >>> for
> >>> which I wish I had an identifying number to give to you. It's the
> >>> article
> >>> that shows you how to move system databases.
> >>>
> >>> I have started my steps all over again. And, I have followed them to
> >>> the
> >>> letter, so regurgitating the steps for me here in this posting will do
> >>> me no
> >>> good. My problem is that stupid message that comes up when you try to
> >>> run
> >>> ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
> >>> Login failed for user.....Server is in single user mode...Only one
> >>> administrator can.....Effor 18461.
> >>>
> >>> I have read tons of articles on Google, I have stopped all ancillary
> >>> services, I'm the only one on the server, etc.--no success
> >>>
> >>> Any ideas at all?
> >>>
> >>> SQL Programmer
> >>
> >>
> >
> >
>
>
>

If you don't know what else may getting into your SQL instance before you
have a chance when the SQL instance is in the single user mode, you can
enable only TCP netlib, change its port to a different one, and stop
SQLBrowser. This should prevent other programs from connecting to the
instance.

Linchi

"SQL Programmer" wrote:

> Hello:
>
> I spent countless hours last night and this AM trying to move the
> mssqlsystemresource database in concert with that knowledgebase article for
> which I wish I had an identifying number to give to you. It's the article
> that shows you how to move system databases.
>
> I have started my steps all over again. And, I have followed them to the
> letter, so regurgitating the steps for me here in this posting will do me no
> good. My problem is that stupid message that comes up when you try to run
> ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
> Login failed for user.....Server is in single user mode...Only one
> administrator can.....Effor 18461.
>
> I have read tons of articles on Google, I have stopped all ancillary
> services, I'm the only one on the server, etc.--no success
>
> Any ideas at all?
>
> SQL Programmer

Hi,

I also spent countless hours on exactly the same step while I tried to move
the
mssqlsystemresource database according to the knowledgebase article
mentioned here.

> My problem is that stupid message that comes up when you try to run
> ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
> Login failed for user.....Server is in single user mode...Only one
> administrator can.....Effor 18461.

Finally I've got the idea to stop the Reporting Server Service, which I had
installed on a remote machine. The remaing steps afterwards were easy after I
corrected some spelling mistakes.

Thanks to those who posted the necessary steps before.

Be very carefull with changing locations of system databases like the
mssqlsystemresource database and master, model and msdb.

When you go install en Cumulative Update or Service Pack, it presumes the
location of the systemdatabases to be where they where during installation.
If you do not move the systemdatabases back to their original location
before installing a CU or SP, your system will become unusable after de
installation of the CU or SP.

Please test this very carefully.

Gé

"Ursli from Switzerland" <Ursli from Switzerland@discussions.microsoft.com>
wrote in message news:9159471A-6531-480A-AA05-AB296A31CBB1@microsoft.com...
> Hi,
>
> I also spent countless hours on exactly the same step while I tried to
> move
> the
> mssqlsystemresource database according to the knowledgebase article
> mentioned here.
>
>> My problem is that stupid message that comes up when you try to run
>> ALTER DATABASE in either sqlcmd or or in the Management Studio. It says
>> Login failed for user.....Server is in single user mode...Only one
>> administrator can.....Effor 18461.
>
> Finally I've got the idea to stop the Reporting Server Service, which I
> had
> installed on a remote machine. The remaing steps afterwards were easy
> after I
> corrected some spelling mistakes.
>
> Thanks to those who posted the necessary steps before.