i-lign SQL database setup

March 20, 2017

i-lign SQL database user

For SQL Server 2008*, SQL Server 2012, SQL Server 2014

  1. Create a new database in SQL Server Enterprise Manager.
  2. Create a new login and set an appropriately secure password.

Or create a windows user on the application server to use windows authentication.

  1. Add the windows user or SQL user login as a user in the new database.

The new Windows or SQL user needs the following memberships;

  • db_datareader
  • db_datawriter
  • db_ddladmin

The new user also needs to be granted ‘Control’ on the new database’s dbo schema.

(eg, grant control on schema :: dbo to [ilign-database-user])

*Support for SQL2008 is deprecated from i-lign 8.2 onward.