I am confugring Bamboo and Fisheye to use a Microsoft SQL database server. Our DBAs would like us to use integrated authentication instead of SQL authentication. I was able to configure this for Stash, but not for Bamboo or Fisheye. Has anyone been able to configure these apps for integrated authentication?
Hi Chris,
Please try the following workaround in a test server:
Bamboo: <properties> <property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property> <property name="hibernate.connection.password"></property> <property name="hibernate.connection.url">jdbc:sqlserver://CONFSERVER:1433;databaseName=Confluence;integratedSecurity=true;</property> <property name="hibernate.connection.username">sa</property> </properties> FishEye: <database type="sqlserver2008"> <connection dialect="com.cenqua.crucible.hibernate.dialects.SQLServer2008UnicodeDialect" driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" jdbcurl="jdbc:sqlserver://localhost:1433;databaseName=fisheye;integratedSecurity=true;" password="" username="sa" maxPoolSize="20" minPoolSize="5" driverSource="user"/> </database>
Change the value mentioned in the above example only. Do not delete other settings in the file.
Update;
For Bamboo 6 at least, the sqljdbc_auth.dll should be placed in <bamboo-install>/bin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did this solution work for you? I am going to attempt this shortly so I am looking for any updated information on this for the most recent Fisheye. Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.