|
Size: 877
Comment:
|
Size: 1486
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
These directions are based on [[https://chsakell.com/2013/04/09/authenticate-wcf-clients-using-the-asp-net-membership-provider/|chsakell's Blog Post]] |
|
| Line 5: | 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 7: | 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 * Set the following elements [[attachment:SqlConfig.png]] * Restart the sql server. * You can now remotely connect to the server using just the IP address. Try it on SSMS |
|
| Line 9: | Line 21: |
| * Give it a name "MovieUsers" | * Give it a name "!MovieUsers" |
| Line 13: | Line 25: |
| * 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
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
Set the following elements SqlConfig.png
- Restart the sql server.
- You can now remotely connect to the server using just the IP address. Try it on SSMS
- 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