Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Configuring Database Mirroring Expand / Collapse
Author
Message
Posted Wednesday, February 02, 2011 3:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 04, 2012 7:18 AM
Points: 5, Visits: 162
article was good
Post #1057307
Posted Wednesday, February 02, 2011 4:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 02, 2011 3:59 PM
Points: 1, Visits: 0

This is a great article. Clear, well written and with good examples. Good teaching is the ability to take the complex and make it seem simple. I would like to see more articles by this author.
Post #1057729
Posted Wednesday, December 07, 2011 9:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 04, 2012 6:41 AM
Points: 1, Visits: 3
could somebody exaplain me where i can do this in SQL SERVER or WINDOWS SERVER?

how i can do it??


The SQL database mirroring account/group has been granted "Access this computer from the network". This will be the account (or group containing the account) under which database mirroring runs, and should be a service account/group. This needs to be done on all participating servers (principal, mirror, and witness).
1.Open up the Local Security Policy on the principal server
2.Expand Security Settings > Local Policies > User Rights Assignment
3.Grant the database mirroring service account "Access this computer from the network" permissions

thanks.
Post #1218028
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse