Viewing 5 posts - 1 through 5 (of 5 total)
The login needs to be a member of the securityadmin server role.
September 6, 2013 at 7:27 am
Try sys.database_mirroring. This table contains a column called mirroring_witness_name.
November 22, 2010 at 6:53 am
I can address the login but not the jobs. Look for this article. 'Login failures connecting to new principal after failover using Database Mirroring'. It was published...
April 2, 2008 at 10:29 am
Grant execute on sp_sdidebug to your user. One of the service packs changed permissions on this stored procedure.
May 1, 2007 at 6:27 am
Have you tried scptxfr.exe? Take a look at the following link.
February 1, 2007 at 7:53 am
Viewing 5 posts - 1 through 5 (of 5 total)