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.
  • 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