|
Why does my SQL Server Service Manager say the database is stopped? |
| This is absolutely normal behavior for SQL Server Service Manager when there
is no default instance installed. To use SQL Server Service Manager with a named instance, enter SERVERNAME\INSTANCENAME (e.g. SERVER\WSUS) into the Server field and click on Refresh. This connection is only good for the duration of the uptime, however; a reboot will reset this value. The use of the SQL Server Service Manager is documented in SQL Books Online. To permanently add the WSUS database to the dropdown list of SQL Server Service Manager, use the Client Network Utility to create an ALIAS for the WSUS server, which will then be picked up by the Service Manager, and you can pick the database from the dropdown list. |