October 22, 2019 at 11:10 am
Hi,
I am trying to configure the Mirroring in 2008r2. In middle i am getting the error 1418.
tried changing the service account. but it didn't resolved.
Tried configure with commands below in both principal and mirror servers.
alter database abc set partner = 'tcp://node1:5022'
alter database abc set partner = 'tcp://nod2:5022'
for some time the database showing as synchronized and within secs the mirroring will go off. I am not able to understand what mistake i am doing.
I tried tenet the port .. Its working.
Also i changed the SQL Service account to administrator and domain user account.. same issue i am facing.
above all everything i tried in Production 2008r2 servers.
Also i tried setup same in sql2016 test servers. similar issue i am facing. please help to resolve the issue.
Thanks,
October 22, 2019 at 1:58 pm
Have you checked that the endpoints are in a STARTED state?
select * from sys.endpoints
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply