cannot connect to sqlserver 2014 from remote clients

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (11)

Answers (2)

Bill Campbell 12 on at

Like (0)

Report

I am guessing but are you attaching to the SQL via ODBC? If so, what version of ODBC and what version of SQL Server.

What user ID are you using to connect to SQL from the ODBC connection?

Just more questions.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

I would try changing your ODBC connections to use the IP address of your SQL server to see if that resolves this issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is the error message I'm getting if I go to ODBC and test the connection

Was this reply helpful? Yes No
Verified answer

KirkLivermont 5,985 on at

Like (1)

Report

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

Regards,

Kirk

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Was this reply helpful? Yes No