Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB18517 - BAS connects to a default SQL instance despite a named instance ...
 
  #1 (permalink)  
Old 09-12-2009, 12:27 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB18517 - BAS connects to a default SQL instance despite a named instance ...

KB18517 - BlackBerry Administration Service connects to a default SQL instance despite a named instance being specified


Environment

  • BlackBerry® Enterprise Server version 5.0
  • Microsoft® SQL Server® versions 2000 and 2005
  • SDR347730



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
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

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 On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
BES 5.0.1 Changing Host Instance Name askinsfan Port 3101: The BES Admin Bar & Grill 2 03-25-2010 10:20 AM
Trying to run my SQL mirror on a named instance and different port....anyone? jfkaiser Port 3101: The BES Admin Bar & Grill 2 01-11-2010 08:34 AM
Max number of BES users per Instance Zippygit Port 3101: The BES Admin Bar & Grill 6 08-14-2009 08:28 PM
KB11232 - Cannot install a named MSDE instance for BES 4.1 hdawg Featured BlackBerry KB Articles 0 04-01-2009 02:43 PM
KB11232 - Cannot install a named MSDE instance for BlackBerry Enterprise Server 4.1 hdawg Featured BlackBerry KB Articles 0 01-10-2009 01:57 PM


All times are GMT -4. The time now is 10:39 PM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2