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: 134
Post Thanks: 0
Thanked 9 Times in 9 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,524
Post Thanks: 214
Thanked 341 Times in 307 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 08: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

VINTAGE BERNOULLI 150 MULTIDISK MAC TRANSPORTABLE DISK DRIVE
$30.0
VINTAGE BERNOULLI 150 MULTIDISK MAC TRANSPORTABLE  DISK DRIVE  picture15/16” Chrome socket x ½” Dr 12 pt vintage look a few scuffs MAC TOOLS v302
$16.0
15/16” Chrome socket  x ½” Dr 12 pt vintage look a few scuffs  MAC TOOLS v302  pictureVintage Mac Allied Tools Corp Ohio Hex Rethreader Dies for Coarse Threads 4 Sets
$57.99
Vintage Mac Allied Tools Corp Ohio Hex Rethreader Dies for Coarse Threads 4 Sets pictureMAC P-26-A ADJUSTABLE Double Jointed PLIERS Use Nice Condition Vintage
$12.5
MAC P-26-A ADJUSTABLE Double Jointed PLIERS Use Nice Condition Vintage pictureVintage Lot of Tap and Dies MAC, Vermont, ACE & more
$9.99
Vintage Lot of Tap and Dies MAC, Vermont, ACE & more picture






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