Link to home
Start Free TrialLog in
Avatar of visionetv
visionetvFlag for United States of America

asked on

Connect to SQL 2008 r2 server over the Internet

Hello Experts;

I am attempting to connect to a 2008 r2 SQL server over the internet. The server provides database connectivity for a LAN without issue. Attempts to connect through the public facing IP using ports 1433 and 1434 forwarded to the SQL server's IP address fail. The end use is to connect a Delphi application to a database on the remote SQL server. I cannot connect using SQL Server Management Studio either using http://17*.***.***.***,1433Ā as the 'Server name'

The connection string I am trying to use for the Delphi application is as follows;

Provider=SQLOLEDB.1;Password=Si*****;Persist Security Info=True;User ID=sa;Initial Catalog=SRSPRM2;Data Source=http://17*.***.***.***,1433;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=********;Use Encryption for Data=False;Tag with column collation when possible=False

I need help in completing the connection over the Internet.

Thank you,
Visionet
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of visionetv

ASKER

Thank you for your comments and I am aware of the security issues. The connection efforts were tests looking for a possible VPN alternative with the ports being disabled after the test connection attempts. Sqlncli is installed and dropping the http prefix did not resolve the issue though the connection string link is helpful. A Delphi only solution also is a possibility which I will look at.

Visionet
As noted it is difficult to determine why your connection fails. If you have SSMS/E installed, are you able to use it to connect?
If your sql native client is for SQL 2005 that might explain a possible cause for failure. You can download and install SQLNI10
https://www.microsoft.com/en-us/download/details.aspx?id=44272