Active Directory error

VKh · May 7, 2020 5:46PM

Team,
My SCA was working fine until 2 days back. Now all of a sudden it throws the below error when i click on deploy from Visual Studio. Am connecting to Azure SQL and my connection is through AD authentication from visual studio.

Image: https://us.v-cdn.net/6029854/uploads/editor/z6/qi9py797z3t9.jpg

Severity Code Description Project File Line Suppression State

Error An error occurred during script deployment. Output from SQL Server follows.

---------------------------------------------------------------

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : SQL Server Network Interfaces: Error reading adalsql.dll path from registry. Verify that Active Directory Authentication Library for SQL Server is properly installed. For details, please refer to http://go.microsoft.com/fwlink/?LinkID=513072 [2]. .

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection. DatabaseProject C:\DatabaseProject.sqlproj 0

Pete_Ruiz · May 8, 2020 7:04PM

Hello @VKh ,

Thanks for reaching out and sorry that you're having trouble with SQL Change Automation. We haven't come across this error before with SQL Change Automation but from the error it appears that the library called adalsql.dll is either missing or corrupted. Can you check if this ,dll exists in both C:\Windows\SysWOW64 and C:\Windows\System32? If they don't exist, can you try installing the library from the link in the error?

http://go.microsoft.com/fwlink/?LinkID=513072

If they do exists, you might be able to resolve the issue following the troubleshooting steps outlined in the two posts below.

https://stackoverflow.com/questions/45578395/unable-to-load-adalsql-dll-error-when-calling-invoke-sqlcmd

https://winterdom.com/2017/09/27/unable-to-locate-registry-entry-for-adalsql

I hope this helps. Please let me know how you get on or if you have any further questions.

Kind regards,

Pete Ruiz