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?
Could you ensure that: 1) Remote connections are allowed to the SQL Server. - You did that, so it is OK.
2) Use the full name of the server you are connecting to (myserver.database.windows.net) not something else.
Did you try to connect to it from your local computer using SQL Server Management Studio? If so, and if server authentication is set to SQL Server and Windows Authentication and it works, then please paste the details as David suggested and we will try to troubleshoot (actually, with SQL Azure there is not so much to troubleshoot), or try to ask technical support.
I had the exact same situation:
This happened to me:
No such host is known
I tried many things but at the end I think it solved by itself (maybe it was a cache problem).
Try deleting your web.config using FTP and reuploading it.
I fixed this issue replacing the connection string in my code.
The correct connectionstring for mysql, the port is splited from the host, like:
check it out in: https://www.connectionstrings.com/mysql/
User contributions licensed under CC BY-SA 3.0