Export (0) Print
Expand All

Validating a SQL Server Installation

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.

NoteNote

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.

Community Additions

ADD
Show:
© 2014 Microsoft