O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required