How to: Verify a Successful Installation of SQL Server 2005 Services
To verify a successful installation of Microsoft SQL Server 2005, make sure that the installed services are running on your computer.
To verify a successful installation of SQL Server 2005 services
Check to see whether the SQL Server service is running: In Control Panel, double-click Administrative Tools, double-click Services, and then look for the corresponding service display name.
The following table lists service display names and the services they provide.
Note
The actual service names differ slightly from their display names. Service names can be viewed by right-clicking a service and selecting Properties.
| Name | Service |
|---|---|
SQL Server (MSSQLSERVER) |
The default instance of the SQL Server Database Engine. |
SQL Server (instancename) |
A named instance of the SQL Server Database Engine, where instancename is the name of the instance. |
SQL Server Agent (MSSQLSERVER) |
The default instance of SQL Server Agent. SQL Server Agent runs jobs, monitors SQL Server, fires alerts, and allows automation of some administrative tasks. |
SQL Server Agent (instancename) |
A named instance of SQL Server Agent, where instancename is the name of the instance. SQL Server Agent runs jobs, monitors SQL Server, fires alerts, and allows automation of some administrative tasks. |
Analysis Services (MSSQLSERVER) |
The default instance of Analysis Services. |
Analysis Server (instancename) |
A named instance of Analysis Services, where instancename is the name of the instance. |
Reporting Services |
The default instance of Microsoft Reporting Services. |
Reporting Services (instancename) |
A named instance of Reporting Services, where instancename is the name of the instance. |
- If the service is not running, start it by right-clicking the service and then clicking Start. If a service fails to start, look at the service properties for the path to the .exe. Make sure the .exe exists in the path specified.
See Also
Tasks
How to: Read a SQL Server 2005 Setup Log File
Concepts
How to: View SQL Server 2005 Setup Log Files
Troubleshooting an Installation of the SQL Server Database Engine
Other Resources
SQL Server Surface Area Configuration