Azure app service (ASE) SQL Azure connection
I have an app service located inside the app service environment(ASE). I have a virtual network which I have put ASE into the subnet in the Vnet.
What I am trying to do is, I am trying to connect SQL Azure endpoint which is not in Vnet or my azure tenant. ASE has an outbound IP address and when I try to tcpping to azure SQL endpoint, it is responding me without any issue.
The problem is when I try to connect SQL endpoint inside the application, I am getting "Cannot open server" error. It usually happens when there is firewall in SQL Azure endpoint. I have checked log analytics (in target SQL endpoint) and saw my app connection is blocked but when I check the client IP, it shows me private IP of ASE. I really don't understand how it can be possible? I would see my public ip in there, since ASE is external ASE.
Do you have any idea how that can be possible?
If you have enabled the virtual network service endpoint for Microsoft.Sql in the ASE subnet, When you connect to your Azure SQL server with service endpoints turned on, the source IP of SQL connections will switch to the private IP space of your VNet.
If so, you need to allow the given VNet/subnet by specifying it in the VNet firewall rules of the SQL server. If you do not want to use a virtual network service endpoint, you can whitelist the outbound IP address of the application in the firewall of the SQL server.
- Convert hour to 12 hr format after extracting 'hour' using DatePart(hour,Datetime)
- SQL Management Studio can't drag table / object from Explorer to Query Editor
- How can I put a where condition on a SqLite view statement?
- Get 2 Digit Number For The Month
- Set a column unique without being the primary key
- How to simulate a deadlock in SQL Server in a single process?
- "The big SQL RegEx": How do I RegEx split a SQL query?
- Determine column to insert into based on content
- Can a 4 column address be merged into a 2 columns address with a SELECT statement?
- How to write a "recursive update"?
- hierarchical query in Oracle
- How to Select all Columns from a Table for a Record - but to exclude a Column if all entries for that Record in said Column are null?
- Find patients admitted multiple times for the same primary diagnosis in SQL
- Updating SQL Server records with replace
- Export data from dynamic XML hierarchy in SQL Server
- How to resolve this error Ora-25137 "Data Value Out of range" in oracle
- Writing a SQL Query with multiple Where statements
- VBA - Convert a few numeric cells as text
- MySql: unknown column id in 'field list'
- SQL Server TDS protocol response problem when calling a stored procedure
- Can Postgres use the foreign key (between two tables) as the "ON" clause when LEFT JOINing them?
- Count matching value in two columns in SQL
- Why UNION and UNION ALL don't work in my code?
- Could not drop object 'dbo.Table1' because it is referenced by a FOREIGN KEY constraint
- PostgreSQL: Give all permissions to a user on a PostgreSQL database
- How does group by works in sequelize?
- Cursor bug when editing sql file
- Add a given value from a column based on the value from another column
- How can I make SQL case sensitive string comparison on MySQL?
- How to fix "java.sql.SQLException: Can't call commit when autocommit=true"