Differences between revisions 1 and 6 (spanning 5 versions)
Revision 1 as of 2020-10-08 00:07:23
Size: 349
Editor: scot
Comment:
Revision 6 as of 2020-10-08 00:32:58
Size: 1033
Editor: scot
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
Step 1: These directions are based on [[https://chsakell.com/2013/04/09/authenticate-wcf-clients-using-the-asp-net-membership-provider/|chsakell's Blog Post]]

'''Step 1: Database Setup'''
Line 9: Line 11:
   * Give it a name "MovieUsers"    * 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'''

Adding Authentication/Authorization

These directions are based on chsakell's Blog Post

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)