BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 01-23-2010, 08:23 PM   #1
noname
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Arrow Knowledge Sharing - BAS 5.0 Static Vs Dynamic SQL ports (DynamicSQLPort key)

Please Login to Remove!

Sharing out as this has been a common issue to many of my clients.

Article Title: BlackBerry Administration Service connects to a default SQL instance despite a named instance being specified
Article Number: KB18517
Link: View Document


Overview

On a Microsoft SQL Server which has both a default instance and at least one named instance, the default instance will use static ports and the named instances will use dynamic ports. If a BlackBerry® Administration Service instance is configured to point to a named instance but static ports are selected the BlackBerry Administration Service instance will connect to the default Microsoft SQL Server instance instead of the expected named instance.


Cause

The BlackBerry Administration Service will connect to a Microsoft SQL Server instance, regardless of the instance name, if it is configured for static ports and can connect to that port.


Resolution

Follow the Resolution section of KB18176 to verify the port settings on the Microsoft SQL Server and then make the necessary changes as follows.

Warning: The following procedure involves modifying the computer registry. This can cause substantial damage to the Windows® operating system. Document and back up the registry entries prior to implementing any changes.

All of the following registry values are located in the following path:

HKEY_LOCAL_MACHINE\SOFTWARE\Research In Motion\BlackBerry Enterprise Server\Database

If the Microsoft SQL Server is configured with a default instance the following registry values should be checked and updated as needed:
  • DatabaseServerMachineName = Machine name of the SQL Server host
  • DynamicSQLPort = 0
  • Port = This should match the port settings on the SQL Server for this instance (by default 1433 is used)
If the Microsoft SQL Server is configured with a named instance using static ports the following registry values should be checked and updated as needed:
  • DatabaseServerMachineName = Machine name of the SQL Server host followed by the instance name(ie. host\instance)
  • DynamicSQLPort = 0
  • Port = This should match the port settings on the SQL Server for this instance (by default 1433 is used)
If the Microsoft SQL Server is configured with a named instance using dynamic ports the following registry values should be checked and updated as needed:
  • DatabaseServerMachineName = Machine name of the SQL Server host followed by the instance name(ie. host\instance)
  • DynamicSQLPort = 1
  • Port = Delete or rename this registry value
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


Agilent E8403A VXI Mainframe + E8491B, E4808A, 7x E8461B Modules with WARRANTY picture

Agilent E8403A VXI Mainframe + E8491B, E4808A, 7x E8461B Modules with WARRANTY

$3900.00



TEKTRONIX TM5006A 6 BAY MAINFRAME.  (chassis Mainframe only) picture

TEKTRONIX TM5006A 6 BAY MAINFRAME. (chassis Mainframe only)

$200.00



HP 3488A HPIB Switch / Control Unit Mainframe picture

HP 3488A HPIB Switch / Control Unit Mainframe

$24.99



Tektronix TM5003 Power Module Mainframe Chassis picture

Tektronix TM5003 Power Module Mainframe Chassis

$225.00



Computer Conversions Corp. Main Frame Board RTSS-4 picture

Computer Conversions Corp. Main Frame Board RTSS-4

$375.00



Chroma 6312A DC Electronic Load Mainframe with 63102A 2A/20A 16V/80V 1 picture

Chroma 6312A DC Electronic Load Mainframe with 63102A 2A/20A 16V/80V 1

$700.00







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