Precreating a database for Windows authentication
This topic describes how to precreate a database for Windows authentication.
- Do not include a hyphen (-) in the user name and schema name you create by using the following procedure.
When you precreate a database with Windows authentication, the same schema and user are used for DWP_System and DWP_Business.
Before you begin
Complete the Installation worksheets for BMC Digital Workplace.
To precreate a database for Windows authentication
- Create a single user and schema in your domain (for example,domainName\DWP_Business).
Precreate the database schema by running a script similar to the following example script:
USE master GO CREATE DATABASE DWP GO use DWP GO CREATE LOGIN [<Domain name>\DWP_Business] FROM WINDOWS; GO CREATE USER [<Domain name>\DWP_Business] from LOGIN [<Domain name>\DWP_Business] GO CREATE SCHEMA DWP_Business AUTHORIZATION [<Domain name>\DWP_Business] GO ALTER USER [<Domain name>\DWP_Business] WITH DEFAULT_SCHEMA = DWP_Business GO GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO [<Domain name>\DWP_Business] GO
- On your installation worksheet, write the database name, user, and password.
- During installation select the precreated db option.
Enter the user name as domainName\DWP_Business (example from Step 1) and the domain password.
Enter the same user name in the Business user name and System user name fields, and the same password in the Business user password and System user password fields.
- (For upgrade) If you set the Network security: LAN Manager authentication level field to Send NTLMv2 response only/refuse LM & NTLM, select the Use NTLMv2 check box during upgrade.
Where to go from here
Make sure that you have completed the remaining steps in Preparing for installation of BMC Digital Workplace.