By: Jeremy Kadlec | Comments (3) | Related: > Security
Problem
In all of my ASP applications I need to have at least basic security, how can I do so in simple manner? The reality is that in the majority of my applications I need membership, profiles, role management and personalization, are any applications available directly from Microsoft to handle this need? If so, where can I find them? Do they integrate with the .NET 2.0 framework? If so, how do you set this up? Where can I find more information?
Solution
With the .NET 2.0 framework, it ships with the ASP.NET SQL Server Setup Wizard. This wizard will go through the process of setting up tables, views, stored procedures, roles, etc. in order to manage membership, profiles, role management and personalization in a standardized manner. These objects can be installed on a SQL Server instance and database you specify during the installation. This wizard can be found at - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe.
Installation Process
Below are the steps to install the ASP.NET SQL Server Setup Wizard. In order to initiate this process, double click on C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe which will start the wizard.
| ID | Description | Screen Shot |
| 1 | Intro Screen - Overview of the application and installation process.
Press the 'Next' button to continue the process. |
|
| 2 | Setup Option - Select the 'Configure SQL Server for application services' to install the product.
Press the 'Next' button to continue the process. |
|
| 3 | SQL Server Instance - Select the SQL Server instance, authentication means and database.
Press the 'Next' button to continue the process. |
|
| 4 | Settings Summary - Review the installation summary before installing the database objects.
Press the 'Next' button to continue the process.
|
|
| 5 | Close the wizard - Press the 'Finish' button to end the process. | 
|
Installed Objects
| ID | Description | Objects |
| 1 | Tables |
|
| 2 | Views |
|
| 3 | Stored Procedures |
|
| 4 | Database Roles |
|
Next Steps
- Check out the ASP.NET SQL Server Setup Wizard in a development environment and see how this application handles security relative to your needs and/or your current techniques.
- If this application offers additional functionality, then consider integrating this application in your environment.
- With all of the code in an unencrypted manner, you have the opportunity to customize the code as needed or see how techniques implemented by this solution can be customized and incorporated into your applications
About the author
Jeremy Kadlec is a Co-Founder, Editor and Author at MSSQLTips.com with more than 300 contributions. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP. Jeremy brings 20+ years of SQL Server DBA and Developer experience to the community after earning a bachelor's degree from SSU and master's from UMBC.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
