Creating the database for Windows authentication
Creating a database is a part of preparing for installation process. Perform the following steps to create the database for Windows authentication.
Before you begin
- Ensure that the user name and the schema name you create by using the following procedure does not contain a hyphen (-).
- When you create a database with Windows authentication, the same schema and user is used for SmartIT_System, SmartIT_Business and Openfire.
To create the database for Windows authentication
- Create a single user and schema in your domain.
For example, <Domain name>\SmartIT_Business
Create the database schema by running a script similar to the following example script:
USE master GO CREATE DATABASE SmartIT GO use SmartIT 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 Use Pre-created DB option.
Enter the user name as <Domain name>\SmartIT_Business (example from Step1) along with the domain password.
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.