TopSQL


I am getting following error when moving msdb database to different drive.

¡°SQL SERVER is in SINGLE USER MODE and only one administrator can connect¡±

I followed steps menthioned in http://support.microsoft.com/kb/224071

Also, it was mentioned that even object browser is also one connection- http://deepakinsql.blogspot.com/2007/08/moving-system-databases-in-sql-2005.html , so I closed that but didn't work.

I am using SQL 2005 Enterprise non clustered with no service pack on windows 2003 server

Did anybody faced this problem and found any solution.

thanks,





Re: move msdb

waqaramin


Hi
This will help.
http://support.microsoft.com/kb/224071#





Re: move msdb

TopSQL

I used the same KB article but still getting the error.

Thanks,







Re: move msdb

waqaramin

May be this help
Stop the SQL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service uses the connection, thereby blocking it.




Re: move msdb

TopSQL

After adding ;¨Cc;-m;-T3608 at the end of starup, restart came with SQL Agent not running. So SQL Agent is not running . Moreover I stopped other services like sql browser , Integration service , Analysis service to make sure nobody is connecting. Can I see who is using administrator connection to figure out where it is getting used

Thanks,






Re: move msdb

waqaramin

STOP SQL SERVICES.
START SQL FROM command prompt

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlservr.exe -m
Connect using SQL Management Studio.




Re: move msdb

waqaramin

I have tested above method and it is working on my SQL server 2005 developer edition.