Tell me more ×
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.
up vote 1 down vote favorite

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|improve this 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

migrated from stackoverflow.com Jan 4 '12 at 17:17

2 Answers

up vote 1 down vote

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|improve this answer
up vote 0 down vote

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|improve this answer

Your Answer

 
discard

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