troubleshooting Question

SQL Mirror/web.config issue

Avatar of Ed
EdFlag for United Kingdom of Great Britain and Northern Ireland asked on
.NET ProgrammingASP.NETMicrosoft SQL Server 2005
2 Comments1 Solution424 ViewsLast Modified:
I've mirrored SQL servers which works fine.

The problem I have is that in my web application, it poimts to the IP address of the principal SQL server in my web.config file

add name="LocalSqlServer" connectionString="Data Source=;Initial Catalog=WebData;Persist Security Info=True;User ID=WebServerConnection;Password=*********"/>

When the principal server goes down and the mirror takes over and the the SQL database cannot be reached by the webserver as the IP address on the SQL server has changed.

How can i get my web.,config file to look at both the principal nand mirror servers to stop SQL connection errors whe the main principal server goes down as the IP address is hardcoded into the web.config file.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

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