Adding Authentication/Authorization
These directions are based on chsakell's Blog Post
Step 1: Database Setup
- Install Sql Server Express
- Make sure to use both Windows and SQL authentication
- Instance = [servername]\SQLEXPRESS).
- Install Sql Server Management Studio (SSMS) on the server
- Start SSMS and connect to [servname]\SQLEXPRESS
- Right click on the server and select properties
- Select the connections page
- Click allow remote connections and select ok.
- Start Sql Server Configuration Manager
Set the following elements SqlConfig.png
- Under "SQL Server Services" Right click on "SQL Server (SQLEXPRESS)" and click restart.
- Add a Windows firewall rule to allow incoming connections to port 1433. (if you are not sure how to do this, ask an IT major or google it)
- You can now remotely connect to the server using just the IP address. Try it on SSMS
- 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