Configuring the Profiles Resource Connection String

  • Article

You can use Commerce Server Manager to change the Profiles resource connection string. The Profiles resource connection string is set during the unpacking process and is stored in the Administration database.

Ee825384.note(en-US,CS.20).gif Note

  • All connection strings in the Profiles resource are updated when any one string is changed.

To change the Profiles resource 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 Connection Strings tab, select the connection string you want to change, and then click Modify.
  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.

    This is the recommended configuration for 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.

    This option is not recommended for a secure site.
    User Name Type the user ID to use for authentication when you log on to the data source.

    This is not recommended.
    Password Type the password to use for authentication when you log on to the data source.

    This option is not recommended for a secure site.
    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.

    This option is not recommended for a secure site.
    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 page, click OK.

The connection string changes are applied to the Profiles resource.

See Also

About the Profiles Resource

Security Risk: Using SQL Authentication for the Profiles Resource

Copyright © 2005 Microsoft Corporation.
All rights reserved.