asp.net application connect to SQL through a firewall

[theresatan]

Hi guys.

We have an external webserver(server1 on domain1) is a DMZ, and sql server7(server2 on domain2) inside the firewall.

Domain1 trusts domain2 but domain2 does not trust domain1.

Our firewall hosting by outside vendor and they told me they already opened up the port 1433 for server2.

I put a small asp.net application on server1(this application works fine in intranet. 2000 server,iis5,virtue directory, and .net frameword were well installed and configured), and I got SQL server does not exist or login fail error'.

Any idea about that? And how to test the port was opened?

Any input appreciated.....

 

[jfrost10]

Hey man,

What account is your asp.net user logging into SQL server as?

jack

 

[theresatan]

I use sa login