Configuring SQL Server Services

SQL Server Configuration Manager is found under Programs or All Programs\Microsoft SQL Server 2005\Configuration Tools. It can also be started from the command line by typing sqlservermanager.msc at a command prompt (assuming you’ve modified your path appropriately). This tool provides quick access for managing and maintaining SQL Server services.

Managing Service State and Start Mode

SQL Server Surface Area Configuration provides basic facilities for managing service startup and startup type. You can use the Services utility or SQL Server Configuration Manager to manage more advanced features. With the Services utility, you manage SQL Server services as you would any other service. With SQL Server Configuration Manager, ...

Get Microsoft® SQL Server™ 2005 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.