September 15, 2016 at 11:33 pm
Hi All,
I have an issue when I set up witness server to monitor principal and mirror server .
Mirroring session is successfully created between principal and mirror. Only witness server is the issue
The error that I get is as below :
“ The Alter database command could not be sent to the remote server instance ‘TCP://xxxxxxx:5022’. The database mirroring configuration was not changed . Verify that the server is connected and try again”
The situation is :
I can connect to witness server from principal server via SQL Management Studio BUT I can’t ping witness server from there
Is there anything that I can do to fix this?
Thank you
Cheers…
September 17, 2016 at 6:30 am
check the sql errorlog and eventvwr logs on the witness. You can get this error if the sql service account has not been granted connect permission on the mirroring endpoint.
Also check all necessary ports are open on any firewalls.
---------------------------------------------------------------------
October 11, 2016 at 10:04 pm
Thanks for the feedback
It has been sorted out , the cause is the service account in witness should be the same with the one that I use in principal and mirror server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply