Differences between revisions 4 and 5
⇤ ← Revision 4 as of 2020-10-08 00:29:24 →
Size: 878
Editor: scot
Comment:
← Revision 5 as of 2020-10-08 00:29:35 → ⇥
Size: 879
Editor: scot
Comment:
Deletions are marked like this. Additions are marked like this.
Line 13: Line 13:
   * Leave Windows authentication selected and Drop down the database selection. You should see MovieUsers. Select it and click next, next, finish.    * Leave Windows authentication selected and Drop down the database selection. You should see !MovieUsers. Select it and click next, next, finish.

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

WebServices/ProgrammingHomeworks2020/HW05 (last edited 2020-10-11 20:14:58 by scot)