Error: "The following error occurred while connecting to the specified server [[DBNETLIB][Connect (4234195)

When configuring the BlackBerry Report Pack and trying to connect to the BlackBerry Domain the following error is returned:

"The following error occurred while connecting to the specified server [[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.]."

This can be due to the MessageStats service account having insufficient permissions to the BES Management configuration database or if the SQL server name (and instance if applicable) was entered incorrectly.

This error can also be returned if there is a communication issue between the server where MessageStats is installed and the SQL where the BES Mangement configuration database is hosted (for example a Firewall blocking communication)

Please confirm and verify each of the following:

1. If you are using BES 4.x, on the BES Management configuration database assign the MessageStats service account the rim_db_admin_audit_sr_helpdesk database role
2. If you are using BES 5.x, on the BES Management configuration database assign the MessageStats service account the db_datareader database role
3. The SQL server name (and instance name if applicable) match where the BES Management configuration database is hosted
4. There are no communication issues preventing the server where MessageStats is installed from contacting the SQL server where the BES Management configuration database is hosted. A simple test is to use a UDL file:

• Logon to the MessageStats server with the MessageStats service account and create a new file called Test.udl
• Double click the file to invoke the properties
• Select the Provider tab
• Select Microsoft OLD DB Provider for SQL Server and click Next
• Enter the name of the SQL Server where the BES Management configuration database is hosted. If there is an instance name the server name will need to be entered in the following format: ServerName/InstanceName
• Select Use Windows NT Integrated security
• Click the drop down box, select the BES Management configuration database and click Test Connection
• If you cannot return a list of the databases from the dropdown box, or Test Connection fails with the same error, please select Use a specific user name and password
• Enter the credentials for a SQL account that is known to have access to the database
• Click the dropdown box to select the database and click Test Connection
• If the connection fails with both accounts then there could be a network issue preventing the MessageStats server from accessing the SQL server