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

Troubleshooting Configuration Problems

There are two specific techniques that you can use to resolve SQL Server configuration problems. In this section, you will learn how to recover from a bad configuration and how to rebuild the master database.

Recovering from a Bad Configuration

Although SQL Server 2005 has many safeguards that help you avoid configuration settings that keep SQL Server from starting, you may occasionally find that a configuration change prevents SQL Server from starting. If you encounter this situation, you can recover the server instance by completing the following steps:

  1. Log on to the affected server locally, or log on remotely through Telnet or Terminal Server. You must log on using a local administrator account or the account ...

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