Documentation

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
borderColor#135570
bgColorwhite
titleColorwhite
borderWidth1
titleBGColor#135570
borderStylesolid
titleASP.NET Configuration Steps
UI Expand
titleCreate an ASP.NET Database
Excerpt
Panel
borderColor#444443
bgColorwhite
titleColorwhite
borderWidth1
titleBGColor#444443
borderStylesolid
titlePrerequisites

1. Have an asp.net framework

2. Ensure that Microsoft SQL Server is installed on the server

3. Authenticate with a user that has Create Database permissions

Panel
borderColor#116490
bgColorwhite
titleColorwhite
borderWidth1
titleBGColor#116490
borderStylesolid
titleCreate the Database
Section
Column
width50%

Image Modified

Column

 

1. Navigate to the following directory on the server: C:\Windows\Microsoft.NET\Framework\4.0.30319

2. Locate aspnet_regsql.exe, right-click, and select Run as administrator

Panel
borderColor#007fb2
bgColorwhite
titleColorwhite
borderWidth1
titleBGColor#007fb2
borderStylesolid
titleSetup Option
Section
Column
width50%

Image Modified

Column

 

3. On the first prompt (not shown), click Next

4. Select Configure SQL Server for application services and click Next

Panel
borderColor#007fb2
bgColorwhite
titleColorwhite
borderWidth1
titleBGColor#007fb2
borderStylesolid
titleServer and Database
Section
Column
width50%

Image Modified

Column

 

5. Set the Server to the server address

6. Select the database name or <default> (aspnetdb) from the Database dropdown

7. Click Next

Panel
borderColor#007fb2
bgColorwhite
titleColorwhite
borderWidth1
titleBGColor#007fb2
borderStylesolid
titleDatabase Creation
Section
Column
width50%

Image Modified

Column

 

8. Confirm the information (not shown) and click Next

9. A success message will appear, and click Finish to close the Wizard

Section
Column
width50%

Image Modified

Column

 

(OPTIONAL) With the new database created, verify that the database, tables,

storedprocedures

stored procedures, and roles have been created

Panel
borderColor#116490
bgColorwhite
titleColorwhite
borderWidth1
titleBGColor#116490
borderStylesolid
titleUpdate ASPNETDB Schema

10. Download and run the UpdateSchema.sql script to update the ASPNETDB schema

This adds support for Fingerprinting and Push Notifications

Panel
borderColor#007fb2
bgColorwhite
titleColorwhite
borderWidth1
titleBGColor#007fb2
borderStylesolid
titleExecute Procedure
Section
Column
width50%

Column

 

11. In the aspnetdb, expand Stored Procedures under Programmability, and right-click dbo.aspnet_Applications_CreateApplication

12. Click Execute Procedure, which opens a new window

13. Provide the application name in the Value field, e.g. /SecureAuth

14. Click OK

...