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 appropriate password. Add the login as a user in the new database. The new 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.
This article describes one way you can connect IIS to Tomcat on Windows and delegate Single Sign On authentication to IIS. Prerequisites This example assumes you already have the following in place; A Windows 2008 or 2008 R2 server that is a member of your Active Directory. This example assumes your Active Directory domain is named example.com in DNS and EXAMPLE in NetBIOS (if you still use that). You will need full administration rights on this server.