Create an SQL Server login ID and password 

Create a login ID and password

This section provides instructions on creating an SQL Server login ID and password for the messaging software.

  1. From the Start button, select Programs->Microsoft SQL Server 7.0 (or Microsoft SQL Server)->Enterprise Manager.

  2. Expand the Microsoft SQLServer->SQL Server Group, and then locate and expand your SQL Server machine name.

  3. Expand the Security folder, and then double-click the Logins icon.

  4. Click on the New Login icon in the toolbar.

    Result:

    The SQL Server Login Properties - New Login dialog box appears.

  5. From the General tab, type msgcare in the User text box.

  6. Select the SQL Server authentication option.

  7. Type a password in the Password text box.

  8. Select the Database Access tab.

  9. Select the Permit check box for the MCAdmin database.

  10. Select the public check box and the db_owner check box in the Permit in database role selection list.

  11. Repeat Steps 8-9 for the MCArchive database and the MCMessages database.

    Important!

    Use the same user name and password for each database.

  12. Click the OK button.

    Result:

    The Confirm Password dialog box appears.

  13. Enter the new password in the Confirm Password text box, and then click the OK button.

  14. For non US-English installations of the messaging software, perform the steps in Non US-English installations.

Non US-English installations

Important!

For non US-English installations, the default language for the msgcare SQL Server login needs to be changed to English. You must complete this before you can successfully archive message records. This is because the msgcare login created in localized SQL Server installations, by default, is associated with the localized language. This would cause the messaging archive program to fail due to the different date formats used in the various languages supported by the messaging software. To treat the date format in a consistent manner, the default language for the msgcare SQL Server login needs to be changed to English.

To treat the date format in a consistent manner, do the following:

  1. Open the SQL Server's Enterprise Manager, and then select English as the Default Language in the General tab for "msgcare."

  2. In the Security section of the specific SQL Server machine used, double click on the msgcare login.

  3. From the General tab for msgcare, select English as the default language.

    Selecting English as the default language will also make the SQL Sever use English in its internal logging facilities instead of the localized language. This would help support/service personnel troubleshoot any SQL Server related problems.

    NOTE: You can create a separate SQL Server login with the local language as default to access/monitor the SQL Server (other settings must be identical to msgcare login to view the message databases).

   


Copyright © 2001
Avaya Inc.
All rights reserved.
Modified: March 19, 2001