Creating database for Windows authentication during a Smart IT upgrade
Creating a database is a part of preparing for upgrade process. Perform the following steps to create the database for Windows authentication.
- This procedure is not required if you are upgrading Smart IT from version 18.05.
- The user name and the schema name you create by using the following procedure must not contain a hyphen (-).
When you create a database with Windows authentication, the same schema and user is used for SmartIT_System_New, SmartIT_Business_New.
- Make sure that sqljdbc_auth.dll, and sqljdbc_xa.dll files are available to a directory and that directory path is added to the ‘PATH’ variable. For more information, see KA #000223732.
- Create a a single user and schema in your domain.
For example, <Domain name>\SmartIT_Business_New
Create the database schema by running a script similar to the following example script:
USE master GO use SmartIT GO CREATE LOGIN [<Domain name>\SmartIT_Business_New] FROM WINDOWS; GO CREATE USER [<Domain name>\SmartIT_Business_New] from LOGIN [<Domain name>\SmartIT_Business_New] GO CREATE SCHEMA SmartIT_Business_New AUTHORIZATION [<Domain name>\SmartIT_Business_New] GO ALTER USER [<Domain name>\SmartIT_Business_New] WITH DEFAULT_SCHEMA = SmartIT_Business_New GO GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO [<Domain name>\SmartIT_Business_New] GO
- On your installation worksheet, write the database name, user, and password.
- During installation select the Use Pre-created Blank Schemas option.
Enter user name as <Domain name>\SmartIT_Business_New (example from Step1) along with the domain password.
Enter the same user name in the Business user name and System user name name fields, and the same password in the Business user password and System user password fields.
- 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.