I have a web server (IIS7/.NET 3.5 native client) connecting to SQL 2005 through a firewall.
The server is on a cluster with a named instance configured to respond to the static port 1089.
TCP ports 1433 and 1089 are open on the firewall, UDP port 1434 is open as well.
Once the connection is estabilished, the setup is really fast (~10ms per query), however setting up the first connection takes 37 seconds!
The connection string being used is the following:
Data Source=126.96.36.199,1098;Network Library=DBMSSOCN;Initial Catalog=MyDatabase;user id=my_user_id;password=secret_stuff
The web server and the sql server are on different domains. However, I am using SQL Authentication.
If I connect from a normal client machine everything works like a charm.
Has anybody encountered this problem before? How could I solve it or at least investigate the issue further?