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



Reply
LinkBack (3) Thread Tools Display Modes
KB12247 - Move from an MSDE database to a Microsoft SQL Server database
 
  3 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 04-16-2009, 10:39 AM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB12247 - Move from an MSDE database to a Microsoft SQL Server database

KB12247 - Move from an MSDE database to a Microsoft SQL Server database


Environment

  • BlackBerry® Enterprise Server version 4.0 to 4.1 for IBM® Lotus® Domino®
  • BlackBerry® Enterprise Server version 3.6 to 4.1 for Microsoft® Exchange
  • BlackBerry® Enterprise Server version 4.0 to 4.1 for Novell® GroupWise®
  • Microsoft® SQL Server® 2000 and 2005
  • Microsoft® SQL Server® Desktop Engine



Overview

To move from a Microsoft SQL Server Desktop Engine (MSDE) database to a Microsoft SQL Server database, complete the following procedures:
Warning: Modifying databases used by the BlackBerry Enterprise Server can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.
Procedure 1: Microsoft SQL Server preparations
Task 1: Assign appropriate permissions

Task 2: Update the BlackBerry Configuration Database schema
Procedure 2: Moving the BlackBerry Configuration Database from an MSDE to a Microsoft SQL Server database
Task 1: Back up the BlackBerry Configuration Database

Task 2: Restore the BlackBerry Configuration Database

Task 3: Configure the BlackBerry Enterprise Server to connect to the new BlackBerry Configuration Database

Task 4: Increase the maximum number of BlackBerry Messaging Agents

Task 5: Start the BlackBerry Enterprise Server services

Task 6: Make sure that BlackBerry Manager is pointing to the correct Microsoft SQL Server and BlackBerry Configuration Database

Task 7: Update the Open Database Connectivity (ODBC) Sources for the local computer

Procedure 1: Microsoft SQL Server preparations

This procedure can be performed before moving the database.
Note: Only perform the Microsoft SQL Server preparations when moving to a Microsoft SQL Server that has not hosted a BlackBerry Configuration Database.
Task 1: Assign appropriate permissions
  1. In the SQL Enterprise Manager, go to Microsoft SQL Servers > SQL Server Group > .
  2. Expand the Microsoft SQL Server selection and expand Security.
  3. Right-click Logins and click New Login.
  4. Type the new name. For Windows Authentication
    1. On the General tab, click the button to the right of the Name field.
    2. Select the new service account name from the Name list.
    3. Click Add.
    4. Click OK.
    For Microsoft SQL Server Authentication
    1. On the General tab, type the name of the Microsoft SQL Server account.
    2. Select the SQL Server Authentication option.
    3. Type the password for the Microsoft SQL Server account.
    4. Click Add.
    5. Click OK.
  5. From the Server Roles tab, select Server Administrators and Database Creators from the Server Role list. Note: If you are running BlackBerry Enterprise Server version 4.1, adding the System Administrators role allows the addition of the BlackBerry smartphone users in a role-based administration environment. For instructions, see the BlackBerry Enterprise Server for Microsoft Exchange: System Administration Guide.
  6. On the Database Access tab, perform the following steps:
    1. Select the check box for the BlackBerry Configuration Database (for example, BESMgmt).
    2. In the Database Roles for list, select the db_owner check box.
  7. Close SQL Enterprise Manager.

Task 2: Update the BlackBerry Configuration Database schema
To update the BlackBerry Configuration Database schema, complete the following steps:
  1. Download the installation package for the BlackBerry Enterprise Server version being used.
  2. Extract the contents.
  3. Copy the Database folder to the new Microsoft SQL Server.
  4. Modify the BlackBerry Configuration Database .cfg file (for example, BESMgmt.cfg).
  5. Open a command prompt and navigate to the Database directory.
  6. Type the following command for the BlackBerry Enterprise Server version being used: For BlackBerry Enterprise Server software version 4.0 to 4.1
    1. Type createdb.exe besmgmt.cfg.
    For BlackBerry Enterprise Server software version 3.6
    1. Type createdb.exe -o "C:\program files\microsoft sql server\80\tools\binn\osql.exe" -E -l "c:\program files\microsoft sql server\mssql\data" where C:\program files\microsoft sql server\80\tools\binn\ is the location of osql.exe and C:\program files\microsoft sql server\mssql\ is the location of the data directory for the Microsoft SQL Server.
    2. When the command has finished executing, close the command prompt.
    Note: For more information on the createdb.exe command or editing the besmgmt.cfg file, see the BlackBerry Enterprise Server: Installation Guide.

