May 30, 2012 at 12:10 am
i am trying to set up database mirroring between 2 servers each are on different domain. spent 3 days read so amny articles tried everything but still getting error....
sql services running under doamin acocunts. both domain accounts are sys admins on both servers.
i can connect to sql server on each server via ssms but when i try to set partner on principal get this error.
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://*** :***" 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.
any idea people...
May 30, 2012 at 12:58 pm
Have you seen this blog post: http://www.sqlservercentral.com/blogs/pearlknows/2009/08/25/database-mirroring-across-domains-using-certificates/
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 2, 2012 at 7:15 pm
If you have a two-way trust between domains, you don't need to use certificates. You have to make sure that each SQL Server service account is a domain account and has been granted CONNECT permissions to each others' mirroring endpoints.
Otherwise, everything you need to check for error 1418 can be found here: http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply