Reputation: 131
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