1

I have two SQL Server 2008 R2 instances installed on same Server and the engine log on as Network Service account which is set by installation.

there is a database TestDB on both instances. I try to setup database mirror for this case and I failed with following error:

The server network address "TCP://myserver.mycompany.com:5023" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

Then I changed the account to Local System for engine and restarted sql server service and I am able to setup mirror.

How to resolve this problem if I want to keep Network Service to run the engine service?

2
  • What does, sys.database_mirroring_endpoints joined with sys.tcp_endpoints on the principle and mirror say? Dec 12, 2013 at 13:44
  • I'm voting to close this as "unclear" since you have not provided any reason for using the Network Service account, and as explained in the answer below, that has its limitations.
    – Hannah Vernon
    Mar 15, 2018 at 18:53

1 Answer 1

1

Use a local system account, or create a local or domain account.

The NetworkService account has its limitations as that documentation explains.

0

Your Answer

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

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