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 2, 2011 3:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:39 AM
Points: 5, Visits: 204
article was good
Post #1057307
Posted Wednesday, February 2, 2011 4:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 2, 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 7, 2011 9:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 4, 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
Posted Sunday, July 28, 2013 12:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 1:36 PM
Points: 1, Visits: 5
This is amazing stuff.Thanks for the post
Post #1478332
Posted Monday, July 29, 2013 7:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:59 AM
Points: 18, Visits: 233
jorge.rodriguez (2/1/2011)
-- 1. Ping and telnet your principal and mirror servers: if you cannot ping or telnet, this can be your problem (add your ips on your host files and see if this fix your issue)
-- 2. Firewall setup: inbound and outbound packets need to be allowed on the ports used by your listening end points
-- 3. Windows negotiate: can you confirm you use windows negotiate for your end points?

This is for starters.


Thanks for the prompt reply,

I can connect through telnet on both servers, my firewall is currently off and windows negotiate is used on both endpoints.

Any other sugestions?


Try recreating the endpoints with encryption disabled.
Post #1478792
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse