I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is left as the primary.
I'm using Microsoft Access through system DSN Native Client with my mirror server referenced in the DSN. The DSN passes the test for the connections. My issue is that if one of the servers goes down, I lose connection to the database. My understanding is that the connection should keep on working seamlessly. Is this correct? If not, any thoughts as to why I am having this issue?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!