July 2, 2008 at 4:16 am
Hi,
I'm testing out mirroring and have stumbled across a problem. I am using SQL Server authentication and currently have my set up as follows:
Principal: SERVER\INSTANCEA
Mirror: SERVER\INSTANCEB
Witness: SERVER\INSTANCEC
I have created a SQL user called User on the principal, and mapped him as dbo to the database i'm mirroring. I then failed over and did the same thing on the mirror. Then failed over back to the principal.
I then changed the application to use the new SQL login and added the "failover partner:SERVER\INSTANCEB" to the connection string.
I then opened the application, then stopped the principal. In management studio I can see that it failed over as expected. However my logins now do not work. Its as though the mapping between my login and my database user has been lost. The application subsequently returns an error as it can no longer access the database.
Does anyone have any advice?
Just a quick addition, when failing over I look at the user on the database and its lost its association with the login name at the server level, so I guess this means the application can connect to the server but it cant access the database any more.
Thanks,
July 2, 2008 at 4:50 am
I actually managed to fix it.
For anyones information this link shows you how to fix it:
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply