Greetings and Happy March!
We are trying to use SQL Data Compare (V16) in an Azure pipeline and getting this error for connecting to target database.
For context, we are using DbaTools.io to create a clone of the production database and it sets the owner of the cloned db as the service account. It also adds a user to the db as the service account and gives it db_owner permissions.
##[error]Error: Cannot open database "DBATestPRDBld" requested by the login. The login
failed. Login failed for user '[DomanName]\svc.account'.
Tried using the flag /ad2 with no luck. Any advice would be appreciated.
Greetings and Happy March!
We are trying to use SQL Data Compare (V16) in an Azure pipeline and getting this error for connecting to target database.
For context, we are using DbaTools.io to create a clone of the production database and it sets the owner of the cloned db as the service account. It also adds a user to the db as the service account and gives it db_owner permissions.
##[error]Error: Cannot open database "DBATestPRDBld" requested by the login. The login
failed. Login failed for user '[DomanName]\svc.account'.
Tried using the flag /ad2 with no luck. Any advice would be appreciated.