Restarting SQL service

Restarting SQL service

For multi-user Chequewriter or Accounting system, there will be a SQL server installed.
the PC where the SQL server is installed is commonly referred to as the Main PC.

the SQL server runs as a service inside the Main PC.
sometimes this service is stopped and you will receive messages like 'Server not found'
there are a various reasons why the service is stopped, but the common cause is due to windows updates. 
the updates will stop the service while running to prevent data loss. 
the service may not get started after the update so you'll need to restart the service.

Go to control panel -> Administrative Tools

Find Services

Look for the service 'SQL Server'

it is our default to name the SQL instance 'OCI2008R2' 
the name on your service may differ.
the Status is 'Blank', this means that it is not running.

Click on 'Start' or the 'play' button to start the service.

Once the status says 'Running', you can try the connection again.

    • Related Articles

    • Configuring the Microsoft SQL Server Configuration Manager

      Click on the Windows Start Button, choose all programs. Then click menus in following order… 1. Click on Microsoft SQL Server 2008 R2 2. Click on Configuration Tools 3. Click on SQL Server Configuration Manager ...
    • Microsoft SQL Server 2008 R2 Installation

      Click on the New Installation  option to continue the Installation. Tick “I accept the License Terms” check box on the above window and click next button. Wait for a while to next window to appear… ...
    • Restoring of Customer Database of Microsoft SQL Server 2008 R2

      On this page we can find the way to connect to our Microsoft SQL Server 2008 R2 and restoring our company database Backup to the "ocac" database from the installation CD or from our previous ...
    • Cloud Server Hosting Services

      Switch to Cloud Server Hosting Now! System can be used anywhere. It provides users with the flexibility of having their database cloud hosted. Freeing users from the need to be desk bound. Your Accounting data is hosted on a secure enterprise class ...
    • Microsoft SQL Server 2008R2 Express

      Your can download the MS SQL server from microsoft website. you can download this. SQLEXPRWT_x64_ENU.exe