powered by Jive Software

Can't connect to MSSQL with domain user credentials

Openfire 3.8.1 on Linux

I can’t connect to MSSQL 2012 database with domain user credentials. Sql Server

authentication works fine.

My config (user data changed for this entry):

org.jivesoftware.database.DefaultConnectionProvider

net.sourceforge.jtds.jdbc.Driver

jdbc:jtds:sqlserver://IP/db_name;appName=jive

DOMAIN\user

omain_user_password

select 1

false

false

5

25

1.0

true

Log

2013.03.22 14:20:58 org.jivesoftware.database.DbConnectionManager - Unable to get a

connection from the database pool (attempt 10 out of 10).

java.sql.SQLException: Login failed for user ‘DOMAIN\user’.

at

net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)

at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:602)

at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:344)

at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)

at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at

org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConne ctionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at

org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211)

at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at

org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnect ionProvider.java:86)

at

org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager. java:124)

at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:753)

at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:480)

at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:212)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance0(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at

org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:113)

at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:58)

2013.03.22 14:20:58 org.jivesoftware.openfire.XMPPServer - Server halted

I did try installing FreeTDS on my linux machine and after configuring I could

connect to my sql server with domain credentials

working example

tsql -S IP_address -U ‘DOMAIN\user’ -P password

but I had to change for FreeTDS config parametr “tds version”. From default 4.2 to 8.0

so in freetds.conf tds version = 8.0 and we have working connection for domain user.

I don’t know any configuration in Openfire about FreeTDS, maybe there is some problem?