troubleshooting Question

Cannot connect new-build Win 2003 server to web server

Avatar of Rob Samuel
Rob SamuelFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerWeb DevelopmentWindows Server 2003
6 Comments1 Solution246 ViewsLast Modified:
Hi,

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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros