SQL Authentication
Summary of setup:
- Create New Database in SQL Server
- Create New Login Credential and set up ownership for new Credential on new Database
- Use Mixed Mode Authentication Setting within SQL Server
- Confirm you can log in with SQL Server Management Studio as newly created credential
IIS Settings
No changes needed in authentication IIS as credential is stored in Web.config
Loading Database Schema
Execute SmartcryptDB.exe as normal because the database credential is stored in Web.config
Sample Connection String in Web.config
dbserver = Name of the database server – example: qadbserv.domain.com
dbname = Name of the Database created in the server - example: smartcrypt
dbusername = Value of the SQL Login credential username
dbpassword = Value of the SQL Login credential password