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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy