visionetv
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;Passwo rd=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
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;Passwo
I need help in completing the connection over the Internet.
Thank you,
Visionet
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Visionet