Symptoms

BlackBerry related tasks fail with the following error:

Provisioning request failed. Error in 'BESProvider.addUser'. The request failed with HTTP status 401: Unauthorized. Type: System.Net.WebException.

The following error can be found in Event Viewer on the BlackBerry server:

Log Name:      Application
Source:        BlackBerry Dispatcher SERVER01
...
Description:
{ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLNCLI10.1;Server=serverbes01,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="BlackBerry Dispatcher SERVER01" />
<EventID Qualifiers="45055">25137</EventID>
<Level>3</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2014-06-10T19:49:24.000Z" />
<EventRecordID>5714640</EventRecordID>
<Channel>Application</Channel>
<Computer>SERVER01.hosting.local</Computer>
<Security />
</System>
<EventData>
    <Data>{ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLNCLI10.1;Server=serverbes01,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes</Data>
</EventData>
</Event>

Cause

Connection issues between BES servers and MSSQL database or pem_admin user authentication issue.

Resolution

Please check the following:

  1. Verify connection from BES server to MSSQL database server on TCP port 1433.
  2. Try to access MSSQL database using pem_admin account. If it is not accessible, troubleshoot what is the reason - e.g. pem_admin account can be locked out.

Internal content