Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2020-10-08 00:07:23 →
Size: 349
Editor: scot
Comment:
← Revision 2 as of 2020-10-08 00:12:50 → ⇥
Size: 778
Editor: scot
Comment:
Deletions are marked like this. Additions are marked like this.
Line 10: Line 10:
 * 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.

Adding Authentication/Authorization

Step 1:

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

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