Installation and Configuration Guide

Local Navigation

首頁  >  系統管理員文件  >  BlackBerry Pushcast Software  >  Installation and Configuration Guide BlackBerry Pushcast Software - 5.8

Configure notification emails in Microsoft SQL Server

You must configure settings on the Microsoft SQL Server so that BlackBerry Pushcast Player users can receive notification emails from the BlackBerry Pushcast Software when content is about to expire.
  1. On the server that you installed the Microsoft SQL Server on, click Start > All Programs > Administrative Tools > Computer Management.
  2. Click Local Users and Groups.
  3. Right-click Users and click New User.
  4. In the User name field, type LocalSQLjob.
  5. In the Description field, type Account for running SQL server scheduled jobs.
  6. In the Password field, type a password.
  7. Verify that the Password never expires check box is selected.
  8. Click Create.
  9. In the Name column, right-click LocalSQLjob and click Properties.
  10. On the Member of tab, click Add.
  11. In the Enter the object names field, type Administrators.
  12. Click OK.
  13. Click Start > Programs, and open Microsoft SQL Server Management Studio and connect to the database engine.
  14. Right-click SQL Server Agent, and if the SQL Server Agent is not running, click Start.
  15. Click Management > Database Mail.
  16. Right-click Database Mail, and click Configure Database Mail.
  17. Click Next.
  18. Select the Manage Database Mail accounts and profiles option.
  19. Click Next.
  20. If you receive a prompt to enable the database, click Yes.
  21. Select the Create a new profile option.
  22. In the New Profile window, in the Profile name field, type BlackBerry Pushcast.
  23. In the Description field, type Profile for sending BlackBerry Pushcast notifications.
  24. Click Add.
  25. In the New Database Mail Account window, in the Account name field, type Pushcast.
  26. In the Description field, type BlackBerry Pushcast.
  27. In the E-mail address field, type an email address (for example, no-reply@rim.net).
  28. In the Display name field, type BlackBerry Pushcast.
  29. In the Server name field, type a server name (for example, smtp-ca.rim.net).
  30. In the Port field, type 25.
  31. In the SMTP Authentication section, select an authentication option.
  32. Click OK.
  33. Click Next.
  34. Click Finish.
  35. On the BlackBerry Pushcast server, navigate to <install_dir>\webapp\CPC\db_sql\sql\.
  36. Right-click the SetupCourseExpirySQLJob.sql file and click Open.
  37. Change the value for SET @loginName = N" to SET @LoginName = N'servername\LocalSQLJob' to match the server name and the user name that you specified in step 4. The format is <server_name>\<username> (for example,'server01\LocalSQLJob').
  38. Change the value for @DatabaseName to the database name that was created when you installed the BlackBerry Pushcast Software. The default database name is BPC_BPS.
  39. Move the SetupCourseExpirySQLJob.sql file to the Microsoft SQL Server.
  40. Open the SetupCourseExpirySQLJob.sql file using Microsoft SQL Server Management Studio.
  41. Click Execute script.
Next topic: Create a host for the BlackBerry Pushcast Software
Previous topic: Upgrade the BlackBerry Pushcast Software

Was this information helpful? Send us your comments.