[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

SQL 2008 mirror configuration

Hi
        is there any document for how to config SQL 2008 mirror, The more detailed, the better. thank you
0
beardog1113
Asked:
beardog1113
  • 6
  • 2
1 Solution
 
PadawanDBAOperational DBACommented:
0
 
beardog1113Author Commented:
thank you ,i will test it and let you know if it is working
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
beardog1113Author Commented:
thank you, i will try it ASAP
0
 
beardog1113Author Commented:
if i want to configure a witness server for my mirror, how can i do it?
0
 
beardog1113Author Commented:
I got the error when i try to start mirror, i use sa to connect Principal server and mirror server, at the services account page, i fill SA for 2 server account.  any advice?
Mirror-Error.jpg
0
 
beardog1113Author Commented:
i also get the error event 1474 "Database mirroring connection error 5 'Connection handshake failed. The login 'CNSHSQL1\Administrator' does not have CONNECT permission on the endpoint. State 84.' for 'TCP://CNSHSQL2.ipsosgroup.ipsos.com:5022'." i did not ues administrator to connect endpoint, i login windows use domain admin and login SQL use windows authentication, how can i set the account to use to connct endpoint
0
 
PadawanDBAOperational DBACommented:
What account is the db engine service running under?  It's going to try to connect to the endpoint under that context (my guess is that it's not running as a domain account).

Please review this: http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418.  It's a pretty exhaustive list of troubleshooting your initial error.
0
 
beardog1113Author Commented:
it is woking after i change the account for dbengine services, thank you. i will open other quesiton for how to setup configure a witness server and remove mirror, thank you again
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now