Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Connection String for DQS

Proposed Answer Connection String for DQS

  • Thursday, July 26, 2012 8:35 PM
     
     
    Sign In to Vote
    0

    Hi all,

           I have a new Integration Services Project and I'm using the DQS cleansing control.  My SSIS package executes well since I have configured the the DQS control to use my user credential to connect to the DQS specific databases (e.g. DQS_Main, DQS_Projects and DQS_Staging_Data).  However, when I go to production I would like to create one account that can be use for the various DQS constrols used through out my Integration Service Project.

           What is the best way to create a connection string to connect to a DQS database and to provide credentials.  I would like to create one connection/provider using a specific account when connecting to a DQS database.

           FYI....I have tried creating a new DQS connection via connection manager but I never have a chance to pipe in different credentials.

    Thanks for any help.

     

All Replies

  • Friday, July 27, 2012 2:28 PM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    1

    Its only permits Windows Authentication. This means that the account which launches the SSIS Package (your interactive account, SQL Agent service account, proxy account) is the one that logs in to run DQS work.

    You cannot specify SQL authentication for DQS. Therefore, you have no options except to set the proxy account for the job which runs the SSIS package.

    Thanks, Jason

    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance