Connecting a domain user to MSSQL Instance with BitBucket on Linux

Question

Hi there,

I installed BitBucket 5.14 on Linux and I'm trying to configure it now via the browser. I have a Windows-domain user to connect to a MSSQL-Cluster named MSSQL\INSTANCE\.

The error message is

Login failed for user 'domain-user'. ClientConnectionId:7a4bb350-69f1-4385-8068-eb8f69781783
	com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
	com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:279)
	com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:99)

I remember nearly the same problems installing and configuering Jira with a domain user.... what's it like with BitBucket? How do I tell BitBucket and MSSQL to use domain users?

Thx in advance

Tim

Andy Heinzer · Answer

Hi Tim,

I believe the answers to your follow up questions are actually explained inside the first setup document that Victor directed to you.  From that document:

Use Integrated Authentication or 'Windows Authentication Mode' (Optional)

Windows authentication is only available for Bitbucket Server instances running on Windows. It cannot be used on Linux because Microsoft does not provide shared objects for it. You will either need to run Bitbucket Server on Windows, allowing you to use Windows security, or you will need to enable mixed-mode authentication for SQL Server if you are running Bitbucket Server on Linux. Unfortunately, there are no other options at this time.

This is noted in the documentation https://confluence.atlassian.com/bitbucketserver/connecting-bitbucket-server-to-sql-server-776640385.html

Since you are using a Linux environment for Bitbucket installation, you actually won't be able to use the Integrated Windows Authentication here.  Which means you would need to confirm that your MSSQL server is running in mixed-mode authentication.  This settings allows both Windows and SQL user accounts to login.  In your case, for Linux servers, Bitbucket will need to use a SQL user account.  Meaning your Windows domain user account won't be able to login from a Linux server.

If your database can't be switched into mixed-mode, perhaps you can install Bitbucket to a Windows server instead in order to take advantage of the Microsoft libraries needed to handle this kind of authentication.

Tim Wisian · Answer

... and if BitBucket is not able to handle MSSQL-Instances from the installationprocess

https://confluence.atlassian.com/bitbucketserverkb/connecting-to-named-instances-in-sql-server-from-bitbucket-server-779171681.html

How do I connect with a windows doamin user?

Tim Wisian · Answer

Hi,

my collegues checked and double checked.

The problem still persists.

I have two questions :

* How do I tell the BitBucket DB Connectiondialogue to use a MSSQL-Server with an Instance?
* How do I tell the BitBucket DB Connectionsdialogue to use an Windows domain user to log on the MSSQL DB?