• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1044
  • Last Modified:

SQL server 2008 R2 mirroring

I just Installed a fresh OS and sql 2008 R2 on two boxes and uninstalled sql 2005 reinstalling sql 2008 R2 on a third.  The two fresh installs are my principal and mirror instances and the third box i had planned on using as a witness.  Every time i try to add the witness i get a message:

The ALTER DATABASE command could not be sent to the remote server instance 'TCP://server.domain:5022'.  The databas mirroring configuration was not changed.  Verify the the server is connected and try again. (microsoft sql server, error 1456)

The mirroring is actually working with out the witness but i would like to try and use a witness if possible.  After some research i have found some info about the issue but so far nothing seems to help.
0
IKtech
Asked:
IKtech
  • 2
1 Solution
 
sventhanCommented:
try this

http://www.mssqltips.com/tip.asp?tip=1705

I've used this to set up a mirroring and it worked pretty good.
0
 
IKtechAuthor Commented:
I've got the databases mirrored already i just wanted to add a witness.  Do I need to create these certs just to use a witness server?
0
 
IKtechAuthor Commented:
I got to step three in the instructions and decided to remove the changes i had made.  After i removed the cert i created and the key i tried the mirroring again and it worked.  Don't know exactly what fixed it however it is working.  Thanks.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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