David Ray

Just got SI5 set up and starting to enter in data. I came into the office this morning and got the error below when logging in. When I reboot the server (actually an XP box - clean install) I can then log in without problem. Do I need to adjust something in the SQL manager?

-------

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.10626.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.ListDictionaryInternal

rjsuryan

I'm getting this exact same error when trying to login to the server with my laptop. I've tried everything I can think of.

__________________
Robert

"One will have to stand on top of a mountain with their mouth open a very long time before a roast duck will fly in their mouth"

Reed Phillips

If you have not done so, please contact http://www.d-tools.com/support/submit-an-issue.html. I forwarded this post, but they may not have your contact info.

__________________
Reed Phillips

Reed Phillips

Also...
For the application to communicate with a server that has the Windows Firewall service running the three following exceptions must be added to the Windows Firewall on the server machine:

• C:\Program Files\D-Tools\SI 5\Server\DToolsFileMgrServer.exe (port 9000 by default)
• C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe (port 1434 by default)
• C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe (port 1433 by default)

__________________
Reed Phillips

David Ray

I had those exceptions in the firewall per the setup instructions... It hasn't happened since I applied the Service Pack.