Share via

Access setting for Azure SQL elastic query across same logical server.

Lockyer, Aaron (SGRE COG B MS SYS BSPM) 45 Reputation points
2025-02-20T13:26:51.4633333+00:00

I would like to use elastic queries between two Azure SQL databases on the same logical server.

Unfortunately I am getting an error this is not possible because Public Access has been set to Disabled.

My understanding, is this is normal for accessing remote databases. But are my two databases considered remote if they are on the same logical server? (I know it's not the same as a physical server)

If I want to enable elastic queries, while maintaining high security what needs to be done in this case -
Setup a network or firewall rule for the server to access "itself"?

Azure SQL Database

Answer accepted by question author

Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator
2025-02-20T14:21:49.8933333+00:00

Please refer this doc:

https://techcommunity.microsoft.com/blog/azuredbsupport/resolve-elastic-query-issues-in-azure-sql-database/3583451

User's image

this is needed if both the databases are on the same server

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.