Help needed: BitBucket setup, External MS Sql Server Connection issue

[Roger Farley]

The JDBC error is :

Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user....

I have tested the user separately and it works fine, but the user is an AD account as my company disallows Sql Server accounts except for extreme cases and has a very aggressive password change policy. So, SS is setup in mixed login mode.

I am hoping that BitBucket is not restricted to SS user accounts.

TIA...

[Mikael Sandberg · Accepted solution]

Hi Roger,

Welcome to the Atlassian Community.

Bitbucket does support Windows Authentication Mode for SQL Server, but you have to manually configure it, see Use Integrated Authentication or 'Windows Authentication Mode' (Optional). Hopefully that helps.

[Roger Farley]

Thanks Mikael, I will try that. I have not been able to install it at all, so configuring it for sql server and then changing it does not look good.

Can I setup to use the local "demo" db and then re-configure to point to my external sql server with AD after that setup?

[Mikael Sandberg]

From what I understand just glancing over the guide you can set everything up using SQL Server by temporarily enable SS user account just to get by the GUI setup, and then edit the configuration to use an AD account instead. Setting it up a demo db does not seem to be an option since you would not be able to migrate it over the the SQL Server db. The initial setup is populating all the tables that Bitbucket needs, not sure it that can be done manually, I will have to check that.

[Mikael Sandberg]

I was not able to find a way to manually initiate the db, so your only option would be to temporarily allow SS authentication, and then change the configuration to use an AD account.

[Roger Farley]

I wanted to add...

I did finally get this to work, but what a royal pain. What the instructions DON'T say is:

-the setup creates an Atlassian local account that is used by the two services and give it exclusive ownership and full control of the BITBUCKET_HOME directory.

-I had to use the AD account that we had created for the BB to forcibly take ownership and give it Full Control.

-The instructions didn't say, but I had to use the new AD account for both services.

-I still could not get it to work until I inadvertently went back to the /setup url. It began initializing all the little bits and pieces and THEN it all starting working. Simply stopping/starting the two Windows Services were not enough. And the Start_Service.bat never would start the two services. I had to do that manually with each attempt.

[Mikael Sandberg]

I will see what I can do to get Atlassian to take a look at this and see if the documentation needs to be updated.