Error Using Guru, "Unable To Connect To Server"

Subject

The user is trying to access Guru from a workstation, and when attempting to connect to the database, they get a message "Unable To Connect To Server".

The SQL Server will not connect to the local database (localhost).
- It will also not restart the service from the services menu in Admin Tools.


Solution

  1. Click on Start, then Settings, and then Control Panel.
  2. Go into Administrative Tools, and then Services.
  3. Right click on SQLEXPRESS (SQL Server (MVSQLEXPRESS)).
    • Click on Properties.
    • Under the Log On tab, select the option for Local System Account.
    • Put a check in the Allow service to interact with desktop (or local services).
    • Then click Apply, and then OK.
    • The user will get a message stating the changes will not take effect until the service is restarted. The best way to do this is to restart the computer.