How to create a SQL Server user account that corresponds to a Microsoft Forecaster user account

Article translations Article translations
Article ID: 962460 - View products that this article applies to.
Expand all | Collapse all

SUMMARY

This article describes how to create a Microsoft SQL Server user account that corresponds to a Microsoft Forecaster 7.0 user account. To do this, you must have access to Microsoft SQL Server 2000 Enterprise Manager or Microsoft SQL Server 2005 Management Studio.

MORE INFORMATION

  1. Launch the SQL Server Management Tool.
  2. Expand server_name, and then expand Security.
  3. Right-click Logins, and then click New Login.
  4. Enter a user name for SQL Server.
    • In SQL Server 2000, type the user name in the Name box. If using Windows Authentication type [Domain Name\Username]
    • In SQL Server 2005, type the user name in the Login box. If using Windows Authentication type [Domain Name\Username]
  5. Enter a password.
    • In SQL Server 2000, click Windows Authentication or SQL Server Authentication. If you click SQL Server Authentication, type a password in the Password box.
    • In SQL Server 2005, click Windows Authentication or SQL Server Authentication. If you click SQL Server Authentication, type a password in the Password box. Then, retype the password in the Confirm Password box.
  6. Select the Microsoft Forecaster database.
    • In SQL Server 2000, click the Database Access tab, and then click the Microsoft Forecaster database.
    • In SQL Server 2005, click the User Mapping tab, and then click the Microsoft Forecaster database.
  7. Grant access to the Microsoft Forecaster database.
    • In SQL Server 2000, click the Microsoft Forecaster database, select the Permit check box, and then select the Public check box and the Forecaster check box in the Permit in Database Role window.
    • In SQL Server 2005, follow these steps:
    a. Click the Microsoft Forecaster database.
    b. Select the Map check box.
    c. In the Default Schema column, click the ellipsis button (...)
    d. In the Select Schema window, click Browse.
    e. In the Browse for Objects window, select the Forecaster check box, and then click OK two times
    f. In the Database role membership for window, select the Public check box and the Forecaster check box.

    NoteThe Default Schema selected depends on the user being created. If the user is an Administrator user who has rights to create periods and has the db_owner role assigned, that user must have the Default Schema set to 'dbo'. All other Forecaster users will use the default schema of 'Forecaster'.
    The roles selected for each user depend on the kind of Forecaste users. The user who is the administrator and can create periods will also need the 'db_owner' role assigned.
  8. Click OK.
  9. In the Confirm new password box, type the password. This step applies only to SQL Server 2000.

Properties

Article ID: 962460 - Last Review: January 21, 2009 - Revision: 1.2
APPLIES TO
  • Microsoft Forecaster 7.0
Keywords: 
KB962460

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com