Hi @Satish Kumar T , as discussed over the call, to resolve this issue we need to make below changes:
- Change the compatibility level of Azure SQL database to 130 at Azure database level
- Change the target platform of Database Project to Microsoft Azure SQL Server V12
Glad it worked out for you.
----------
Please select 'Accept Answer' if this helped you as it could help other community members looking for similar query.
Hi @AnuragSharma-MSFT , Thanks for your reply, i have followed same steps that was mentioned in the above link, but will try again. I feel like there is some issue with Task#2, step#7Azure Connection Type: Azure Resource Manager creation at my end. Can you provide more details on creating new Azure Resource Manager.
Whether I give correct or incorrect credentials, I am getting same error.
@AnuragSharma-MSFT , The link you have provided is making use of Azure DevOps pipelines, whereas I am making use of TFS 2017 for CI/CD Pipelines. Also I am using Visual Studio 2017 and SSMS V17.1.
Can we have a quick call to nail down the issue as I am struggling on same issue from past one week.
Hi @Satish Kumar T , thanks for reverting back. Can you please tell me if you are using on-premise TFS or VSTS? If you could provide few screenshots for the pipeline you created and the error you get while configuring the database deployment task, it would be helpful. Also which SQL Server version you are using?
Meanwhile, I will try to reproduce the same on TFS (based on your inputs) and then we can connect to have resolution.
Sign in to comment