DLM Automation
MichaelM
Posts: 2 New member
Hi,
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.
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.
Tagged:
Answers
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.
DevOps Mentor and Coach
Director of DLM Consultants
Creator of Speaking Mentors
Microsoft Data Platform MVP
Friend of Redgate
Twitter / LinkedIn
Thanks for response. Well, on my Bamboo agent host I have MS SQL Express 2014 installed and LocalDB is available (see screen,
Do you want me to share Bamboo DLM Automation Build job log?
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com