troubleshooting Question

New SQL server

Avatar of IKtech
IKtech asked on
Microsoft SQL ServerMicrosoft IIS Web Server
2 Comments1 Solution124 ViewsLast Modified:
We have an application that runs on IIS 7.5 and windows server 2008 R2.  The backend is a sql server 2008R2 on a separate windows server 2008.

I want to retire the old sql server and I have built a new sql server.  We would like to reuse the name and IP address of the old server for the new sql server and I am sure I can do that however.  I wanted to do some testing and I was curious if I could simply change the host file on the application server as follows

old sql server name = new sql server ip address

I thought that might allow use to test our application with the new sql server and also give me an easy reversible change.

Any thoughts?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
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 2 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