Procedure 2: Moving the BlackBerry Configuration Database from an MSDE to a Microsoft SQL Server database

Stop the BlackBerry Enterprise Server services that use the BlackBerry Configuration Database before performing these tasks.
Important: Restarting certain BlackBerry Enterprise Server services will delay email message delivery to BlackBerry smartphones. For more information, see KB04789.
Task 1: Back up the BlackBerry Configuration Database
If a Microsoft SQL Server is being used, complete the following steps:
  1. Open SQL Server Enterprise Manager.
  2. Right-click the name of the BlackBerry Configuration Database (for example, BESMgmt).
  3. Select Backup Database.
  4. Click Add to specify the Directory Name and File Name.
  5. Click OK to accept the settings.
  6. Click OK to perform the backup.
  7. Close the SQL Server Enterprise Manager.
If MSDE is being used, complete the following steps:
  1. Open a command prompt.
  2. Type one of the following:
    • osql -E (logs in to default instance using Windows® Authentication)
    • osql -U <username> -P <password> (logs in to default instance using SQL authentication)
    • osql -E -S <ServerName\InstanceName> (logs in to the named instance using Windows Authentication)
    • osql -U <username> -P <password> -S <ServerName\InstanceName> (logs into a named instance using SQL authentication)
  3. Press ENTER.
  4. Type the following commands in the specified order: 1> backup database <BlackBerry_Configuration_Database_name> to disk = "C:\backup.bak"

    2> go

    1> quit
  5. Close the command prompt.

Task 2: Restore the BlackBerry Configuration Database
Copy the BlackBerry Configuration Database backup to the new Microsoft SQL Server.
If a Microsoft SQL Server is being used, complete the following steps:
  1. Open SQL Enterprise Manager.
  2. Right-click the name of the BlackBerry Configuration Database (for example, BESMgmt).
  3. Select Restore Database.
  4. In the Restore Database as: field, type the name of the BlackBerry Configuration Database.
  5. Select the From Device option.
  6. Click Select Device.
  7. Click Add.
  8. Click the button beside the Name field and go to the backup.bak file.
  9. Click OK.
  10. Click OK.
  11. If necessary, on the Options tab, change the path for the MDF and LDF files under Move to physical file name.
  12. Click OK.
If MSDE is being used, complete these steps:
  1. Open a command prompt.
  2. Type one of the following:
    • osql -E (logs in to default instance using Windows Authentication)
    • osql -U <username> -P <password> (logs in to default instance using SQL authentication)
    • osql -E -S <ServerName\InstanceName> (logs in to the named instance using Windows Authentication)
    • osql -U <username> -P <password> -S <ServerName\InstanceName> (logs in to the named instance using SQL authentication)
  3. Press Enter.
  4. Type the following commands in the specified order: 1> restore database <BlackBerry_Configuration_Database_name> from disk = " .bak" with move "_data" to "\MSSQL\Data\.mdf", move "_log" to "\MSSQL\Data\ .ldf"

    2> go

    1> quit
  5. Close the command prompt.
Note: If the BlackBerry Configuration Database is restored using an account other than the BlackBerry Enterprise Server administration account, grant the account that is used by the database owner permission on the BlackBerry Configuration Database.

Task 3: Configure the BlackBerry Enterprise Server to connect to the new BlackBerry Configuration Database
On the BlackBerry Enterprise Server, complete the following steps:
  1. Click Start > Programs > BlackBerry Enterprise Server > BlackBerry Server Configuration.
  2. On the Database Connectivity tab, click Change Database.
  3. In the Change Database Wizard, specify the new Microsoft SQL Server name and the restored BlackBerry Configuration Database name.
  4. Continue with the Change Database Wizard, making sure that the Start Services check box is not selected.
  5. Click Finish.

Task 4 - Increase the maximum number of BlackBerry Messaging Agents
Note: This task is only required for BlackBerry Enterprise Server for Microsoft Exchange. This task does not apply when moving between MSDE databases.
To change the maximum number of BlackBerry Messaging Agents, complete the following steps:
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.
  1. To open the Registry Editor, click Start > Run, type regedit and click OK.
  2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Research In Motion\BlackBerry Enterprise Server\Agents.
  3. Double-click NumAgents.
  4. In the Value data field, type 5 and select the Decimal option.
  5. Click OK.
  6. Close the Registry Editor.

Task 5 - Start the BlackBerry Enterprise Server services
  1. Open the Microsoft Windows Services and start all BlackBerry Enterprise Server services. For more information, see KB13718. Note: The BlackBerry Database Consistency Service may be turned off as a default setting.
  2. In BlackBerry Manager, verify that all BlackBerry smartphone users display a Running status.
  3. Test the email message flow.

Task 6 - Verify that the BlackBerry Manager is pointing to the correct Microsoft SQL Server and BlackBerry Configuration Database
For BlackBerry Manager 4.0
  1. Open BlackBerry Manager.
  2. Right-click BlackBerry Manager and click Properties.
  3. On the Database tab, verify that the settings are configured for the new Microsoft SQL Server and BlackBerry Configuration Database.
For BlackBerry Manager 4.1
  1. Open BlackBerry Manager.
  2. Click Tools > Options.
  3. In the left pane, click Database.
  4. Verify that the settings are configured for the new Microsoft SQL Server and BlackBerry Configuration Database.

Task 7 - Update the Open Database Connectivity (ODBC) sources for the local computer
Note: This applies to BlackBerry Enterprise Server software versions 3.6 and 4.0 using local or remote BlackBerry Manager installations.
To update the ODBC sources, complete the following steps:
  1. Open the Data Sources dialog box in the Administrative Tools folder of the Control Panel.
  2. On the System DSN tab, select the BlackBerry Enterprise Server Administration Database data source.
  3. Click Configure.
  4. On the first tab, make sure the new Microsoft SQL Server address is correct.
  5. On the third tab, make sure that the default database is set to the correct BlackBerry Configuration Database. Note: The BlackBerry Configuration Database default name is BESMgmt.
  6. Click Next to continue.
  7. Click Finish to close the dialog box.



Additional Information

NOTE: If upgrading to Microsoft SQL Server 2005, please consult the support matrix as outlined in article KB11158.
If the IBM® Lotus® Domino® console fails to load the nBES task and displays the following error after the database is moved from a MSDE database to a Microsoft SQL Server 2000 database, see article KB03543.
Unable to open BESMgmt database

__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 04-22-2009, 11:31 AM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

updated
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #3 (permalink)  
Old 09-24-2009, 04:25 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

updated
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Reply

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


LinkBacks (?)
LinkBack to this Thread: http://www.port3101.org/featured-blackberry-kb-articles/902-kb12247-move-msde-database-microsoft-sql-server-database.html
Posted By For Type Date
Re: [Bes-admins] Bes database move to sql 2000 This thread Refback 12-15-2010 06:01 PM
Re: [Bes-admins] SQL Database This thread Refback 08-20-2009 05:12 PM
MSDE to SQL - BlackBerryForums.com : Your Number One BlackBerry Community This thread Pingback 06-01-2009 10:25 PM

Similar Threads
Thread Thread Starter Forum Replies Last Post
KB03112 - How to move the BESMgmt Database to a new SQL Server or instance hdawg Featured BlackBerry KB Articles 9 03-11-2010 01:49 AM
KB10669 - How to Move the BlackBerry Configuration Database for Domino hdawg Featured BlackBerry KB Articles 0 09-02-2009 09:51 PM
KB17627 - How to create a new Microsoft SQL Server Desktop Engine database instance hdawg Featured BlackBerry KB Articles 0 05-26-2009 12:03 PM
KB05041 - How to move the BlackBerry Configuration Database to a remote Microsoft SQL Si Featured BlackBerry KB Articles 0 03-27-2009 04:11 AM
KB12915 - Database Notification System not functioning after moving the database..... Si Featured BlackBerry KB Articles 0 03-05-2009 04:34 AM


All times are GMT -4. The time now is 08:27 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2