asked
Webservice ignoring principal database
We have a SQL2012 mirroring with a witness, all on 3 seperate servers. Auotmatic failover is enabled, connections strings are properly filled. SQL Browser is running. For some reason, one webservice is *sometimes* "ignoring" the principal server and tries to connect to the mirrored database, resulting in a "Failed to open the explicitly specified database". This is always the case when a where webpool is recycled, but also on other different times. On this webserver is the witness also running. The witness is SQL2012Express. Any ideas how to fix this issue?
Possible Duplicate -
http://ask.sqlservercentral.com/questions/33831/database-mirroring-login-failed.html
In order to help people with the same problem, I'd like to ask you to please indicate all helpful answers by clicking on the thumbs up next to those answers. So that others can understand what solved your problem, can you please mark the best answer by clicking on the check box next to it.
I am currently contacting the developer of the application which is causing this problem. Unfortunately, there's some delay, because that company is in a different country. I'll update this post if I have news
Make sure that the mirrors are always listed in the same order in the configurations and check that network connectivity is entirely stable. If the webservice is trying the Mirror then I would say that most likely it's not "seeing" the Principal and tries the fallback entry. Check the Windows logs or with the network team. On a pool recycle it sounds more like a mis-ordered configuration and it's trying the Mirror first.
Hi, first try to find out why the web service fail? the best tool is Fiddler web proxy which catch all service request and response from IIS or any other application server, you can take a look to header and body of service call, Which kind of web service do you use ? How much is the size of the data in web service call back ? Also enable your application server logs, Can you post the error message?
17 People are following this question.
