Error on attempting to connect to server - D-Tools Forum

NCUSA · 10-09-2007, 07:12 AM

Following is the error I have recieved every time I start SI5 from a remote computer over the network (wireless and wired)

Desription: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Email:
User Message:
Details: Error: SqlException ErrorCode=-2146232060 (DTools.SystemIntegrator.Registration.Client.View. LoginForm.SignInButton_Click) V5.0.10905.0

Source: .Net SqlClient Data Provider

Stacktrace:
at DTools.SystemIntegrator.Registration.Client.View.L oginForm.SignInButton_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Errors=System.Data.SqlClient.SqlErrorCollection
Class=20 (0x14)
LineNumber=0 (0x0)
Number=-1 (0xFFFFFFFF)
Server=
State=0 (0x0)
ErrorCode=-2146232060 (0x80131904)
Message=An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Data=System.Collections.ListDictionaryInterna

No problems if I use the the computer athe database is instlled on.

10-09-2007, 04:44 PM

Since it works on the server and nowhere else it sounds like some kind of network setup issue.

First thing I would check is to make sure you don't have the Windows firewall turned on for your server. If you do then thats probably the issue. The appropriate exceptions can be found in the Installation guide. If you don't have the Windows firewall turned on then check for other security software that might be blocking the connection.

JoseM · 10-09-2007, 05:21 PM

Log in from your main machine, go to FILE > LANSync ONLINE, then exit SI5. Go to the client machine and login. This should fix the error as we did on the phone.

This error happened when installing a CLIENT version on a LAPTOP (LANSync Administered), then trying to connect to the main desktop server.

09-19-2008, 06:58 PM

I get the same problem. From what I can see in the install guide it just says to open the request port. I kept mine at 9000 and added this as a rule to windows firewall. However, unless I turn off windows firewall I still get issues.

Windows firewall is not all that important to me as we are covered by our router. Just thought I would point this out.