I know this topic has been covered pretty heavily, but i've not come accross a solution that is specific enough to our issue. We are moving to SQL 2005 for a web app. We have Firewalls between the IIS 6 Web Server and the Sql Server 2005 (64bit if that makes a difference).
If we try to close down the ports between the servers then the application that talks to the sql server gets the access is denied or Server does not exist error. If i open it up to IP Any it works fine.
TCP any with UDP any doesn't work either. I've tried running ethereal on it but i can't see any port connections besides teh 1433 and 1434.
On the SQL Server both TCP and named pipes are allowed for remote connections. but how can i tell if it's using TCP? And shouldn't that work with TCP 1433 and UDP 1434?
I know we are using a named instance on the server as we have to change the connection string to ip\instance_name but does that mean we are using named pipes?