Connection to SQL Database in Azure

Question

I am trying to set up a simple web site using Azure. My program simply links to a database and lists the contents.
I am getting an error message which says that it can't connect the User to the database and provides an error schedule as follows :

SqlException: Login failed for user 'RArch'.
Microsoft.Data.ProviderBase.DbConnectionPool.CheckPoolBlockingPeriod(Exception e)

I can access the remote db from SQL Server management studio and I can run the program locally and access the database remotely.

I would think from this that the Connection string is correct and the user details are correct.

I don't understand the DbConnectionPool issue - it is beyond my current knowledge level.

Can anyone assist with sorting this out. thanks.

Answer 1

Hi @Reid Archibald Thanks for sharing the screenshot, I am attaching the sample code which is working for AAD connection.
I have added the connection string to your code and I hope you are using the correct dependency

Here is the connection string
string ConnectionString = @"Server=****.database.windows.net; Authentication=Active Directory Default; Database=mytestdb1;";

        using (SqlConnection conn = new SqlConnection(ConnectionString))  
        {  
            conn.Open();  
        }  

Document for reference

Sample code192368-program.txt

Please let me know if the information is helpful.

Regards
Geetha

Answer 2

Please try to set Connection Timeout=60. Other users have reported this as solution.