Share via


How to Create a Data Source for SQL Server

Use the following procedure to create a new data source with a SQL Server database partition.

To create a data source for SQL Server

  1. Expand Commerce Server Manager, expand Global Resources, expand Profiles (<server name_database name>), expand Profile Catalog, right-click Data Sources, and then click New Data Source.

  2. In the New Data Source dialog box, do the following:

    Use this

    To do this

    Name

    Type the programmatic name of the data source. The name can contain a maximum of 127 alphanumeric characters and the underscore (_) symbol. The name cannot contain spaces.

    Display Name

    Type a display name that contains a maximum of 127 Unicode characters.

    Description

    Type a description for the data source. The description can contain a maximum of 127 Unicode characters.

  3. Click Next.

  4. In the Data Source dialog box, in the Source Type drop-down list, select OLEDB-ANSI Provider, and then click Next.

  5. In the Partitions dialog box, select Partitioned Data Source to partition the data source, and then click Add.

  6. In the Partition dialog box, click Edit.

  7. In the Data Link Properties dialog box, on the Provider tab, select Microsoft OLE DB Provider for SQL Server as the provider for your data source, and then click Next.

  8. 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.

    Use a specified user name and password

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

    User Name

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

    Password

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

    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 save the password and the connection string together. The functionality of the calling application determines whether the password is included in the connection string. If the password is saved, it is returned and saved unmasked and unencrypted.

    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 Microsoft 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 attempt a connection to the specified data source. If the connection fails, verify that the settings are correct. Spelling errors and case sensitivity can cause failed connections.

  9. Click OK to return to the Partition dialog box.

  10. In the Partition dialog box, in the Partition Name box, type the name of the partition. To designate this partition as the default partition, click Default Partition, and then click Next.

  11. To return to the Partitions dialog box, click Finish.

  12. To open the Custom Attributes dialog box, click Next.

  13. Click Finish to close the dialog box. If you want to add custom attributes to the data source, see How to Add a Custom Attribute to a Data Source.

    The data source is saved. You can now add partitions, custom attributes, and data objects to the data source.

See Also

Other Resources

Managing Data Sources

How to Use the Profiles Schema Manager