Having issues Connecting Bamboo to SQL Server

Michael Castro April 10, 2019

I am trying to finish setting up Bamboo and have it connect to a SQL Database but I am getting this error?

Error accessing database: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "<Bamboo>" requested by the login. The login failed. ClientConnectionId:9e14b776-7543-4bce-9be9-f3e0ce4f4a9e

I gave the user db_owner and reset the password.

2 answers

1 accepted

0 votes
Answer accepted
Victor Debone
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 11, 2019

Hello @Michael Castro

This error only tells that Bamboo could not access the database. Do you have any firewalls blocking or different ports configured for your MSSQL?

Victor

Michael Castro April 11, 2019

I added an Inbound firewall rule to allow this server to talk to the server with the database.

Victor Debone
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 11, 2019

Did it fix the connection issue?

Michael Castro April 11, 2019

No, we uninstalled it added more memory to the server and started over and for some reason, it worked...

Like Victor Debone likes this
0 votes
Avinash_Mishra April 25, 2020

How did you setup CICD for SQL Server Deployment using Bamboo  ?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events