{tocify} $title={Table of Contents}
Please check your account info and/or permissions and try again. Details: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)
That's it, now it was able to connect .
Error/Issue:
While creating a SQL API Connection in a Logic app, got following notification
The error says that : The server was not found or was not accessible.
However as can be seen in above image, I had provided the name of server against SQL server name.
Why it happened
It was due to missing FQDN.
Fully Qualified Domain Names (FQDN) are complete addresses of websites, computers and other entities that can be accessed on the Internet.
The FQDN consists of two parts: the hostname and the domain name
A fully qualified domain name is always written in this format: [hostname]. [domain]. [tld].
For example, a mail server on the example.com domain may use the FQDN mail.example.com
And the property SQL server name in above image although it says name but it actually expects the address for your SQL server(the value in FQDN format).
However only the host part of FQDN was provided.
Thus it was not able to find the server.
What to do
Provide the full address(FQDN)
That's it, now it was able to connect .
If you have questions or suggestions, feel free to do in comments section below !!!
Knowledge Sharing is Caring !!!!!!
Related Post
- Getting Started with Logic Apps - Enterprise Application Integration
- Getting Started with Logic Apps - EDI X12 Fundamentals
- Getting Started with Logic Apps - What happened to the Request?
- Getting Started with Logic Apps - Fundamentals
- Getting Started with Logic Apps - AS2
- Getting Started with Logic Apps - XML to EDI X12
- The provided map definition is not valid
- Required property 'content' expects a value but got null. Path ''.'
- Getting Started with Logic Apps - File Routing
- Installing and Configuring On Premises Data Gateway - By adding user to Active Directory
- Inserting data in On Premises SQL Database using Logic Apps
- Inserting Multiple Records In On Prem SQL Using Logic App
- Check your request parameters to make sure the Path “” exists on your file system
