SQL 2008 mirror configuration

Posted on 2013-12-09
Last Modified: 2014-01-02
        is there any document for how to config SQL 2008 mirror, The more detailed, the better. thank you
Question by:beardog1113
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 2
LVL 10

Accepted Solution

PadawanDBA earned 500 total points
ID: 39708701

Author Comment

ID: 39710485
thank you ,i will test it and let you know if it is working
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!


Author Comment

ID: 39720630
thank you, i will try it ASAP

Author Comment

ID: 39750828
if i want to configure a witness server for my mirror, how can i do it?

Author Comment

ID: 39750860
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?

Author Comment

ID: 39750915
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://'." 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
LVL 10

Expert Comment

ID: 39751423
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:  It's a pretty exhaustive list of troubleshooting your initial error.

Author Comment

ID: 39752958
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

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

689 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question