Adding Authentication/Authorization
Step 1:
- 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.