move msdb

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,

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

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

Thanks,

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

After adding ;–c;-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,

|||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.
|||I have tested above method and it is working on my SQL server 2005 developer edition.