Microsoft Security | Microsoft Purview
A unified data governance solution that helps manage, protect, and discover data across your organization
![](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(176, 46%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Facing similar issue...what was the solution?
Azure purview -On prime sql server configuration
![](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(150.4, 11%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
kavitha c
16
Reputation points
How to configure on prime sql server in azure purview ?
Below steps i have followed but still getting an error as "failed to connect to sqlserver"
1.Installed SQL server 2019 in my machine then created SQL authentication
2.Create secret using key vault
3.Enabled Key vault connection in purview
4.Register the on prime sql server in data map--> sources
5. Finally tested the connection & it failed with an error as "Failed to connect to sql serverDB"
Could you please check and confirm whether the steps are correct or not?
Microsoft Security | Microsoft Purview
{count} votes
-
kavitha c 16 Reputation points
2022-02-10T09:15:51.16+00:00 Hi, I have a problem with on-premises scan using Azure Purview. I have installed self hosted integration runtime (and Purview is able to list all object from configured database) but facing a problem when trying to scan configured database.
Error description:"Internal system error. Please contact support with correlationId:fa5c6376-0d07-4689-9243-364fbcb7b5c8 System Error, contact support: (119) System error while attempting to launch datascan process. ActivityId: 57ea7327-6fce-4bce-aa00-a2f096746519"
-
![](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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,822 Reputation points Microsoft Employee Moderator2022-02-11T00:59:18.673+00:00 Hello @kavitha c ,
Thanks for the question and using MS Q&A platform.
I see 2 different asks in this question
- First you have mentioned that your test connection fails with error:
Failed to connect to sql serverDB - In the second post you have mentioned that
Purview is able to list all object from configured databasebut facing a problem when trying to scan the database.
Could you please help clarify what is the current problem? Is it while testing the connection or was your test connection successful and the issue is only while scanning your SQL Database? Are your trying to scan all tables under that database or a specific set of items?
- First you have mentioned that your test connection fails with error:
-
KranthiPakala-MSFT 46,822 Reputation points Microsoft Employee Moderator
2022-02-17T01:35:36.797+00:00 Hello @kavitha c ,
Following up to see if you still need assistance on this query. In case if you have already found a solution, please do consider sharing it here with community, as it would be helpful for others reading this thread. In case if you still need assistance, please clarify the problem as called out in my previous post.
Thank you
-
![](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(272, 30%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kavitha 21 Reputation points2022-04-04T11:12:59.52+00:00 Test connection successful and the issue is only while scanning SQL Database. Could you please provide a solution?
"Internal system error. Please contact support with correlationId:fa5c6376-0d07-4689-9243-364fbcb7b5c8 System Error, contact support: (119) System error while attempting to launch datascan process. ActivityId: 57ea7327-6fce-4bce-aa00-a2f096746519" -
KranthiPakala-MSFT 46,822 Reputation points Microsoft Employee Moderator
2022-04-06T17:54:31.277+00:00 Hi @Kavitha ,
It could be related to firewall issue but not sure at this moment. As mentioned in the error message, would recommend to file a support ticket for further investigation on this issue. If you don't have a support plan, please do let me know here.
Sign in to comment