I am in the process of building a new server for our (SQL 2000, as a 2005 upgrade is planned for later this year) database system. I have tested the software client on the server and several other PCs and all works OK. This confirms that SQL is installed and configured OK, it can access the data files and client PCs are able to access the database.
The final hurdle in the build is to get our websites to connect to the new database instead of the existing database.
Im testing it on one website first, but the site is failing to load. The site is written in C#/ASP.NET and I have made the following configuration changes in web.config:
- Loaded up web.config
- Replace (oldservername) with (newservername)
In theory, this should connect but it does not work. Connectivity-wise, from the web server I can:
- Ping new database server
- Access new server shares
- Access new SQL database through client software
I have checked various settings in SQL and they match what is set up on the old server:
- TCP/IP Port: 1433. This has been allowed on Windows Firewall on new server, and network gateway
- Instance Name: MSSQLSERVER (Default instance Name)
- Named Pipes enabled
- Username/password created in order for website to access database.
Also, Im not sure if this is an affecting issue but I can connect to the old server using telnet oldservername 1433, but when I try telnet newservername 1433 I get the following error:
Could not open connection to the host, on port 1433: connection failed.
What areas can I check to try and troubleshoot the connection? Something seems to be blocking the connection. The Windows Firewall is switched off on the new server for now until I can get this issue resolved.
Please could you have a look at this issue and provide me with some feedback/advice. I have asked a similar question previously but I did not explain it in detail and may have been unclear with my request. I need to get the connection up and running ready for Friday evening which is my only window this month to copy the live database to the new server.
Thanks in advance, any comments are appreciated.