single user mode - list connections
Posted on 2007-11-30
I am trying to move the location of my 'msdb' database. I stopped the Agent service, Analysis service, reporting service and Fulltext service for this instance.
I started up my default instance of sql server 2005 instance in single user mode using the following:
net stop mssqlserver
net start mssqlserver /c /m /T3608
I then type SQLCMD at the prompt and get the following:
Msg 18461, Level 14, State 1, Server XXXXX, Line 1
Login failed for user 'yyyy\xxxx'. Reason: Server is in single user mode. Only one administrator can connect at this time.
I assume that something is connecting to this instance automatically. How can i list / determine what it is?