ASP.NET provider database configuration

To implement the SQL Anywhere ASP.NET providers, you can add the required schema to a new or existing database.

To add the schema to a SQL Anywhere database, run SASetupAspNet.exe. When executed, SASetupAspNet.exe connects to a SQL Anywhere database and creates tables and stored procedures required by the SQL Anywhere ASP.NET providers. All SQL Anywhere ASP.NET provider resources are prefixed with aspnet_. To minimize naming conflicts with existing database resources you can install provider database resources under any database user.

You can use a wizard or the command line to run SASetupAspNet.exe. To access the wizard, run the application, or execute a command line statement without arguments. When using the command line to access the SASetupAspNet.exe, use the question mark (-?) argument to display detailed help for configuring the database.

Setting up the database connection

It is recommended that you specify a connection string with a user with the appropriate privileges for the database objects they will be creating. The following minimum set of privileges are required.

CREATE ANY TABLE
SELECT ANY TABLE
DELETE ANY TABLE
INSERT ANY TABLE
ALTER ANY TABLE
DROP ANY TABLE
CREATE ANY PROCEDURE
ALTER ANY PROCEDURE
DROP ANY PROCEDURE
CREATE ANY INDEX
ALTER ANY INDEX
DROP ANY INDEX

Specifying a resource owner

The wizard and command line (-U <user>) allow you to specify the owner of the new resources (tables and procedures). By default, the owner is DBA. You can specify a different owner using the wizard. When you specify connection strings for the SQL Anywhere ASP.NET providers, the UserID (UID) must match the user you specify here. You do not need to grant the specified user any extra privileges; the user owns the resources and has full privileges on the tables and stored procedures that are created for this user by the wizard.

Selecting features and preserving data

You can add or remove specific features. Common components are installed automatically. Selecting Remove for an uninstalled feature has no effect; selecting Add for a feature already installed reinstalls the feature. By default, the data in tables associated with the selected feature is preserved. If a user significantly changes the schema of a table, it might not be possible to automatically preserve the data stored in it. If a clean reinstall is required, data preservation can be turned off.

It is recommended that the membership and roles providers are installed together. The effectiveness of the Visual Studio ASP.NET Web Site Administration Tool is reduced when the membership provider is not installed with the roles provider.