sqljdbc_auth.dll reference in a dispatcher

[former_member2987]

Hi Folks,

Working with IDM 7.2 SP9, SQL Server 2008 R2 on a Windows 2008 Server.

Got The database, NW, and IDM installed, Installed Java 6 update 41.

When I test the dispatcher, I get the message: WARNING: Failed to load the sqljdbc_auth.dll

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

I don't seem to remember turnin anything likke this on.

Any ideas on this one?

Thanks,

Matt

[former_member2987 · Accepted solution]

BTW, I downloaded the sqljdbc_auth.dll and tried it in my PATH and in my SQL Driver directory. (32 and 64 bit)

[ChrisPS · Accepted solution]

Hi Matt - maybe this will help

Building the Connection URL

there are no reports of this issue in general with the dispatcher so it looks like some local issue with the driver and the JVM/Dispatcher here.

Chris

[former_member2987 · Accepted solution]

Thanks, Chris.  I'll continue to investigate.  Fortunately it's just a lab system so I might just wipe it and start fresh.

Matt

[Former Member · Accepted solution]

Also check the DB security settings. It might not allow SQL Server authentication and then it will try to authenticate against Windows and that requires the jar file you mentioned.

Br,

Per Christian (I made gold before my account is closed!)

[former_member2987 · Accepted solution]

Thanks Chris (and congrats!)

Pretty sure I checked, but I will recheck!

[former_member2987 · Accepted solution]

Found it.  There was a reference in the JDBC connection string, which I did not see when examining the PROP and BAT files since the connection string is encrypted.

Checked the MMC and there it was!

Once I got rid of the integratedSecurity section and added my password, the dispatcher started right up!

Not sure how it got there, but I'm glad it's gone.

Matt

[Former Member · Accepted solution]

You might have accidentally clicked the wrong URL type in the wizard 🙂

-

Chris

[former_member2987 · Accepted solution]

What, me make a typo?  Certainly you jest!