Validating a SQL Server Installation

SQL Server Setup

To verify a successful installation of SQL Server 2008, ensure that the services for the components you choose to install are running on your computer.

Use the following list of services to verify that the SQL Server service is running.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.

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 specified path.

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 Services (instancename)

A named instance of Analysis Services, where instancename is the name of the instance.

Reporting Services

The default instance of Reporting Services.

Reporting Services (instancename)

A named instance of Reporting Services, where instancename is the name of the instance.

See Also