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 different Windows Sever 2008R2 instance located at different places such as db1 and db2. I need to make db2 as mirror server of db1 i.e. all the database on db1 will have a mirror copy on db2.

I tried setting it up using this link: http://www.sqlserver-training.com/how-to-setup-mirroring-in-sql-server-screen-shots/- but could not get through. The error I am getting is that while mirroring, it says that cannot locate the mirror server instance i.e. db2. I tried giving it using the IP address as well.

PS: Both the SQL Server instances are on different machines.

Any suggestions?

share

migration rejected from stackoverflow.com Oct 17 '13 at 17:48

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Max Vernon, RolandoMySQLDBA, Mark Storey-Smith, bluefeet, Michael - sqlbot Oct 17 '13 at 17:48

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
Are the two instances on the same domain? Is name resolution working correctly between the instances? –  mrdenny Jan 4 '12 at 17:51
2  
You've confirmed that you can reach each database on the port (I.E., "telnet db1 1433" from db2 and "telnet db2 1433" from db1) - assuming you're using the default TCP ports? –  Kane Jan 5 '12 at 4:50
    
As, I have mentioned, they both are 2 diff Sql instances located on different servers all together. Such as one at 56.251.56.74 and second one at 74.85.655.85 (samples not the exact one) –  user5543 Jan 6 '12 at 5:26
    
have you tried all these suggestions from SQLAuthority ? –  user5707 Jan 10 '12 at 13:29

2 Answers 2

If you cannot use the domain authentification (servers are not in the same domain), you need to configure outbound connections ( http://msdn.microsoft.com/en-us/library/ms186384.aspx ) and inbound connections ( http://msdn.microsoft.com/en-us/library/ms187671.aspx ) using certificates. I have tried this method, it's really works fine.

share

I would recommend to check the user you are using on both sql server instances (the one you're using to run the service) : it is easier to use the same domain user on both instance.

rgds

share

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