Comments
3 comments
-
By default DLM Automation will try to create a database on localDB on the Bamboo agent (whether this is an on prem or cloud agent).
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-2016-express-localdb
If local DB is not installed on your build agent you should provide details for your own SQL instance where DLM Automation will build the database. -
Hi Alex,
Thanks for response. Well, on my Bamboo agent host I have MS SQL Express 2014 installed and LocalDB is available (see screen,
). Now I understand why SQL Profiler shows nothing but it confused me even more.
Do you want me to share Bamboo DLM Automation Build job log?
-
Hi,
When you select the 'RedGate DLM Automation Build' task within Bamboo, are you able to select your MS Express 2014 instance?
LocalDB is a lightweight version of the SQL Server Express Database Engine that is targeted for program development. LocalDB starts on demand and runs in user mode, so there is no complex configuration. Further reading available here:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-2016-express-localdb
https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-mvc-app/working-with-sql?tabs=aspnetcore2x
Does this Internet article answer your question in regards to the "The login already has an account under a different user name" error you are experiencing?
https://dba.stackexchange.com/questions/35225/the-login-already-has-an-account-under-a-different-user-name
Add comment
Please sign in to leave a comment.
I'm quite new with RedGate products and now I have the following issue. I'm trying to use DLM Automation 2.0.26.606 to deploy my database to production with Bamboo 6.0.3. So I've read this (https://documentation.red-gate.com/dlma2/get-started/using-the-add-ons/use-the-bamboo-add-on) and have tried to do it. But when I'm trying to run Redgate DLM Automation Build job in Bamboo (using appropriate GIT branch) with settings "SQL LocalDB (recommended)" I receive the following error: "The login already has an account under a different user name". In my understanding this job should create temp database, pull it from GIT and get ready to deploy. Is it correct? I used SQL profiler and found that this job is not even trying to connect to local MS SQL server. Does "LocalDB" mean local DB engine installed on local server (MS SQL Express 2014 in my case)? If so, maybe I need to specify it in job settings?
If anyone had issues like this I would appreciate any advice. Thanks.