cannot connect to sqlserver 2014 from remote clients

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All,

Im in the process of doing an upgrade to GP2015. Its working fine from the client on the server itself but when I try to connect from a client installed remotely I'm not able to connect to the sqlserver.

I already did the following

-disabled firewall completely for now on both the server and the workstations

-enabled tcp/ip in sql server configuration manager and turned off dynamics ports and set it to port 1433

- verified Allow remote connections to this server is enabled in Server Properties

But still the sql server isn't accepting remote connections.

Help please

Thanks!

*This post is locked for comments

All responses (11)

Answers (2)

Suggested answer

Bill Campbell 22,647 on at

Like (0)

Report

RE: cannot connect to sqlserver 2014 from remote clients

So bottomline is that the ODBC connection that was created during the installation - was not used, you had an existing one and that is the one that was failing.

When you corrected the pointer to the correct SQL Server name and instance you were all correct.

Well done.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: cannot connect to sqlserver 2014 from remote clients
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: cannot connect to sqlserver 2014 from remote clients

You know what actually did it? When I installed the GP2015 client I had it create the DSN for me in ODBC I put in my sqlserver name which is SERVER/SQLEXPRESS but if I go into that one or try to connect with GP it errors out that it cannot connect. But if I modify the SERVER/SQLEXPRESS by just picking the drop-down in the menu in ODBC DSN Admin everything works ok now GP connections and test connection works.
Verified answer

KirkLivermont 5,985 on at

Like (1)

Report

RE: cannot connect to sqlserver 2014 from remote clients

Are you using odbcad32.exe in syswow64 to configure the connection?

Regards,

Kirk
Community Member Microsoft Employee on at

Like (0)

Report

RE: cannot connect to sqlserver 2014 from remote clients

This is the error message I'm getting if I go to ODBC and test the connection
Bill Campbell 22,647 on at

Like (0)

Report

RE: cannot connect to sqlserver 2014 from remote clients

Could you post the exact error message as sometimes the smallest clue is hidden in the exact text of the error.

Hope we can figure this out.
Community Member Microsoft Employee on at

Like (0)

Report

RE: cannot connect to sqlserver 2014 from remote clients

I tried setting up the TCP/IP port to 49170, to port 1433 and port 1434 none of them worked. It is so frustrating that I have followed all the suggestions and none of them are working. I tried IP/sqlexpress IP/sqlexpress,49170 in ODBC too and these combinations did not working either
Community Member Microsoft Employee on at

Like (0)

Report

RE: cannot connect to sqlserver 2014 from remote clients

I tried that as well and also set up sql server again in a virtual machine and did all the same steps to open up remote connections, add exceptions to firewall, enable tcp in configuration and connections tab enable remote connections. Same thing. It's still being blocked somewhere.
Richard Wheeler 75,730 on at

Like (0)

Report

RE: cannot connect to sqlserver 2014 from remote clients

I would try changing your ODBC connections to use the IP address of your SQL server to see if that resolves this issue.
Community Member Microsoft Employee on at

Like (0)

Report

RE: cannot connect to sqlserver 2014 from remote clients

yes via odbc and the version is SQL Server Native Client 11.0 I verified that it is set up the same on the server. These DSNs were created automatically by the GP setup.

The user ID I'm trying to use is sa. I also tried using the TEST CONNECTION within the odbc driver and it just sticks to Attempting connection.... for a while then errors out TEST FAILED.