MS Sql Server connectivity slow using internal IP
Posted on 2011-02-23
I have this odd problem. I have a server (Win 2003/ MS Sql Server 2005) that when I attempt to connect via SSMS using an INTERNAL IP address it's VERY slow and, in somecase, could timeout during it's attempts to connect. However, if I use this server's EXTERNAL IP address it's very fast. This also happens when using Visual Studio to connect to this server's DB.
I'm assuming there must be some sort of configuration setting or something to fix this but I have no idea what to look for. What would make the connection to my database using the Internal address slow and yet, the External address is really fast?