SQLTeam.com | Weblogs | Forums

Sql server mirroring error 1418

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,

What do you see in the error log?