Integrated authentication on Sql Server

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

1 answer

1 accepted

1 vote
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.

Thanks for that! I've updated our documentation.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Thursday in Agile

How Scrum works? It starts with training and education

To answer “How scrum works,” most of the teams I've worked with first addressed the question: “where to start?”  That question applies to both implementation and improvements on the Scrum framew...

183 views 3 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you