How to Modify the Direct Mailer Connection String
The Direct Mailer resource connection string is set during the unpacking process. You can modify the Direct Mailer resource connection string to the Direct Mailer database, which stores information such as mailing lists, messages, and direct mail event data.
Do not configure the Direct Mailer global resource to use SQL Authentication.
To modify the Direct Mailer connection string
Click Start, point to Programs, point to Microsoft Commerce Server 2009 R2 , and then click Commerce Server Manager.
In Commerce Server Manager, in the left pane, expand Commerce Server Manager, expand Global Resources, right-click Direct Mail on <server name>, and then select Properties.
In the DirectMail on <server name> Properties dialog box, on the Connection Strings tab, in the Connection strings in this resource box, select Direct Mailer Database, and then click Modify.
In the Data Link Properties dialog box, 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 path of the server that contains the database that you want to access.
Use Windows NT Integrated security
Click to specify that the provider request a secure (or trusted) connection to a SQL server that is running on Microsoft Windows NT. This is the recommended configuration.
Use a specific user name and password
Click to use a SQL Server user name and password to authenticate your logon information to the data source. We do not recommend this configuration.
User name
Type the user ID to use for authentication when you log on to the data source. We do not recommend this configuration.
Password
Type the password to use for authentication when you log on to the data source. We do not recommend this configuration.
Blank password
Select this option to return a blank password in the connection string. We do not recommend this configuration.
Allow saving password
Select this option to allow the password to be saved with the connection string.
Select the database on the server
Select the database name that you want to access.
Attach a database file as a database name
Do not use this option. Commerce Server 2009 R2 does not support Microsoft SQL Server version 6.5 or earlier.
Click Test Connection to make sure that you have entered server and database information correctly, and then click OK to close the connection message.
To close the Data Link Properties dialog box, click OK.
In the Direct Mail on <server name> Properties dialog box, on the Connection Strings tab, the connection string appears in the Connection strings in this resource box.
To exit the Direct Mail on <server name> Properties dialog box, click OK.