Can not Connect SQL Server Through a Firewall

All,
We are trying to connect one of our custom's SQL Server Database outside our firewall. Our Custom opened the Port #1433 for us. We also open the port on our side. However, we stil can not connect. We got "SQL Server Does Not Exist or Access Denied" erro
rs. Can anyone help us? We even could not figure out which side have issues. (Our side or our custom side)....
Lisa
Are you using a default instance or a named instance of SQL Server?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I used IP address and DB Name. Here is the connect string:
Password=xxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=DBNAME;Data Source=123.456.78.90;
Anything wrong? THANKS?
|||Rand,
Forgot to tell that I also added ";Network Library =dbmssocn" in the connections string as well...
|||Test making an ODBC DSN and post the entire error message here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
sql

Can not Connect SQL Server Through a Firewall

All,
We are trying to connect one of our custom's SQL Server Database outside our
firewall. Our Custom opened the Port #1433 for us. We also open the port o
n our side. However, we stil can not connect. We got "SQL Server Does Not E
xist or Access Denied" erro
rs. Can anyone help us? We even could not figure out which side have issues.
(Our side or our custom side)....
LisaAre you using a default instance or a named instance of SQL Server?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I used IP address and DB Name. Here is the connect string:
Password=xxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=DBNAME;
Data Source=123.456.78.90;
Anything wrong? THANKS?|||Rand,
Forgot to tell that I also added ";Network Library =dbmssocn" in the connect
ions string as well...|||Test making an ODBC DSN and post the entire error message here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.