Resolving SQL Errors when WinTOTAL Starts

This document explains how to resolve SQL errors that occur when starting WinTOTAL

Document 5084  ¦  Last updated:  09/18/2014 KMG

The most frequent symptom is that you receive an error that says "The following error occurred logging into WinTOTAL.    [DBNETLIB][ConnectionOpen (Connect()).  ]SQL Server does not exist or access denied.  " when trying to open WinTOTAL.


Possible Solution 1

If you're using WinTOTAL on a network, you must do this from the server.

  1. On your keyboard, press Windows Key + R to open a Run prompt.

  2. In the Open: field, type services.msc and click OK.

  3. When a list of services appears, scroll down the list until you find a service called MSSQL$ALAMODE or SQL Server (Alamode).

  4. If the Status of this service does not say Started, right-click it and choose Start.
  5. Now, double-click that service and verify that the Startup Type is set to Automatic in the drop‑down list.  If it's not set to Automatic, change it to Automatic and click OK to save the change.

  6. Repeat step 6 for the following services in the list.
    • Computer Browser
    • Server
  7. Once the progress bar disappears, try opening WinTOTAL again.  If the problem persists, try Possible Solution 2.

Possible Solution 2

  1. On your keyboard, press Windows Key + R to open a Run prompt.

  2. In the Open: field, type tsa and click OK.

  3. Choose WinTOTAL Utilities and click Next.
  4. Find 2.  Set Up Database Connection in the left‑hand column and double-click it.
  5. A SafeStart Log will appear.  Close it along with any other Tech Support Assistant windows and try to start WinTOTAL again.
  6. If the problem persists, try Possible Solution 3.

Possible Solution 3

  1. Repeat steps 1 and 2 listed above in Possible Solution 2 and then double-click 1.  Database Verification Scripts in the left‑hand column.
  2. A screen appears prompting you to choose a database version.  Scroll down the list and find the bottom‑most item in the list.  Click it and then click OK.

  3. Close the Tech Support Assistant and try to open WinTOTAL again.  If the problem persists, try Possible Solution 4.

Possible Solution 4

At this point, if the problem is still occurring, we'll need to gather some information about your computer to proceed.  If your copy of WinTOTAL is running on a network server, be sure to follow the steps below from the server rather than a workstation.  If you're using a standalone installation of WinTOTAL, just follow these steps from your computer.

  1. On your keyboard, press Windows Key + Pause|Break.

  2. In the window that appears, find the Full Computer Name that's listed and write it down.  For example, the Computer Name listed below is IE9Win7.    If you're using WinTOTAL on a network, return to the workstation experiencing the problem before continuing to step 5.

  3. Now, press Windows Key + R on your keyboard to open a Run prompt.

  4. In the Open: field, type tsa and click OK.

  5. Choose Edit System Files and click Next.
  6. Click alamode.ini in the System Files box.  Then find and click [LOCAL CONNECTION] in the INI Sections box.
  7. In the bottom box, you'll see a "Server=" line under the [LOCAL CONNECTION] line.  Make sure that the Computer Name (the part before \ALAMODE) listed there is the same as the Computer Name you wrote down.  If it's not the same, type in the Computer Name you wrote down in step 4.  Keep in mind that this must be in all caps.

  8. Click Save and then click Finished.
  9. Close the Tech Support Assistant and try running WinTOTAL again.  If the problem persists, move on to Possible Solution 5.

Possible Solution 5

At this point, there's one last potential problem.

  1. On your keyboard, press Windows Key + R to open a Run prompt.

  2. In the Open: field, type cliconfg.exe.

  3. In the screen that appears, you'll see Named Pipes and TCP/IP listed under the Enabled Protocols.  Click TCP/IP and then click Properties.

  4. In the screen that appears, write down the port number listed and close all Tech Support or SQL utilities.    Keep in mind, the port number you see may not match the port number in the screenshot below.

    port number

  5. Now, go to the workstation experiencing the problem and click Start, Run and type "telnet <Computer Name> <Port Number>" where the <Computer Name> is the one you wrote down in Possible Solution 4 and the <Port Number> is the one you wrote down in the previous step.
    Be sure that you do not type in the < and > brackets.
  6. Press Enter on your keyboard.
  • If you see a blank black screen, everything should be working properly.  Call a la mode Tech Support for further assistance with this problem.
  • If you receive an error about not being able to connect, that's the problem.  Something (possibly a firewall) is blocking WinTOTAL from communicating on that port.  Contact a local technician for assistance diagnosing why that port is blocked and be sure to have the local tech unblock the port to resolve this problem.    If you believe the problem to be a firewall on your computer, click here for instructions on resolving the issue.

Related Links