Custom skill integration

Question

I have a requirement to crawl an Azure SQL server from Azure AI search. The SQL server exists in different VNET and I have created a Shared Private Link to connect. The Indexer works fine without any problem.

As soon as I add a custom webapi skill the indexer starts complaining with an error

Cannot open server 'sqls-XXX-dev' requested by the login. Client with IP address '51.XXX.XXX.140' is not allowed to access the server.

Can anyone kindly explain what am I doing wrong?

Integrate Custom Skill with SQL Server with Shared Private Access. The SQL server has not public IP enabled.

Jaya Shankar G S · Accepted Answer · 2024-05-27 08:55:46Z

0

You get this error because the SQL server does not have a public IP enabled. You also mentioned that it works without a custom web API skill. However, once you add the skill, it raises the error, meaning the IP address of the function you are using has not been added to the SQL server network firewall rules.

To resolve this issue, you need to add the IP address to the firewall rules or create a firewall rule for this IP address or address range.

enter image description here

Also, check this documentation for Azure Private Link.

answered May 27, 2024 at 8:55

Jaya Shankar G S

8,6182 gold badges6 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jaya Shankar G S Over a year ago

@Som Check if above provided solution works for you? Let me know if I can be helpful here anyway with further input?

Collectives™ on Stack Overflow

Custom skill integration

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related