rcamarda
unread,Jun 24, 2009, 10:49:55 AM6/24/09You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
I have successfully configured mirroring in SQL 2008. I use a witness
server and it is running in sync mode. I can fail over the databases
and everything works great; except one thing.
I have a SQL user called dmbuilder. When I created the database via
SMSS I edit the properties of the database, choose files and change
the owner from my AD login to dmbuilder.
When the database fails over, I can not connect to the database. I
checked on the mirror (now primary) database, the owner is blank, so I
have to change it to dmbuilder and now I can use the database. When I
fail back, same thing, the owner is missing.
Someone suggested it has something to do with the endpoint
configuration of mirroring, but I can not find anything.
Any ideas?
TIA
Rob