SQL server 2019 to Connect Azure SQl Db

Gupta, Ajay 1 Reputation point
2022-10-20T21:22:41.87+00:00

Hi Team,

We are trying to connect from SQL server 2019 (On-premise) to Azure Sql Db. Trying to create Linkedserver -
but getting Error msg -

Named Pipes Provider: Could not open a connection to SQL Server [53]

Azure SQL Database
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
481 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,186 Reputation points Microsoft Employee
    2022-10-21T06:53:54.817+00:00

    Hi @Gupta, Ajay ,

    Welcome to Microsoft Q&A platform and thanks for using Azure Services.

    Regarding the Error "Named Pipes Provider: Could not open a connection to SQL Server [53]", this might be caused by Production DNS error.

    You may try to fix the issue by providing the server's name on the Data Source connection attribute as follows:

    CONNECTION_NAME = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog="CatalogName";Data Source="Production_Server_Name;""  
    

    Note: To avoid errors on server name you can check it out through SQL Server Management Studio by executing the following T-SQL:

    SELECT @@servername  
    

    Useful similar link which might help: how-do-i-fix-the-error-named-pipes-provider-error-40-could-not-open-a-connec

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of [Q&A Volunteer Moderators][50]
    0 comments No comments