none
Connection to SQL Server RRS feed

  • Question

  • Hi Experts,

    I have created a SQL PaaS database and implied the azure database firewall for it , restricting access to the PaaS database to certain subsets say the database can be accessed only from the subnet 10.x.x.x/28.

    This database has been created through rest API which is executed through a server say serv001 outside the subnet 10.x.x.x/28. Will I be able to connect to the SQL Server through serv001 and run a SQL Query through rest API

    Thanks

    Thursday, November 14, 2019 12:24 PM

All replies

  • hi VG2014,

    Are you querying this DB from azure? also is the allow azure services.... enabled on the firewall side? how did you restrict the firewall connections? using vnets?

    Thursday, November 14, 2019 1:34 PM
  • Hi,

    You can't query/connect to the Azure SQL outside the IPs you have configured under firewall. You have to configure the IP from which you want to access the Azure SQL.

    Regards,
    Eshwar


    -Malleswar

    Thursday, November 14, 2019 2:06 PM
  • Thanks Gonzalo. The firewall restriction is through the database firewall feature of SQL PaaS.

    The Allow feature is no in the database firewall

    Thursday, November 14, 2019 2:25 PM
  • Thanks Eshwar.

    Maybe not the right query , but is what you stated also applicable for Rest API and wit database firewall of SQL PaaS

    Thursday, November 14, 2019 2:26 PM
  • Yes, but how are you restricting the connections? using the IPs only or also you enable Vnet integration?
    Thursday, November 14, 2019 2:43 PM
  • Yes, it is applicable for all including REST API, Web app, and from SSMS too.



    -Malleswar

    Friday, November 15, 2019 3:29 PM
  • Just checking in to see if the above answer(s) helped.

     

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further query do let us know.

    Thursday, November 21, 2019 3:03 AM
    Moderator