Skip to Content
0
Dec 09, 2011 at 05:42 AM

DQMigration Tool Issue with SQL Server

16 Views

Hello,

I'm trying to use the DQMigration tool with DS 4.0 SP02 and a SQL Server destination repository.

I'm getting the following error:

"Cannot connect to the repository. Please check your configuration options."

I'm following the guidelines for SQL Server, my dqmig.xml file contains the following lines:

<DI_REPOSITORY_OPTIONS>

<DATABASE_TYPE>Microsoft_SQL_Server</DATABASE_TYPE>

<DATABASE_SERVER_NAME>HQAISQL01</DATABASE_SERVER_NAME>

<DATABASE_NAME>DQM2</DATABASE_NAME>

<WINDOWS_AUTHENTICATION>NO</WINDOWS_AUTHENTICATION>

<USER_NAME>firstlogic140</USER_NAME>

<PASSWORD>xxxxxxxx</PASSWORD>

</DI_REPOSITORY_OPTIONS>

I can connect with Repository Manager to this local repository using these exact same settings on this same system. If I could post a screen shot I would, but it's a valid local repository on an external SQL Server instance.

Any idea what's going wrong?

Tony