Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Having issues Connecting Bamboo to SQL Server

Michael Castro
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.

Answer
Watch
Like Be the first to like this
690 views

2 answers

1 accepted

0 votes
Answer accepted
Victor Debone
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

View More Comments
Michael Castro
Michael Castro April 11, 2019

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

Like
Victor Debone
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?

Like
Michael Castro
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
Reply
0 votes
Avinash_Mishra
Avinash_Mishra
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
April 25, 2020

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

Reply

Suggest an answer

Log in or Sign up to answer
Bamboo
Bamboo
TAGS
AUG Leaders

Atlassian Community Events

    See all events