Imanami Community

I saw this post (http://community.imanami.com/forums/post/148.aspx) about DTM's inability to support Windows auth against SQL.  I also found this in the online help:  Enter the user name required to access the SQL server. }}--> }}-->To use Windows authentication you must manually create your connection string in the Advanced provider dialog box.

I went to what I believe is the Advanced provider dialog box, but can't figure out where to place the connection string.  Tried making an entry called "ConnectionString" but it didn't work.

Is there a way to have the job use the credentials within it to pass the Windows credentials to SQL, or should I just request a local SQL account and skip Windows auth?

Thanks!

Hello bbrazell,

Adding the Windows authentication information will not change the behavior or the issue that has been reported in the Imanami KB article that you mentioned priort to this.  However, I would recommend that you request a SQL account to use in order to connect DTM to the SQL database to work around the issue reported in the Imanami KB article.