question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

mirror setup issue

I am currently stucked in a database mirror installation and I don't know what's causing the problem. Both servers have the same OS, same MSSQL version (same patchlevel) MSSQL 2k8r2 First I tried a mirroring based on windows accounts. Everything works fine until I define the partner on the principal. For some reason, I cannot connect to the mirror. Defining the partner on the mirror works fine. The endpoints are working, ports are open. So i did another try, now using certificates, as described here: [ http://msdn.microsoft.com/en-us/library/ms191140.aspx][1] This also fails when defining the partner on the principal. Any ideas? [1]: http://msdn.microsoft.com/en-us/library/ms191140.aspx
mirroringcertificates
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
any particular error message?
1 Like 1 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
Can you confirm that this is on two different (hardware) servers - the line 'the servers have the same OS' could mean two things...! Are you using the SSMS wizard or TSQL?
0 Likes 0 ·
Wilfred van Dijk avatar image Wilfred van Dijk commented ·
using T-SQL for certificate, wizard for windows account
0 Likes 0 ·

1 Answer

·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
This is fixed, it was a firewall issue
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.