Solved

SQL 2008 mirror configuration

Posted on 2013-12-09
9
298 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
  • 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
 
LVL 3

Expert Comment

by:Sagir87
ID: 39713818
0
 

Author Comment

by:beardog1113
ID: 39720630
thank you, i will try it ASAP
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now