1

I'm setting up a Mirroring study session in separated servers.

Everything looks ok, the firewall in my machine is disabled and in the another server it has an inbound\outbound rule to accept port 5022.

I could check that both endpoints are created and STARTED in both servers with SELECT * FROM sys.database_mirroring_endpoints.

enter image description here

I tried with both configurations, by using services account, and leaving them blank.

I checked with port query that the server is listening on this ports:

enter image description here

What more can I check?

enter image description here

The reason I'm asking this question is because I read every other question about mirroring here, but none of them could help me.


In a post, I read that someone fixed the error with:

Go to services.msc and check the sql server is running under which account. Make sure that sql server and sql server agent services should run with same credentials.

But I use different credentials for AGENT and SQL SERVER.

Is this a problem? I've never seen this before.


EDIT2:

I could fix this error ( it still shows me this error, but if I run the mirror again, it shows me error 1431.)

Using ALTER DATABASE [Database_Name] SET PARTNER OFF didn't solve the problem. it just restart the task, and errors and errors again.

8
  • Are they both the same edition of SQL? Mar 28 '17 at 14:08
  • Yes, both SQL Server 2014.
    – Racer SQL
    Mar 28 '17 at 14:14
  • That's version. What edition(s)? Such as Developer, Enterprise, or Standard. Mar 28 '17 at 14:15
  • Oh Sorry, both enterprise edition.
    – Racer SQL
    Mar 28 '17 at 14:16
  • Are both instances of sql server running under the same service account? If not you'll need to use a certificate and proxy accounts. Mar 28 '17 at 14:35
1

Have you granted the CONNECT permission to the Mirroring Endpoint for the SQL Server service account?

GRANT CONNECT on ENDPOINT::Mirroring_Endpoint TO [domain\user];

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.