August 11, 2010 at 5:56 am
I have 2 machines running SQLServer 2008 SP1, having a mirrored database “RuleEngine” on it.
Both server machines have 2 NICs
Machine BFRAVICSVR31276, principal, ip=10.6.7.37/24, ip=10.6.133.132/23
Machine BFRAVICSVR31260, mirror, ip=10.6.7.36/24, ip=10.6.132.132/23
In our DNS BFRAVICSVR31276 resolves to 10.6.7.37 and BFRAVICSVR31260 resolves to 10.6.7.36
On principal:
SELECT [mirroring_partner_name],[mirroring_partner_instance]
FROM [msdb].[sys].[database_mirroring]
mirroring_partner_name mirroring_partner_instance
--------------------------- ------------------------------
TCP://10.6.132.132:7025 BFRAVICSVR31260\SQLINST2
My Problem:
On a ODBC client having the SQL Native Client installed, I am able to connect to 10.6.133.132 (principal) but not to 10.6.132.132 (mirror)
This because it want to use “BFRAVICSVR31260” (equals 10.6.7.36) which is provided by the principal server.
See attached sreenshots....
In the screenshots underneath I’m using a SQL 2005 native client, I tried the same using a SQL 2008R2 native client, which reacts exactly the same.
Is there a way to fix this ??
Maybe by altering the mirroring_partner_instance in sys.database_mirroring ?? Howto ?
Paul
August 11, 2010 at 9:38 am
First i would change the default database in your configuration to master and then try your connection again. Maybe im wrong but i think you try to connnect to your mirrored Db witch is not online in this state
August 11, 2010 at 9:59 am
I'd agree with what's listed above. The mirror database is not accessible while mirroring is running.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply