BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 04-05-2013, 10:50 PM   #1 (permalink)
New Member
 
Join Date: Feb 2011
Model: 8900
PIN: N/A
Carrier: ATT
Posts: 6
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default why can't use SQL named instance for DB mirroring

Please Login to Remove!

has anyone tried to use named instance? I have read some KB articles and they all stated not to use named instanced. I spoke with a support engineer. He said that MS SQL doesn't support database mirroring with named instance. But I checked MS KB and it says it can do DB mirroring with named instance. I need to put BES config DB to a shared SQL server. The DBA won't let us to use default instance.

Please advice.

Thanks in advance

David
Offline  
Old 04-05-2013, 11:31 PM   #2 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2013
Model: 9700
PIN: N/A
Carrier: AT&T-US
Posts: 104
Post Thanks: 0
Thanked 7 Times in 7 Posts
Default Re: why can't use SQL named instance for DB mirroring

When database mirroring is configured in a high availability environment using a named instance and a port number other than 1433, the BlackBerry Administration Service and remote components do not failover properly.There is a bug with the JDBC driver that is currently bundled with the BlackBerry Enterprise Server installer. I think that's why support engineer said to SQL doesn't support database mirroring with named instance
Offline  
Old 04-06-2013, 12:12 PM   #3 (permalink)
Spam Reporter
 
dc/dc's Avatar
 
Join Date: Oct 2005
Location: IAD
Model: 6230
Carrier: Voicestream
Posts: 14,530
Post Thanks: 220
Thanked 345 Times in 311 Posts
Default Re: why can't use SQL named instance for DB mirroring

This needs to be in the BES admin corner.
__________________
I h8 txtspk.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads for: why can't use SQL named instance for DB mirroring
Thread Thread Starter Forum Replies Last Post
SQL DB Migration OmahaAdam BES Admin Corner 3 03-15-2012 11:51 AM
Knowledge Sharing - BAS 5.0 Static Vs Dynamic SQL ports (DynamicSQLPort key) noname BES Admin Corner 0 01-23-2010 07:23 PM
BES upgrade to 4.1.6 Horsebox BES Admin Corner 3 08-05-2008 06:27 PM
Perform a cutover to another BlackBerry Enterprise Server in IBM Lotus Domino hdawg BES Admin Corner 3 04-25-2008 09:47 AM
DB Upgrade Failed. Error Executing SQL statement SimonMac BES Admin Corner 18 09-27-2007 08:03 AM





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.