May 3, 2012 at 4:02 am
Hi
Please can you help? I have two applications, one an internal vb.net system and the other an asp.net web app. We use full mirroring on SQL SErver 2005. Last night our primary failed and the switch to the mirror occurred as expected.
Both the web app and the internal app use the same config file (in the same location on the server) containing the connection string as follows:
uid=UserID;pwd=Password;database=DB1;server=SERVERA; Failover Partner=SERVERB;
The actual connection code is also identical:
The internal system switched seamlessly but the web app gfiles to connect to SERVERB telling me that the server could not be reached or is not accessible. Both servers can ping each other and I can connect to SERVERB via SQL Server Management Studio on SERVERA and the other way round.
Can someone please tell me why my web app can't connect?
Many thanks
May 5, 2012 at 3:53 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply