Port3101.org : Your BES Connection

Port3101.org : Your BES Connection (http://www.port3101.org/index.php)
-   Featured BlackBerry KB Articles (http://www.port3101.org/forumdisplay.php?f=3)
-   -   KB12247 - Move from an MSDE database to a Microsoft SQL Server database (http://www.port3101.org/showthread.php?t=902)

hdawg 04-16-2009 10:39 AM

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

<content>
  • 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
</content>
<hr class="section">
Overview

<content> 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
<hr> 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 > <SQL_server_name>.
  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. http://www.blackberry.com/btsc/artic...KB-04293_1.jpg
    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 <BlackBerry_Configuration_Database_name> list, select the db_owner check box.
  7. Close SQL Enterprise Manager.
<hr>
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.
<hr> 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.
<hr>
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 = " <path> <BlackBerry_Configuration_Database_name>.bak" with move "<BlackBerry_Configuration_Database_name>_data" to "<new_path>\MSSQL\Data\<BlackBerry_Configuration_Database_name>.mdf", move "<BlackBerry_Configuration_Database_name>_log" to "<new_path>\MSSQL\Data\ <BlackBerry_Configuration_Database_name>.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.
<hr>
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.
<hr>
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.
<hr>
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.
<hr>
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.
<hr>
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.
</content>
<hr class="section">
Additional Information

<content> 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
</content><content>
</content>

hdawg 04-22-2009 11:31 AM

updated

hdawg 09-24-2009 04:25 PM

updated


All times are GMT -4. The time now is 01:40 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


SEO by vBSEO 3.3.2 PL2