How to fix “error(0) invalid linked service reference name: keyvault” Error in Purview connecting to on prem Sql server using SHIR

Sangeetha Menon 0 Reputation points

Im trying to run a Purview scan for an on-prem Sql-server database. I have created key vault for the credential secret and installed a Self hosted integration runtime in the on prem machine, which is running. When i try to test-connection in Purview using the key vault secret ( windows/ SQL authentication) , the connection fails with the error(0) invalid linked service reference. Name: key vault name.

Login through SSMS using windows authentication gives a domain trust issue error , but im able to connect to the Database using the SQL authentication.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,870 questions
Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
960 questions
{count} votes