Differences between revisions 2 and 3
⇤ ← Revision 2 as of 2020-10-08 00:12:50 →
Size: 778
Editor: scot
Comment:
← Revision 3 as of 2020-10-08 00:29:15 → ⇥
Size: 877
Editor: scot
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
Step 1: '''Step 1: Database Setup'''
Line 16: Line 16:

'''Step 2: Configure your service to use the database for authentication'''

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)