Azure DevOps Server could not connect to the database

Question

{"$id":"1","innerException":null,"message":"TF246017: Azure DevOps Server could not connect to the database. Verify that the instance is specified correctly, that the server that is hosting the database is operational, and that network problems are not blocking communication with the server.","typeName":"Microsoft.TeamFoundation.Framework.Server.DatabaseConnectionException, Microsoft.TeamFoundation.Framework.Server","typeKey":"DatabaseConnectionException","errorCode":0,"eventId":3008}

Answer 1

Hi Abdul Aziz Farooqi •,

Welcome to Microsoft Q&A forum for Azure.

As I understand, you are facing issue in connection of Azure DevOps to Azure SQL Database.

Please let me know if my understanding is correct.

The error could be due to the following reasons if related to Database:

1). Please check if the connection string used is correct.

2). Check you have required permissions.

3). Make sure the Database is online and Login credentials is correct.

4). Check if the network settings(firewall) configuration is allowing connection establishment.

If above pointers looks fine, and still connection has issue, I would recommend you to raise request in Azure DevOps forum as in Q&A we do not address Azure DevOps questions currently.

Hope this information helps. Let me know the result.

Thank you.

Answer 2

Hi Team,

Please check SQL server configuration manager alias, I have shown the example on the image please remove that aliases and restart SQL Services and azure Services, I am sure it will work,

Answer 3

Check whether the account under which the connection is being made has access to the database.

Usually AzureDevOps uses Integrated Security (Windows Authentication).

You can see the account AzureDevOps uses to connect to SQL Server in AzureDevOps Adminstration Console under Application Tier settings by clicking "Change Account".

If the account is, say, "NT AUTHORITY\LOCAL SERVICE", check whether your SQL Server Instance has this user in its Security/Logins.

Also, make sure, the account has access to AzureDevOps_Configuration database.