Solved

SQL 2008 mirror configuration

Posted on 2013-12-09
9
304 Views
Last Modified: 2014-01-02
Hi
        is there any document for how to config SQL 2008 mirror, The more detailed, the better. thank you
0
Comment
Question by:beardog1113
[X]
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
9 Comments
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
ID: 39708701
0
 

Author Comment

by:beardog1113
ID: 39710485
thank you ,i will test it and let you know if it is working
0
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

by:beardog1113
ID: 39720630
thank you, i will try it ASAP
0
 

Author Comment

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

Author Comment

by:beardog1113
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?
Mirror-Error.jpg
0
 

Author Comment

by:beardog1113
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://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
 
LVL 10

Expert Comment

by:PadawanDBA
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: http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418.  It's a pretty exhaustive list of troubleshooting your initial error.
0
 

Author Comment

by:beardog1113
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
0

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