SQL-Server with Integrated Security? #2212

minic · 1 decade ago

Hi,

we would like to use M$ SQL-Server as the database to run QB with.

We set up SQL-Server in "Windows authentication mode", so we need to use "Integrated Security=True" in the connection string.

If possible, we try to avoid saving passwords in plain text files.

So, the config should look something like this:

hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.connection.driver_class=net.sourceforge.jtds.jdbc.Driver
hibernate.connection.url=jdbc:jtds:sqlserver://localhost:1433;namedPipe=true;Integrated Security=True
#hibernate.connection.username=
#hibernate.connection.password=

This config fails:

Caused by: java.io.IOException: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

According to "http://jtds.sourceforge.net/faq.html" the driver does not support "Integrated Security" and if we use "com.microsoft.sqlserver.jdbc.SQLServerDriver" we get a "ClassNotFound"-Exception.

Is there any way to use SQL-Server in "Windows authentication mode"?

Thanks for your help,
Michael

replies 3
views 3928
stars 0

robinshen ADMIN · 1 decade ago

Please put microsoft jdbc driver jar into folder "plugins/com.pmease.quickbuild/libs" and if there are any dlls, please put them into "bin" folder.

minic · 1 decade ago

Thanks for the info.
It's working now.

We had to use "sqljdbc4.jar", since we've installed JDK 1.7.
You can download it from: "http://msdn.microsoft.com/en-us/data/aa937724.aspx".

Copy "sqljdbc4.jar" to "C:\QuickBuild\plugins\com.pmease.quickbuild.libs\" and
"...\auth\x86 | x64\sqljdbc_auth.dll" to "c:\QuickBuild\bin\".

Only drawback is: MS JDBC driver does not support NamedPipes, it's working over TCP/IP.

Connection settings:

# Use Microsoft JDBC driver with IntegratedSecurity over TCP/IP (NamedPipes are not supported).
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver
hibernate.connection.url=jdbc:sqlserver://localhost:1433;IntegratedSecurity=True
#hibernate.connection.username=
#hibernate.connection.password=

Greetings,
Michael

robinshen ADMIN · 1 decade ago

Thanks for sharing.