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 http://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.