Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 change the account to Local System for engine and restart 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?

share|improve this question
    
What does, sys.database_mirroring_endpoints joined with sys.tcp_endpoints on the principle and mirror say? –  RateControl Dec 12 '13 at 13:44
add comment

1 Answer

Why doný you want to use a local system account or why not create a local or domain account. The network service account has it's limitations http://msdn.microsoft.com/en-us/library/windows/desktop/ms684272%28v=vs.85%29.aspx

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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