Differences between revisions 6 and 7
⇤ ← Revision 6 as of 2020-10-08 00:32:58 →
Size: 1033
Editor: scot
Comment:
← Revision 7 as of 2020-10-08 01:44:58 → ⇥
Size: 1309
Editor: scot
Comment:
Deletions are marked like this. Additions are marked like this.
Line 7: Line 7:
 * Install Sql Server Express (default installation will work. Instance = [servername]\SQLEXPRESS).  * Install Sql Server Express
   * Make sure to use both Windows and SQL authentication
  * Instance = [servername]\SQLEXPRESS).
Line 9: Line 11:
 * 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
   *

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