Azure Web App Error, No such host is known

Question

When Running the web App locally there is no issue to connect to the DB,

after deploying the Web App to Azure the DB(Also Azure) connection attempt throws the following error:

[Win32Exception (0x80004005): No such host is known]

[SqlException (0x80131904): 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 DB FW Settings: Allow access to Azure services: is set ON

Any Idea on how I can trouble shoot/ Resolve this issue?

Answer 1

This could be caused by pasting your connection string in after Data Source=

connectionString="Data Source=Server=...."

Instead, it should be

connectionString="Server=...."