March 20, 2017
i-lign SQL database user
For SQL Server 2008*, SQL Server 2012, SQL Server 2014
- Create a new database in SQL Server Enterprise Manager.
- Create a new login and set an appropriately secure password.
Or create a windows user on the application server to use windows authentication.
- 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;
The new user also needs to be granted ‘Control’ on the new database’s dbo schema.
grant control on schema :: dbo to [ilign-database-user])
*Support for SQL2008 is deprecated from i-lign 8.2 onward.