Community
Products
Bamboo
Questions
Having issues Connecting Bamboo to SQL Server

Having issues Connecting Bamboo to SQL Server

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

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Did it fix the connection issue?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Victor Debone likes this

Reply

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS