Linked Server connection between Azure and On premise

Babawale Dawodu 85 Reputation points
2023-11-03T10:15:37.51+00:00

I tried to create a Linked Server between On Premise SQL database and Azure SQL database using the Azure database remote login credentials as security context.

I got an error message "Named Pipes Provider: Could not open a connection to SQL Server [53]. OLE DB provider "MSOLEDBSQL" for linked server ''AZURE SERVER'' returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible."

I'm connected to my company's vpn while doing this remotely and I have access to both Instances vis SSMS. Is there anything I need to be aware off, maybe port or firewall settings to link both servers? Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,082 questions
{count} votes