WebServer cannot access SQL 2008 server
Posted on 2011-09-02
I am upgrading my application from using SQL 2000 to SQL 2008. The db server's IP address is 22.214.171.124.
When I installed SQL 2008, because SQL 2000 has the default instance name, I make SQL 2008 instance as 126.96.36.199/SQL2008.
My application on the db server can access 188.8.131.52/SQL2008 perfectly.
However, my asp.net web server in DMZ that cannot access the new SQL 2008 databae.
I configure the web.confg to put the server name as 184.108.40.206/SQL2008 but the connection does not work.
Then I added a new IP address, 220.127.116.11 on my db server and configured as a new SQL 2008's IP address in server configuration tool.
I could use ODBC to connect to 18.104.22.168 from my web server and establish an ODBC connection successfully. Thus, I know the firewall is not blocking the ports.
However, I still cannot confgiure my web.config to connect to the 2008 database by using 22.214.171.124 because SQL2000 is answering all the request before SQL 2008.
How can I make SQL 2000 to ignore all request that goes to 126.96.36.199 from my web server?