I am upgrading my application from using SQL 2000 to SQL 2008. The db server's IP address is 220.127.116.11.
When I installed SQL 2008, because SQL 2000 has the default instance name, I make SQL 2008 instance as 18.104.22.168/SQL2008.
My application on the db server can access 22.214.171.124/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 126.96.36.199/SQL2008 but the connection does not work.
Then I added a new IP address, 188.8.131.52 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 184.108.40.206 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 220.127.116.11 because SQL2000 is answering all the request before SQL 2008.
How can I make SQL 2000 to ignore all request that goes to 18.104.22.168 from my web server?