Adding Authentication/Authorization
Step 1: Database Setup
- Install Sql Server Express (default installation will work. Instance = [servername]\SQLEXPRESS).
- Install Sql Server Management Studio (SSMS) on the server
- Create a database
- In SSMS, right click on the databases folder, select New Database...
Give it a name "MovieUsers"
Run C:\Windows\Microsoft.NET\Framework\v4.0.30319>aspnet_regsql.exe
- Choose the Configure SQL Server for application services option and select next.
- Fill in the server name and append "\SQLEXPRESS" e.g. CPTR446\SQLEXPRESS
Leave Windows authentication selected and Drop down the database selection. You should see MovieUsers. Select it and click next, next, finish.
That should finish the database setup.
Step 2: Configure your service to use the database for authentication