The server was not found or was not accessible

{tocify} $title={Table of Contents}


While creating a SQL API Connection in  a logic app, got following notification

The server was not found

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.)

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 domain may use the FQDN

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)

Provide FQDN against SQL Server Name

That's it, now it was able to connect .

If you have questions or suggestions, feel free to do in comments section below !!!

Do share if you find this helpful .......
                          Knowledge Sharing is Caring !!!!!!

Post a Comment

If you have any suggestions or questions or want to share something then please drop a comment

Previous Post Next Post