none
SQL Server Service Manager

    Question

  • Where is the icon for the SQL Server Service Manager?  I'm reading the Access 2003 Bible and I want to test accessing SQL Server, and I'm not sure where it installs that.  Thanks!

    Monday, October 22, 2007 6:54 PM

Answers

  • Which version of SQL Server you're using?

    If it is SQL 2005 and above than you don't find SQL Server Service Manager Icon.

    The same can be accomplished by using SQL Server Configuration Manager - > SQL Server 2005 Services.

    In SQL Server 2005 you can also use SQL Server Surface Area Configuration for starting, stoping & pausing sql server services.

    Thanks,

    Vishal Srivastava


    Regards, Vishal Srivastava
    Monday, July 11, 2011 12:07 PM
  • Hi,

    There is no SQL Server Service Manager available since SQL Server 2005, It was available in SQL Server 7.0 and 2000 only

    There is a open source tool available in CodePlex which gives the same functionality, you can download it from this link

    http://sql2005srvcmngr.codeplex.com/

    Alternatively you can use "SQL Server Configuration Manager" under Start Menu -> All Programs -> Microsoft SQL Server -> Configuration Tools 


    Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
    If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"
    Tuesday, July 12, 2011 8:24 PM

All replies

  • You might need to download the SQL Server Management Studio in order to get access to the service.  You can find that download on the Express web site.

     

    Wednesday, October 24, 2007 12:02 AM
  • If you are looking for SQL Server Service Manager that comes with SQL2000 , there is no equivalent in SQL2005. SQL Server Configuration Manager have more functionality than SQL Server Service Manger in 2000. If you are talking about SQL Server Management Studio (equivalent to Enterprise manager in 2000) then as already mention you can downlaod from http://msdn2.microsoft.com/en-us/express/bb410792.aspx

     

    Madhu

     

    Wednesday, October 24, 2007 6:10 AM
    Moderator
  • SQL Server 2005 does NOT include the Service Manager applet.

     

    However, here is a download of a 'free' product that accomplishes just about the same tasks.

     

    SQL Server 2005 Service Manager Alternative
    http://www.sqldbatips.com/showarticle.asp?ID=46

     

     

    Wednesday, October 24, 2007 7:22 AM
    Moderator
  • Which version of SQL Server you're using?

    If it is SQL 2005 and above than you don't find SQL Server Service Manager Icon.

    The same can be accomplished by using SQL Server Configuration Manager - > SQL Server 2005 Services.

    In SQL Server 2005 you can also use SQL Server Surface Area Configuration for starting, stoping & pausing sql server services.

    Thanks,

    Vishal Srivastava


    Regards, Vishal Srivastava
    Monday, July 11, 2011 12:07 PM
  • I hope you get the answer from all the above answers. You can check the SQL Server Services using services.msc/or from control panel services windows.


    Thanks, Jugal Shah http://sqldbpool.com/
    Monday, July 11, 2011 12:11 PM
  • Hi,

    There is no SQL Server Service Manager available since SQL Server 2005, It was available in SQL Server 7.0 and 2000 only

    There is a open source tool available in CodePlex which gives the same functionality, you can download it from this link

    http://sql2005srvcmngr.codeplex.com/

    Alternatively you can use "SQL Server Configuration Manager" under Start Menu -> All Programs -> Microsoft SQL Server -> Configuration Tools 


    Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
    If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"
    Tuesday, July 12, 2011 8:24 PM