How to configure BlackBerry Enterprise Server (BES) when WorldClient runs under IIS Print

The IUSR_%ComputerName% account used by IIS needs access to the BlackBerry Enterprise Server (BES) database. 

This can be accomplished via the sqlcmd command line tool or the Microsoft SQL Server Management Studio Express graphical interface tool. Choose either the command line version of the instructions or the graphical interface version, they accomplish the same result. 

The command line method: 

1. Replace %ComputerName% with the name of the computer for the remainder of these instructions. For example, if your server is named c3po then replace ''%ComputerName%\IUSR_%ComputerName%'' with ''c3po\IUSR_c3po'' 
   Note: If you are running Server 2008 with IIS 7 or 7.5, replace '%ComputerName%\IUSR_%ComputerName%' with 'NT AUTHORITY\IUSR'.
2. Go to Start
3. Open All Programs
4. Open Accessories
5. Launch a Command Prompt 
   
   
   
6. Enter the following three commands:
   • sqlcmd -E -S LOCALHOST\MDAEMON -Q 'USE BESMgmt; EXEC sp_grantdbaccess '%ComputerName%\IUSR_%ComputerName%','iis_user''
   • sqlcmd -E -S LOCALHOST\MDAEMON -Q 'USE BESMgmt; EXEC sp_addrolemember 'db_datareader','iis_user''
   • sqlcmd -E -S LOCALHOST\MDAEMON -Q 'USE BESMgmt; EXEC sp_addrolemember 'db_datawriter','iis_user'' 
     
     
     

The graphical user interface method: 

1. Download and install Microsoft SQL Server Management Studio Express
   1. Download the appropriate (standard or x64) version from the Microsoft SQL Server Management Studio Express website.
   2. Double click on the downloaded SQLServer2005_SSMSEE.msi installer
   3. Click Next 
      
      
      
   4. Accept the license terms and click Next 
      
      
      
   5. Enter your name/company name as needed and click Next 
      
      
      
   6. Click Next again, and finally Install 
      
      
      
   7. Click Finish
2. Launch Microsoft SQL Server Management Studio Express
   1. Click the Start menu
   2. Click All Programs
   3. Open Microsoft SQL Server 2005
   4. Launch SQL Server Management Studio Express 
      
      
      
3. Connect to Server
   1. Server Name: Your server should be selected by default 
      
      
      
   2. Authentication: Windows Authentication (the default) 
      
      
      
   3. Click Connect 
      
      
      
4. In the Object Explorer pane, expand Security 
   
   
   
5. Expand Security
6. Right click on Logins and select New Login 
   
   
   
   1. Click the Search button beside Login name 
      
      
      
   2. Find the account that IIS runs under. If IIS is under its default account, follow these steps:
      1. Click Advanced 
         
         
         
      2. Click Find Now 
         
         
         
      3. Select the account called (or starting with) IUSR 
         
         
         
      4. Click OK 
         
         
         
   3. Select User Mapping 
      
      
      
   4. Enable the checkmark under the MAP column beside BESMgmt 
      
      
      
   5. In the Database role membershiplist at the bottom select:
      1. db_datareader 
         
         
         
      2. db_datawriter 
         
         
         
   6. Click OK 
      
      
      
   7. Close Microsoft SQL Server Management Studio Express