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.

Improve this question
8
  • Are they both the same edition of SQL?
    – John Eisbrener
    Commented Mar 28, 2017 at 14:08
  • Yes, both SQL Server 2014.
    – Racer SQL
    Commented Mar 28, 2017 at 14:14
  • That's version. What edition(s)? Such as Developer, Enterprise, or Standard.
    – John Eisbrener
    Commented Mar 28, 2017 at 14:15
  • Oh Sorry, both enterprise edition.
    – Racer SQL
    Commented Mar 28, 2017 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.
    – Michael Capobianco
    Commented Mar 28, 2017 at 14:35

1 Answer 1

Reset to default
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];

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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