Azure Database connection string from .net Console application. Throwing error
(No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21).)
Installed the ODBC Client and Native CLient also.
Asked
Active
Viewed 645 times
0
Balagurunathan Marimuthu
- 2,927
- 4
- 31
- 44
-
Azure SQL database requires you to setup firewall exceptions. Have you done it? Take a look on https://learn.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure – Ihor Kliushnikov Dec 19 '17 at 07:47
-
Also, try to search the error code itself `DB_E_ERRORSOCCURRED(0x80040E21)`. It leads to https://forums.asp.net/t/1956492.aspx?No+error+message+available+result+code+DB_E_ERRORSOCCURRED+0x80040E21+ or https://stackoverflow.com/questions/23570878/why-connecting-to-an-oledb-is-giving-me-an-connection-error – Ihor Kliushnikov Dec 19 '17 at 07:51
-
We need a bit more info to be able to help you. For instance: how are you connecting to the database? Will it be using an EF model, of are you using plain ADO.NET? And, without showing any credentials, what is the connectionstring you're using? And did you add the client id to the Azure SQL Server firewall rules? Please add relevant code and configuration. – rickvdbosch Dec 19 '17 at 08:21