The following steps must be completed in SQL Management Studio:
- Right click Logins (under security) and select new login
- In the field Login name type in IntranetConnections
- Change the default windows authentication to SQL server authentication
- Set the password (contact Support for the default password if needed)
- Uncheck 'Enforce password policy'
- In the database field from the drop down box select IntranetConnections
- Click on User Mapping
- Select the Database(s) IntranetConnections and SQBoxStatistics (only applicable if you're on Version 14.0+) by clicking in the checkbox
- Under Database roles make sure Public and db_owner are checked
- Click OK to finish the login creation