I have an issue when starting sql server in multiuser mode

Question

I have started sql server in single user mode for restoring my master database and I have done the restore and after that when I start my server in multiuser mode I'm not able to start in multi user mode.

I'm getting the below error

Cannot connect to XPWINDOWS7\SQL1.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'XPWINDOWS7\kartik'. Reason: Server is in single user mode. Only one administrator can connect at this time. (Microsoft SQL Server, Error: 18461)

When I looked into error log file I'm having something like this

SQL Server blocked access to procedure 'dbo.sp_sqlagent_has_server_access' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs'.
2012-02-18 10:32:32.42 spid51      SQL Server blocked access to procedure 'dbo.sp_sqlagent_get_startup_info' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online.
2012-02-18 10:32:32.64 spid51      Configuration option 'Agent XPs' changed from 0 to 0. Run the RECONFIGURE statement to install.

I have done this too from my command prompt

sqlcmd>sp_confiugure 'agent xps',1 reconfigure                                                                              go    

It is giving output like agent xps value has been changed from 1 to 1

My agent service is also not starting how can i overcome this situation.                                                    

Answer 1

Login to the Host with Admin Account which has SA privilege on SQL server

@ Command Prompt

net stop MSSQLSERVER

this will stop the SQL Services

and again Run

net stop MSSQLSERVER /m



---

Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::