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

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in Canada

AUG Lunch Roundtable - August 13 - Highlights

Thanks to everyone who came out today for the lunch AUG - we had some great food and discussion (and ice cream sandwiches to fend off the heat!) The welcome and fun fact was great as well, what an aw...

28 views 1 3
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