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.
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.
Problem in configuring Witness Server
Posted - 04/18/2012 : 02:38:40
