SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Problem in configuring Witness Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

naren514
Starting Member

India
5 Posts

Posted - 04/18/2012 :  02:38:40  Show Profile  Reply with Quote
Hi..
I am using SQL Server 2008 R2 for mirroring databases on two different servers.
The mirroring with two servers without witness server is successful.but, when i am trying to configure the witness server it is failing and giving error as follows.
The alter databse command couldnot be sent to remote server instance tcp://<witness-instance>:<port>.
The database mirroring configuration is not changed.verify that server is connected, and try again.(Microsoft SQL Server Error:1456)
.

and please tell me the requirements for configuring Witness and also confirm me that is it necessary to have that particular mirrored database on Witness Instance also.

Please reply.

sarabpreet12
Starting Member

India
5 Posts

Posted - 05/01/2012 :  18:24:25  Show Profile  Reply with Quote
No, You dont need the DB on Witness server, It is there just to keep an eye on two servers. To know more read MSDN\Technet.

To solve this issue:
1. Ping both the servers & check the port via TelNet.
2. If you are trying to mention Server Name in the wizard\script try replacing the same with server IP of Witness Server. or ENable Named Pipes.
3. Use SSMS to connect to Witness server and check if both the nodes can communicate.

This seems to be aconnectivity issue rather than DB MIrroring issue.

Thanks,
Sarab




quote:
Originally posted by naren514

Hi..
I am using SQL Server 2008 R2 for mirroring databases on two different servers.
The mirroring with two servers without witness server is successful.but, when i am trying to configure the witness server it is failing and giving error as follows.
The alter databse command couldnot be sent to remote server instance tcp://<witness-instance>:<port>.
The database mirroring configuration is not changed.verify that server is connected, and try again.(Microsoft SQL Server Error:1456)
.

and please tell me the requirements for configuring Witness and also confirm me that is it necessary to have that particular mirrored database on Witness Instance also.

Please reply.



Sarabpreet Singh Anand
Go to Top of Page

naren514
Starting Member

India
5 Posts

Posted - 05/03/2012 :  10:44:02  Show Profile  Reply with Quote
ill try it.
Thanks a lot..
Go to Top of Page

SQL Basic
Starting Member

Canada
8 Posts

Posted - 05/31/2012 :  06:09:19  Show Profile  Reply with Quote
To solve your problem, please refer the link below:

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/1af1b023-10d6-48dc-bf62-a3fecdf95074

Hope will help you.
Go to Top of Page

Aivlis
Starting Member

5 Posts

Posted - 06/18/2014 :  13:31:27  Show Profile  Reply with Quote
Hey guys. I'm with same problem and can't found a solution. I have two SQL 2012 Standard and one SQL 2012 Express, the last is witness.
I'd tried everything, but it still doesn't work. Can anyone help me?

Be brave.

Edited by - Aivlis on 06/18/2014 14:06:34
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000