The issue being discussed in this article is:
You get the following error when attempting to connect to your SI Client to your SI Server:
We cannot connect to your SQL Server database on the server.
Please check if your SQL Server service is running on the server.
Click the 'Information' icon to get more information on how to solve the problem.
The following is the screenshot of the error:
The following are some of the causes:
No connectivity with the SI Server machine.
DNS resolution failed.
D-Tools SI service is not running on the SI Server machine.
The following is the resolution:
Ping SI Server
Verify that you can ping your SI Server machine.
1/ In Windows, click Start, type Command prompt in the Search menu, and click Command prompt.
2/ In the Command Prompt window, type the following and click Enter.
ping [ServerName]
Example: The SI Server is installed on a machine named SENOSLAPTOP. You would type in the following: ping senoslaptop.
Outcome One
If able to ping, move on to the "Verify Service is Running" section.
If unable to ping using the machine name, type the following and press Enter.
ping [ServerIPAddress]
Example: The SI Server is installed on a machine with the IP Address: 10.24.7.420. You would type in the following: ping 10.24.7.420.
Outcome Two
If you are able to ping your SI Server with the IP address but not the machine name, you might have a DNS issue on your network that prevents you from logging in with the machine name.
Try logging in with the IP address vs. the machine name on the Connect to SI form.
If that still returns the same error, you might need to modify the Hosts file on your machine.
See the "Modifying your Hosts file" section.
Outcome Three
If pinging by IP address fails AND pinging by machine name fails, your SI Client machine cannot communicate with our SI Server machine.
Contact your network administrator.
If you cannot resolve this issue, please open a Support Ticket.
Verify Service is Running
If you can access the machine running your SI Server, verify that the D-Tools SI service is running.
If you updated to SI from SIX 2013 or SI2015, your service may be named "D-Tools SIX Service."
If the service does not show as Started, right-click the D-Tools SI Service entry and choose Start.
See if you can now connect to the SI Server.
Check your Firewall Settings
Check out this article for more details.
Modify your Hosts File
On your SI Client machine, open the following file in Notepad.
C:\Windows\System32\drivers\etc\hosts
Modify your Hosts file.
Example: If your SI Server is installed on a machine with the machine name "MYMACHINE" and IP Address "10.1.24.562", then the Hosts file should look something like this.
If you cannot resolve this issue, please open a Support Ticket.