Hi,

I have setup my mirroring model to 'High safety with automatic failover'.
Accordingly to article:
http://msdn2.microsoft.com/en-us/library/ms366348(SQL.90).aspx
my web application should work without resetting web.config.

My Connection string is:
user id=<webUser>; Network=dbmssocn; Server=<Principal serverName>;persist
security info=True;initial catalog=<mirroredDB>;password=<password>

After a manual failover, when I try to connect to database it says:
"Cannot open database <mirroredDB> requested by the login. The login failed.
Login failed for user 'webUser'"

Any ideas?

Hello Andrew,

I think you shall use SQL native client as provider and use the proper
connection string for clients using database mirroring

http://msdn2.microsoft.com/en-us/library/ms130978.aspx

http://msdn2.microsoft.com/en-us/library/ms130904.aspx

http://msdn2.microsoft.com/en-us/library/ms366348(SQL.90).aspx

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.