Configuring SQL Server Services

SQL Server Configuration Manager is implemented in a custom Microsoft Management Console and also available as a snap-in that you can add to your own custom consoles. You can start SQL Server Configuration Manager using one of the following techniques:

  • Log on to the database server through a local or remote login, and then start SQL Server Configuration Manager by clicking the Start button; pointing to All Programs, Microsoft SQL Server 2008, Configuration Tools; and then selecting SQL Server Configuration Manager. You can also start this tool by clicking Start, typing sqlservermanager10.msc in the Search box, and then pressing Enter.

  • In SQL Server Management Studio, open the Registered Servers view by pressing Ctrl+Alt+G. ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.