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
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.
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.
Click Next.
In the Data Source dialog box, in the Source Type drop-down list, select OLEDB-ANSI Provider, and then click Next.
In the Partitions dialog box, select Partitioned Data Source to partition the data source, and then click Add.
In the Partition dialog box, click Edit.
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.
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.
Click OK to return to the Partition dialog box.
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.
To return to the Partitions dialog box, click Finish.
To open the Custom Attributes dialog box, click Next.
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.