When attempting to connect to Blackberry servers using the Spotlight on Messaging management console users may receive the following error:
Failed to connect to database. Connection string: Data Source=<<SERVERNAME>>;Initial Catalog=BESMgmt;Integrated Security=True.
Inner exception: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server)
This is related to Remote Connections not being enabled for the SQL instance being used for the BESMgmt database.
The resolution can depend on the version of SQL or SQLExpress that is running.
To enable Remote Connections for SQL 2005 and SQLExpress please view the following article: http://support.microsoft.com/kb/914277
If the BESMgmt database has been installed using MSDE SQL 2000 then the following can be done on the server hosting the MSDE database:
1) Click Start, Run
2) Enter svrnetcn.exe too run the "SQL Server Network Utility"
3) Select "TCP/IP" and "Named Pipes" from the Disabled protocols and click "Enable >> "
4) Use Blackberry Enterprise Services Manager to stop the Blackberry services
5) Restart the SQL Desktop Engine services
6) Restart the Blackberry Enterprise Server services.
This will now allow access to MSDE remotely with SQL Server Enterprise Manager and you can now attempt the connection to Blackberry servers through Spotlight Management console.
