Configure DTS to work with SQL Server

The Document Transform Service (DTS) is a ControlSuite shared service that allows Output Manager to work with AutoStore, Equitrac, and Business Connect. DTS transforms documents from one file type to another so that incoming documents are compatible with their destination. DTS is also used to provide watermarks and information stamping to documents from products other than Output Manager.

DTS can use either a LocalDB or SQL Server database. To use SQL Server, create an empty database in the SQL Server instance, then modify the connection string in the DTS web.config file to point to the SQL Server database. The web.config file and this topic include a sample connection string.

Each DTS instance must have its own database. Two DTS instances cannot point to the same database and DTS cannot share a database with any other applications.

DTS will populate an empty SQL Server database the same way it does a LocalDB database. If the CreateFreshDatabase option is set in DTS's web.config file when using a SQL Server database, DTS will drop the tables in the existing database and repopulate it. DTS will handle upgrades of SQL Server databases the same way it does with LocalDB.

To use a SQL Server database instead of LocalDB, do the following:

Stop the Document Transform Service if running.
Create an empty database in the SQL Server instance.

Comment out the following connection string definition:

<add name="TransformsServiceDatabase"
			 connectionString="server=(localdb)\Nuance_TS;database=TS_1.0;Integrated
			 Security=SSPI" providerName="System.Data.SqlClient" />

Create a new connection string definition using the following template:

 <add name="TransformsServiceDatabase"
			 connectionString="Data Source=<sql server>\<instance>;Initial
			 Catalog=<database>;Integrated Security=False;User
			 ID=<username>;Password=<password>"
			 providerName="System.Data.SqlClient" />

Replace <sql server>, <instance>, <database>, <username>, and <password> placeholders in the new connection string with appropriate values.

The system must be able to access the SQL Server specified. The username specified must have full rights to the database specified.

When DTS first connects to the database, it will confirm that the server name in set in the database is the server where DTS is running. If not, DTS will post an error and shut down.