How to locate the SRP ID and SRP Authentication Key

Article ID: KB02632

Type: Support Content

Last Modified: 06-14-2013

 

Product(s) Affected:

  • BlackBerry Enterprise Server for Microsoft Exchange
CollapseEnvironment
  • BlackBerry Enterprise Server 3.6 to 5.0 for Microsoft Exchange
  • BlackBerry Enterprise Server Express 5.0
  • BlackBerry Professional Software
  • BlackBerry Device Service 6.1 to 6.2
  • Microsoft SQL Server 2000 to 2008
  • Microsoft SQL Server Express 2005 to 2008
  • Microsoft Data Engine (MSDE)
CollapseOverview

The Server Routing Protocol Identifier (SRP ID) and SRP Authentication Key can be found in the following locations:

  • In the BlackBerry Configuration Database
  • In the cached property file
  • In the BlackBerry Manager or the BlackBerry Enterprise Server Management console
  • On the BlackBerry smartphone

This article explains how to locate the SRP ID and SRP Authentication Key in the BlackBerry Configuration Database and the Cached Property file.

To locate and change the SRP ID and SRP Authentication Key using BlackBerry Manager or the BlackBerry Administration Service, see KB04744.

To locate the SRP ID on the BlackBerry smartphone, see KB05508.


In the BlackBerry Configuration Database

Use the appropriate method for the version of BlackBerry Enterprise Server and platform that is running.

BlackBerry Enterprise Server 4.0, 4.1 and 5.0 for all platforms as well as the BlackBerry Device Service 6.1 to 6.2

In the Microsoft SQL Server Management Studio (MS SQL Server 2005 and 2008)

  1. Highlight the BlackBerry Configuration Database.
  2. Click New Query.
  3. Type: SELECT ServiceName, SRPId, SRPKey FROM ServerConfig
  4. Press F5 or click the Execute button to run the query. The SRP Identifier and SRP Authentication Key appear.

In the Microsoft SQL Server Enterprise Manager (MS SQL Server 2000)

  1. Highlight the BlackBerry Configuration Database.
  2. Open SQL Query Analyzer.
  3. Type: SELECT ServiceName, SRPId, SRPKey FROM ServerConfig
  4. Press F5 to run the query. The SRP Identifier and SRP Authentication Key appear.

In the command prompt using OSQL (MSDE, MS SQL Server 2000, 2005 and 2008)

  1. From a command prompt, type one of the following commands:
     
    For SQL Authentication, type:
     
    osql -U <user_name> -P <password> -S <SQL_Server_name>\<instance_name>
     
    where <user_name> is the SQL login name, <password> is the account password, <SQL_Server_name> is the hostname of the SQL Server and <instance_name> is the named instanceFor Microsoft Windows Authentication, type:
     
    osql -E -S <SQL_Server_name>
     
    where <SQL_Server_name> is the hostname of the SQL Server and <instance_name> is the named instance
     
    Note: If the database is running on a named instance use the following to specify the instance name:
     
    osql -E -S <SQL_Server_name>\<instance_name>
     
  2. The 1> prompt will appear if the connection was successful.
  3. Type the following commands to use the BlackBerry Configuration Database:
     
    1> use <database_name>
    2> go
     
    where <database_name> is the name of the BlackBerry Configuration Database. For example, 1> use BESMgmt
     
  4. Type the following commands:
     
    1> SELECT ServiceName, SRPId, SRPKey FROM ServerConfig
    2> go
     
    The BlackBerry Enterprise Server name, SRP Identifier and SRP Authentication Key appear.
     
  5. To exit OSQL, type the following command:
     
    1> quit
     
  6. Close the command prompt.

 
BlackBerry Enterprise Server 3.6 for Microsoft Exchange

In the Microsoft SQL Server Enterprise Manager (MS SQL Server 2000)

  1. Highlight the BlackBerry Configuration Database.
  2. Open SQL Query Analyzer.
  3. Type: SELECT BESAgentName, SRPID, SRPKey FROM BESAgent
  4. Press F5 to run the query. The SRP Identifier and SRP Authentication Key are displayed.

In the command prompt using OSQL (MSDE and MS SQL Server 2000)

  1. From a command prompt, type one of the following commands:
     
    For SQL Authentication, type:
     
    osql -U <user_name> -P <password> -S <SQL_Server_name>\<instance_name>
     
    where <user_name> is the SQL login name, <password> is the account password, <SQL_Server_name> is the hostname of the SQL Server and <instance_name> is the named instance
     
    For Microsoft Windows Authentication, type:
     
    osql -E -S <SQL_Server_name>
     
    where <SQL_Server_name> is the hostname of the SQL Server and <instance_name> is the named instance
     
    Note: If the database is running on a named instance use the following to specify the instance name:
     
    osql -E -S <SQL_Server_name>\< instance_name>
     
  2. The 1> prompt will appear if the connection was successful.
  3. Type the following commands to use the BlackBerry Configuration Database:
     
    1> use <database_name>
    2> go
     
    where <database_name> is the name of the BlackBerry Configuration Database. For example, 1> use BESMgmt
     
  4. Type the following commands:
     
    1> SELECT BESAgentName, SRPid, SRPKey FROM BESAgent
    2> go
     
    The BlackBerry Enterprise Server name, SRP Identifier and SRP Authentication Key appear.
     
  5. To exit OSQL, type the following command:
     
    1> quit
     
  6. Close the command prompt.

 


In the Cached Property File

Note: The cached.property file only exists if the BlackBerry Mobile Data System (BlackBerry MDS) has been started.

On the BlackBerry Enterprise Server:

  1. Go to C:\Program Files\Research In Motion\BlackBerry Enterprise Server\MDS\Servers\<server_name>\config
  2. Use Microsoft Notepad to open the<BlackBerry_Enterprise_Server_name>.< version_number>.cached.property file.
  3. Search the text file for the SRP.UID and SRP.AuthenticationString. These entries are the SRP Identifier and SRP Authentication Key.
CollapseAdditional Information

If there are multiple BlackBerry Enterprise Servers in the environment the following command can also be run from SQL Management Studio, SQL Server Enterprise Manager or OSQL to get the list of BlackBerry Enterprise Server names along with the corresponding SRP IDs and Authentication Keys:

SELECT ServiceName,MachineName,SRPid,SRPKey FROM ServerConfig

Disclaimer

By downloading, accessing or otherwise using the Knowledge Base documents you agree:

   (a) that the terms of use for the documents found at www.blackberry.com/legal/knowledgebase apply to your use or reference to these documents; and

   (b) not to copy, distribute, disclose or reproduce, in full or in part any of the documents without the express written consent of RIM.


Visit the BlackBerry Technical Solution Center at www.blackberry.com/btsc.