SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,149 questions
How to fix “error(0) invalid linked service reference name: keyvault” Error in Purview connecting to on prem Sql server using SHIR
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 11%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
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.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,121 Reputation points Microsoft Employee2024-04-19T16:46:00.48+00:00 Hello Sangeetha Menon,
Welcome to the Microsoft Q&A forum.
Can you please follow the below Microsoft document and see if you have met the pre-requisites:
https://learn.microsoft.com/en-us/purview/register-scan-on-premises-sql-server
<copied form the document>
- An Azure account with an active subscription. Create an account for free.
- An active Microsoft Purview account.
- You'll need to be a Data Source Administrator and Data Reader to register a source and manage it in the Microsoft Purview governance portal. See our Microsoft Purview Permissions page for details.
- Set up the latest self-hosted integration runtime. For more information, see the create and configure a self-hosted integration runtime guide.
regarding the invalid linked service error, please check that the key vault connection is correctly established.
-
Sangeetha Menon 0 Reputation points
2024-04-21T21:07:34.6733333+00:00 Hi BhargavaGunnam,
The key vault connection works with Azure integration runtime scans for azure data sources. This error is encountered while trying to scan using SHIR. I have verified all the pre-requisites mentioned in the document, I can also see the key vault secret is accessible to the on prem server using”getazkeyvaultsecret”. Is there any other checks to be done?
-
ZoeHui-MSFT 38,621 Reputation points2024-04-22T06:47:40.84+00:00 Hello Sangeetha Menon,
I'd like suggest that you may raise a ticket to Purview team to get professional advice to solve the issue.
Sign in to comment
Sign in to answer