Precreating a database for Windows authentication
Before you begin
Complete the BMC-Digital-Workplace-and-Smart-IT-installation-worksheets.
To precreate a database for Windows authentication
- Create a a single user and schema in your domain.
For example, <Domain name>\SmartIT_Business Precreate 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- On your installation worksheet, write the database name, user, and password.
- During installation select the precreated db option.
Enter user name as <Domain name>\SmartIT_Business (example from Step1) along with the domain password.
- (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.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*