Create & Setup MSSQL Account
Before Manitou or SQL can be installed, the MSSQL Account must be created on any machine that will house a SQL Database related to Manitou. Follow this process to set up the account and provision it correctly.
Creating the MSSQL Account
- Open a run dialog and run lusrmgr.msc
- Open the Users folder and then right click within the user listing to select "New User..."
- Create a MSSQL Username with the name and description of "Microsoft SQL Server"
- Create a strong password for the account, recording it in the CRM under the name MSSQL.
- Uncheck "User must change password at next logon"
- Check "User cannot change password"
- Check "Password never expires"
- Select Create
- Right-click on the created MSSQL user and select Properties.
- Select the Member Of tab and then select Add...
- Type in Administrators and select OK.
- Select OK to close the MSSQL Properties window and close out of the lusrmgr application.
