DwarfWarlard
asked on
ODBC to Hosted SQL Server not connecting
Hi,
I am working on a project for a new client and I cant figure out why he cannot connect to his SQL server. He needs to establish an ODBC data source to his hosted SQL server. The SQL server is connected via VPN.
This is the first time that a user inside this network is trying to establish this connection to this server, so I am trying to run through everything that might hinder an ODBC connection in general.
Windows 7 computer connecting to SQL express 2012
When the user goes to ODBC Data Source Administrator -> System DNS -> Add -> SQL Server, we were unable to locate his SQL server in the server drop down. We turned on the "SQL Server Browser" service on the SQL server by RDPing into it. Once the service started running we were able to see 'SQLServer' in the server drop down.
Currently, we get the attached error when entering Login ID and Password and pressing next.
I have tried changing the connection parameters in Client Configuration to "Named Pipes" and get the same error message. I have also Telnet IP Address 1433 but cannot connect. I have a ticket to the hosted ISP to open that port in the firewall.
I dont really deal to much with ODBC connections so I am really out of my element here. I wanted to reach out to the experts because, given that the SQL Server Browsing Service wasnt even turned on and port 4133 looks closed, I am not sure what other basic things need to happen to establish this connection or if I am even on the right track...
Any pointers or things I need to check would be of huge help to me.
-DwarfWarlard
Error.jpg
I am working on a project for a new client and I cant figure out why he cannot connect to his SQL server. He needs to establish an ODBC data source to his hosted SQL server. The SQL server is connected via VPN.
This is the first time that a user inside this network is trying to establish this connection to this server, so I am trying to run through everything that might hinder an ODBC connection in general.
Windows 7 computer connecting to SQL express 2012
When the user goes to ODBC Data Source Administrator -> System DNS -> Add -> SQL Server, we were unable to locate his SQL server in the server drop down. We turned on the "SQL Server Browser" service on the SQL server by RDPing into it. Once the service started running we were able to see 'SQLServer' in the server drop down.
Currently, we get the attached error when entering Login ID and Password and pressing next.
I have tried changing the connection parameters in Client Configuration to "Named Pipes" and get the same error message. I have also Telnet IP Address 1433 but cannot connect. I have a ticket to the hosted ISP to open that port in the firewall.
I dont really deal to much with ODBC connections so I am really out of my element here. I wanted to reach out to the experts because, given that the SQL Server Browsing Service wasnt even turned on and port 4133 looks closed, I am not sure what other basic things need to happen to establish this connection or if I am even on the right track...
Any pointers or things I need to check would be of huge help to me.
-DwarfWarlard
Error.jpg
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
I was able to work it all out with the host. However, I would have spent waaaay more time on the problem if I wasnt confident on the port.
Thanks again Experts!