Export (0) Print
Expand All

How to: Verify a Successful Installation of SQL Server 2005 Services

SQL Server 2005

To verify a successful installation of Microsoft SQL Server 2005, make sure that the installed services are running on your computer.

  1. 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.

    ms143673.note(en-US,SQL.90).gifNote:
    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.

  1. 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.

Community Additions

ADD
Show:
© 2014 Microsoft