Login with Windows Authentication in CionSystems Products
Windows Authentication Configuration in Sql Server for our products
- Go to SQL Server Management Studio with “sa” login.
- Security –> Login –> New Login –> click on Search button
- In “Select User or Group” Window, Click on “Locations” and in Location window select the domain and click on Ok.
- Click on Advance in user or group window and then click on “Find Now”
- Select Builtin users , The Builtin Users will appear in Logins, Right Click –> Properties –> Check the dbcreator under server roles.
- In User Mapping, select the database of product and assign db_owner role click ok.