This documentation supports the 3.5 version of BMC Digital Workplace. To view the latest version, select the version from the Product version menu.

Pre-creating a database for Windows authentication

This topic describes how to pre-create a database for Windows authentication.

Notes

  • The user name and the schema name you create by using the following procedure must not contain a hyphen (-).
  • When you precreate a database with Windows authentication, the same schema and user is used for SmartIT_System, SmartIT_Business and Openfire.

Before you begin

Complete the BMC Digital Workplace and Smart IT installation worksheets.

To pre-create a database for Windows authentication

  1. Create a a single user and schema in your domain.
    For example, <Domain name>\SmartIT_Business
  2. Pre-create the database schema by running a script similar to the following example script:

    USE master
    GO
    CREATE DATABASE MyIT
    GO
    use MyIT
    GO
    CREATE LOGIN [<Domain name>\SmartIT_Business] FROM WINDOWS;
    GO 
    CREATE USER [<Domain name>\SmartIT_Business] from LOGIN [<Domain name>\SmartIT_Business]
    GO
    CREATE SCHEMA SmartIT_Business AUTHORIZATION [<Domain name>\SmartIT_Business]
    GO
    ALTER USER [<Domain name>\SmartIT_Business] WITH DEFAULT_SCHEMA = SmartIT_Business
    GO
    GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO [<Domain name>\SmartIT_Business]
    GO
  3. On your installation worksheet, write the database name, user, and password.
  4. During installation select the pre-created db option.
  5. Enter user name as <Domain name>\SmartIT_Business (example from Step1) along with the domain password.

    Note

    Enter the same user name in the Business user name, System user name, and Openfire user name fields, and the same password in the Business user password, System user password, and Openfire user password fields

  6. (For upgrade) If you have set the Network security: LAN Manager authentication level field to Send NTLMv2 response only/refuse LM & NTLM, you must select the Use NTLMv2 check box during upgrade. 

The user name and the schema name you create by using the following procedure must not contain a hyphen (-).

Where to go from here

Make sure that you have completed the remaining steps in Preparing for installation of BMC Digital Workplace and Smart IT.

Was this page helpful? Yes No Submitting... Thank you

Comments