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

Accepted Answer
1 vote

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
Posted Friday in Europe

Venue Needed! 23rd October

Hey Everyone! Unfortunately, the venue that was hosting us on the 23rd has pulled out so we're looking for a new venue.    If anyone would have a room free that we could use on the ev...

41 views 1 0
View post

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