Azure DevOps Server could not connect to the database

Question

Azure DevOps Server could not connect to the database

Abdul Aziz Farooqi 0

May 10, 2023, 5:39 AM

{"$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}

SSingh-MSFT 16,281 Reputation points Moderator

May 11, 2023, 7:49 AM

Hi Abdul Aziz Farooqi •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Abdul Aziz Farooqi 0 Reputation points

May 12, 2023, 6:29 AM
Hi,

I uninstall it and install it again.

This happen when we tried to install self-hosted agent on the server to automate pipelines. It is standalone installation with SQL server on same machine.

Initially there where so many thing came to resolve but unfortunately none of them work i.e.

we exclude folder as recommended from antivirus , in the end we disabled antivirus - didnt work.

Re-configure it with existing db - didnt work.

Re-start server and check updated --didnt work

SQL is in the Same machine and through SSMS login with the admin user is working --didnt work

Add another domain user as admin and give permission didn't work.

Change app pool identity with other account.

No Events in Event Manager
SSingh-MSFT 16,281 Reputation points Moderator

May 15, 2023, 3:25 AM

Hi Abdul Aziz Farooqi •,

If the issue is still not solved, I would recommend you to raise request in Azure DevOps forum as in Q&A we do not address Azure DevOps questions currently.

Thanks

3 answers

Your answer

SSingh-MSFT 16,281 Reputation points Moderator

May 11, 2023, 7:49 AM

Hi Abdul Aziz Farooqi •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Abdul Aziz Farooqi 0 Reputation points

May 12, 2023, 6:29 AM

Hi,

I uninstall it and install it again.

This happen when we tried to install self-hosted agent on the server to automate pipelines. It is standalone installation with SQL server on same machine.

Initially there where so many thing came to resolve but unfortunately none of them work i.e.

we exclude folder as recommended from antivirus , in the end we disabled antivirus - didnt work.

Re-configure it with existing db - didnt work.

Re-start server and check updated --didnt work

SQL is in the Same machine and through SSMS login with the admin user is working --didnt work

Add another domain user as admin and give permission didn't work.

Change app pool identity with other account.

No Events in Event Manager
SSingh-MSFT 16,281 Reputation points Moderator

May 15, 2023, 3:25 AM

Hi Abdul Aziz Farooqi •,

If the issue is still not solved, I would recommend you to raise request in Azure DevOps forum as in Q&A we do not address Azure DevOps questions currently.

Thanks

Answer 1

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.

Answer 2

Rohit Vishwakarma 0

Sep 26, 2023, 8:00 AM

Capture

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

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.

Share via

Azure DevOps Server could not connect to the database

3 answers

Your answer