Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
naren514
Starting Member
5 Posts |
 Posted - 2012-04-18 : 02:38:40
|
| 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
5 Posts |
Posted - 2012-05-01 : 18:24:25
|
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,Sarabquote:
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 |
 |
|
|
naren514
Starting Member
5 Posts |
Posted - 2012-05-03 : 10:44:02
|
| ill try it.Thanks a lot.. |
|
|
|
SQL Basic
Starting Member
8 Posts |
|
|
Aivlis
Starting Member
6 Posts |
Posted - 2014-06-18 : 13:31:27
|
| 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. |
|
|
|
|
|
|
Problem in configuring Witness Server