Integrated authentication on Sql Server

Question

Hi,

I followed the (optional) instructions from https://confluence.atlassian.com/display/STASH/Connecting+Stash+to+SQL+Server for connecting to stash-(sql2008 db) using integrated authentication and can't seem to get it to stop attempting to connect with the username and password in the stash-config.properties file.

This is the error I'm getting in the log:

Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:sqlserver://server\instance:59993;integratedAuthentication=true;databaseName=Stash, username = StashUser. Terminating connection pool. Original Exception: ------
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'StashUser'. ClientConnectionId:42aee675-fd0d-489e-af73-574ae5c304fa

The instructions say that the username & password have to stay in the config file but integratedAuthentication=true seems to be ignored.

Thanks again for any help,

Greg

gkennedy1 · Accepted Answer

integratedAuthentication is the wrong parameter name. It should be integratedSecurity=true - http://msdn.microsoft.com/en-us/library/ms378428.aspx#Connectingintegrated

Hope this helps someone.