Creating a New Data Source with a SQL Server Database Partition

  • Article

You can create a new data source with has a SQL Server database partition.

To create a new data source with a SQL Server database partition

  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 the name you want displayed for the data source. The display name can contain 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 allow the password to be saved with the connection string. 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. To return to the Partition dialog box, click OK.
  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 Adding 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.

Copyright © 2005 Microsoft Corporation.
All rights reserved.