Could not connect to D-Tools SQL
Table of contents
Error Synchronizing Data
Issue: When attempting to synchronize your data, you receive the following error:
Could not connect to D-Tools SQL Server database. Error is: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Cause: The major reason this occurs is when the SI5 Client machine and the SI5 Server machine are not on the same domain or workgroup. Another reason this may occur is if either the "SQL Server (DTOOLSV5)" or the "SQL Server Browser" services on your SI5 Server have been stopped.
Fix 1: Note: If you are running Windows7/Vista, right-click the "System Integrator 5" icon and choose "Run as administrator":
Fix 2: Add your SI5 Client machine to the same domain or workgroup.
- Right-click on "Computer" and select Properties:
- In the "Computer name, domain and workgroup settings" section, click "Change Settings":
- Click the [Change...] button:
- Make the appropriate changes and click [OK]. You will be prompted to enter the credentials of an Administrator for your server.
- Restart your computer for changes to take effect.
Fix 3: Re-start one or both of the services on your SI5 Server machine.
- On your SI5 Server, click the Windows button and type "services.msc" (w/out the quotes) in the search box.
- When the window opens, scroll down and verify that both the "SQL Server (DTOOLSV5)" or the "SQL Server Browser" services are started.
- If either is not started, right-click and choose "Start":
SQL 2008 Users
The above fixes may not be sufficient if you are using SQL 2008.
Fix 4: If you are using SQL 2008, there is a change you must make to your SQL server configuration in order for syncing to work.
- Click the Windows (Start) button and select All Programs->Microsoft SQL Server 2008->Configuration Tools->SQL Server Management Studio.
- For your instance of SQL under "SQL Server Network Configuration" and for the Client Protocols under "SQL Native Client Configuration" you will need to change "Named Pipes" and "TCP/IP" to be Enabled. In the screen shot below, the SQL instance is named "DTOOLSV5" but yours will be whatever existing SQL instance you created.
- Stop and restart your SQL service.
If you still receive the error after making the changes above, you may need to make one more additional change.
- On your SI5 Server, open the following file in Notepad: C:\ProgramData\D-Tools\SI5\ClientConfiguration.xml
(if using XP the path is - C:\Documents and Settings\All Users\D-Tools\SI5\ClientConfiguration.xml)
- Remove the backslash at the end of the "Database Server" node following the name of your server machine. In the screen shot below, the machine name is DT4136:
- Save the changes to the config file.
- © Copyright 2023 D-Tools