The aspnet_regsql.exe tool is used to register the MS SQL Server
database which is used by the providers in ASP.NET.
The aspnet_regsql.exe is located in the following on the web
server:
[drive:]\%windir%\Microsoft.NET\Framework\version folder
You can run aspnet_regsql.exe as a command-line tool to
specify database elements for individual features to add or remove, using the
options listed in the table below.
Command Name
|
Description
|
-?
|
Describes all the help options of the command.
|
-w
|
Runs the tool in the wizard mode with specifying the
options.
|
-C<connection string>
|
Specifies the connection string to the computer running
sql server where the database needs to be installed.
|
-S <server>
|
This option is used to specify the name of the sql server
where the database needs to be installed.
|
-U<user id>
|
This option is used to specify the user id of the sql
server to login with.
|
-P
|
This is used to specify the password of the sql server to
login with.
|
-E
|
This option uses the windows credentials of the currently
logged on user.
|