Share via

How to Connect to a Data Store

  • Article

To specify a data source for the Profiles Schema Manager, you can provide the application name of the Internet Information Services (IIS) Web site for which the Profiles System is running against, or configure the database connection string.

To specify a data source by application name

  1. Expand Commerce Server Manager, expand Global Resources, right-click Profiles (<server name_database name>), and then click Properties.

  2. In the Profiles (<server name_database name>) Properties dialog box, on the Profiles tab, click Choose existing site.

  3. From the Site Name drop-down list, select the appropriate IIS application or Web site, and then click OK.

To configure the database connection string

  1. Expand Commerce Server Manager, expand Global Resources, right-click Profiles (<server name_database name>), and then click Properties.

  2. In the Profiles (<server name_database name>) Properties dialog box, on the Profiles tab, click Specify Profiles Data Store information, and then click Edit.

  3. In the Data Link Properties dialog box, on the Connection tab, do the following:

    Use this

    To do this

    Select or enter a server name

    Select a server name from the drop-down list, or type the location of the server where the database you want to access is located.

    Refresh

    Click to refresh the server list.

    Use Windows NT integrated security

    Select this option to specify that the provider request a secure (or trusted) connection to a SQL Server running on Microsoft Windows NT.

    We recommend this option to help make a secure site.

    Use a specified user name and password

    Select this option to specify a user name and password to authenticate your logon information to the data source.

    We do not recommend this option to help make the site secure.

    User Name

    Type the user ID to use for authentication when you log on to the data source.

    We do not recommend this option.

    Password

    Type the password to use for authentication when you log on to the data source.

    We do not recommend this option to help make the site secure.

    Blank password

    Select this option to enable the specified provider to return a blank password in the connection string.

    Allow saving password

    Select this option to allow the password to be saved with the connection string. Whether the password is included in the connection string depends on the functionality of the calling application. If the password is saved, it is returned and saved unmasked and unencrypted.

    We do not recommend this option to help make the site secure.

    Select the database on the server

    Select this option to type the database name that you are mapping the data source to, or select the database name from the drop-down list.

    Attach a database file as a database name

    Do not use this option. Commerce Server does not support SQL Server version 6.5 or earlier.

    Using the filename

    Do not use this option. Commerce Server does not support SQL Server version 6.5 or earlier.

    Test Connection

    Click to connect to the specified data source. If the connection fails, verify that the settings are correct. Spelling errors and case sensitivity can cause failed connections.

  4. To return to the Profiles (<server name_database name>) Properties dialog box, click OK.

  5. To save your changes and return to the Property screen, click OK.

The connection string changes are applied to the Commerce Server Profiles data store.

See Also

Other Resources

How to Start the Profiles Schema Manager

About the Profiles Schema Manager

Profiles Schema Manager UI Help