August 8, 2011 at 2:52 am
Hello,
On the sql server, sql authentication mode is disabled.
The db are mirrored.
When I tried doing a manual failover to mirror instance using SSMS, it gave me error as: denied permission on database..
The login (windows login) which we use has “sa” rights.. still then we get error
1.Why?
One of my colleague, gave dbo rights to “sa” (sql auth) on that db
And viola.. we were able to do the activities..
2. How can dbo rights be granted to “sa”, which is disabled
Can someone please help..
Thanks
K
August 8, 2011 at 2:54 am
Can you post the full error message?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
August 8, 2011 at 3:17 am
Sadly, I did not save the error when we got it and logs have been recycled.. and since the problem was fixed i cannot repro it:(
August 8, 2011 at 11:18 pm
Can someone please help me to get my doubts cleared..
August 8, 2011 at 11:18 pm
Can someone please help me to get my doubts cleared..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply