Gunslinger711
Gunslinger711

Reputation: 131

JDBC Connection using Kerberos Authentication "Login failed for user"

I'm attempting to install an application on a Red Hat Linux machine which needs to connect to a SQL database on a Windows Server. (All username, etc has been sanitized.)

This is command I use to install the software:

sh <installer name>.sh -q -console -varfile <properties name>.properties 

This is, I believe the relevant portion of the properties file:

DatabaseScreen.DatabaseType=Microsoft SQL Server
DatabaseScreen.Hostname=<hostname>
DatabaseScreen.Transport=TCP
DatabaseScreen.DatabaseName=<database name>
DatabaseScreen.Username=<user name>
DatabaseScreen.Password=<password>
database.SqlServer.integratedSecurity=true
database.SqlServer.authenticationScheme=JavaKerberos
database.directory=null
database.SqlServer.namedPipe=false

This is the error I get:

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '<user name>'. ClientConnectionId:1a689cc7-3c48-403c-aa2f-af39614c00a9

Known facts:

Any help is greatly appreciated.

Edit 2: For Thom A's comment: I commented out the username and password as I do want to use integrated security as the user we're using is a domain account user.

For Brad's comment: I've checked the SQL logs, they are showing failed logins from the expected username.

Edit 3: For AlwaysLearning's comment: A few of the sections on this page I checked and they line up with what I have. Some of the logging options I've turned on don't give me anything past what shows up when the program install errors out. Is there anything specific I should be looking for?

Upvotes: -1

Views: 61

Answers (0)

Related Questions