Installing the Database schema using Aspnet_regsql.exe
ASP.NET includes a tool for installing the SQL Server database used by the SQL Server providers, named Aspnet_regsql.exe. The Aspnet_regsql.exe tool is located in the drive:\WINDOWS\Microsoft.NET\Framework\versionNumber folder on your Web server. Aspnet_regsql.exe is used to both create the SQL Server database and add or remove options from an existing database.
You can run Aspnet_regsql.exe without any command line arguments to run a wizard that will walk you through specifying connection information for the computer running SQL Server and installing or removing the database elements for all the supported features. You can also run Aspnet_regsql.exe as a command-line tool to specify database elements for individual features to add or remove.
To run the Aspnet_regsql.exe wizard, run Aspnet_regsql.exe without any command line arguments, as shown in the following example:
You can also run the Aspnet_regsql.exe tool as a command-line utility. For example, the following command installs the database elements for membership and role management on the local computer running SQL Server:
aspnet_regsql.exe -S <database server> -U <database user> -P <database password> -d <database name> -A all
Please note you'll need to replace the sections in <> with the information for your specific database. If you do not readily have this information available it is accessible from your control panel at https://control.appliedi.net/,
Remotely managing the Membership database
Once you've created the Application Database schema in your database you'll want to remotely manage the membership database. Unfortunately, there is not remote management interface available this task. The best way to manage the membership database is by using Visual Studio or Visual Web Developer.
1. Open your web application in Visual Studio or Visual Web Developer and open the web.config file.
2. The membership provider uses a default connection string named "LocalSqlServer". So we'll want to edit the section:
and add between the <connectionStrings> and </connectionStrings the following two lines:
Â <remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=[database server];Integrated Security=false;Initial Catalog=[database name];User ID=[database username];Password=[database password]" providerName="System.Data.SqlClient" />
Take care to replace the sections between brackets and the brackets as well.
3. Save your web.config.
4. Select ASP.NET Configuration from the "website" menu at the top of your development studio (either Visual Web Developer or Visual Studio). This will open the ASP.net Website administration tools
5. Select the security tab.
6. click on "Select Authentication type" and select "From the Internet" and click the done button.
You are now able to remotely manage your membership users and roles for your website as well several other application settings that would normally not be available remotely.