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,