MsSQL Server outside a Firewall. What ports? How to setup?
Posted on 2001-07-10
I'm having problems and I don't want someone to tell me to follow the steps on Microsoft's Support info from:
I've tried them.
I have a SQL server outside the firewall, it's using it's default 1433 port. There's a port open on the firewall in/out for 1433 and listening on 1024 to 65535.
I use the Connection String in my ASP Page like the example. "Provider=SQLOLEDB;Password=password;Persist Security Info=True;User ID=username;Initial Catalog=DBNAME;Data Source=servername;Network Library=dbmssocn"
I'm using the IP Address for the Servername.
When ever I try Conn.Open line in my ASP I get 'Connection Not Open' error. So I can't figure out if it's something I have to do on the SQL or what other ports I need to open up on the firewall.
Any ideas how I can get this working?