Connecting Over Internal IP To Sql2005 Box

Hi,

I have 2 boxes, 1 webserver and 1 db server, both behind a firewall. For the past few years I have been connecting from the webserver to the db server using a public IP. I have 2 NIC's in the DB server so I now want to connect locally to reduce our companies bandwidth charges, and hopefully make things a tiny bit faster too. I'm not sure if it will make a difference, but should be interesting.

I'm having problems setting this up tho, what steps do I need to take to make sure it works properly?

When I check my DB servers IP configuration I get 2 NICs'

One configured as an external IP, the other configued as
169.xxx.xx.xxx

I am trying to connect using the 169.xxx.xx.xx Is this the correct approach? I am getting TimeOut Errors as seen below

I looked in my SQL configuration and its set to allow remote connections however, and since I was connecting over a public IP before, this seems contridicting.

Any help is much appreciated.

Thanks once again!!! :)
mike123


System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)