Database Mirroring on SQL 2005 Cluster

I am in the process of configuring a database mirroring session between a SQL2005 cluster on Windows 2008 and SQL2005 on Windows 2003 (Standalone). Identical versions of SQL are in use.

However, I continually receive the 'server network address can not be found' error when attempting to initiate the mirroring session from the principal.

Mirroring is using certificates and all endpoints are started, permissions are in place, firewall rules look OK, etc.

Any further ideas on how to troubleshoot this?

campbell1972Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel_PLDB Expert/ArchitectCommented:
Hi,
It shouldn't be a problem with setting mirroring on clusters.
Following is an article of setting mirroring using certificates:
Example: Setting Up Database Mirroring Using Certificates (Transact-SQL)

Please ensure that:
- specific ports are opened on both clusters,
- mixed authentication is used,
- remote connections are enabled,
- full database backup is restored on mirror server with no recovery,
- at least one trasaction log has been taken and restored to mirror server with no recovery,
- additionally all logs taken after restored full backup have been copied and restored on mirror server with no recovery,
- when creating certificates and logins use master database

Database Mirroring and Failover Clustering
0
campbell1972Author Commented:
Thanks for that response.

With regard to the ports, is it only necessary to open the mirroring port associated with the SQL instance IP address or is it also necessary to open the port associated with the named instance itself?

So, if you were mirrroring using port 5022 and your named instance was using port 6666, should both ports be opened for firewall purposes to enable mirroring?
0
Daniel_PLDB Expert/ArchitectCommented:
With regard to the ports, is it only necessary to open the mirroring port associated with the SQL instance IP address or is it also necessary to open the port associated with the named instance itself?
You need to open ports for instance(s) participating i nmirroring session(s).


So, if you were mirrroring using port 5022 and your named instance was using port 6666, should both ports be opened for firewall purposes to enable mirroring?
You should open all ports used, e.g. (default) 1433, 5022, 6666.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.