Hi @Somdeep Niyogi (external) Thanks for bringing this our attention.
This might be related to firewall rules that are blocking the IP address of your custom web API skill from accessing the SQL server. When did you start facing this issue?
The error message means that the client’s IP address is not allowed to access the server, which is a common issue when the server’s firewall settings do not include the client’s IP address in the allowed list.
To resolve this, you can consider the following steps:
- Use the Azure portal to create a server-level firewall rule that allows the IP address of your custom web API skill to access the SQL server. You can do this by navigating to the SQL server’s settings in the Azure portal, then going to the “Firewalls and virtual networks” section.
- Alternatively, you can use Transact-SQL commands such as
sp_set_firewall_rule
on the master database to create a firewall rule for the IP address or address range of your custom web API skill. This can be done by connecting to the master database of your SQL server and executing the appropriate Transact-SQL command.
Hope that helps.
Grace