Environment: How to start / stop SQL
Description

When trying to access Sage Taxation, the following message may appear:

'Failed to connect to server - COMPUTERNAME\SAGESPS
Timeout - COMPUTER NAME\SAGESPS may not be accessible or the SQL Instance is not running'

Cause
Resolution
Windows 10 and server variants
    1. On Windows 10 and server variants you can access the list of services by either:
      • Click the start button and type services. You're looking for the option that says Services - Desktop app
      • Right click the start menu icon and select Computer management. Expand Services and applications in the left hand pane and select Services
    2. In the list of services find SQL Server (Instance name)
    3. Right click on the required instance and select Start

TIP: The instance name will usually be SageSPS or SageTax.

You can use the same process to stop or restart SQL by selecting the appropriate option after right clicking.

Windows 7, 8, and server variants
    1. Select Start, Run and enter services.msc
    2. In the list of services find SQL Server (Instance name)
    3. Right click on the required instance and select Start

TIP: The instance name will usually be SageSPS or SageTax.

You can use the same process to stop or restart SQL by selecting the appropriate option after right clicking.


[BCB:19:UK - Sales message :ECB]

Steps to duplicate
Related Solutions