There are two types of authentication that can be used during the creation of the Simplify Suite database.  They are SQL authentication and Windows NT authentication.  triCerat recommends the use of SQL authentication during the creation of the database whenever possible. 

SQL Authentication

During database creation, you will need to use the ‘sa’ account or an account with privileges. Once the database has been created, any account that has ‘public’ and ‘db_owner’ roles may be used for database connectivity.

Windows NT Authentication

During database creation, you will need to use an ‘Administrator’ account or an account with ‘Administrator’ equivalent privileges.  Once the database has been created, permissions must be granted so that users have access to the Simplify database. The database roles required are ‘public’ and ‘db_owner’.

In addition to user permissions, terminal server accounts must also be granted permission since some elements of Simplify Suite run in the system account. Usually, all servers in the active directory are added to a group called ‘Domain Computers’. The SQL Server must be configured to grant access to the Simplify database to this group.