An Azure service designed to help simplify, guide, and automate database migrations to Azure.
Database Watcher - Not able to connect and collect data from Azure SQL Database
We have created Database Watcher and trying to connect it with SQL authentication. It doesn't show up any database under dashboard.
Azure Database Migration Service
-
Anonymous
2025-03-20T03:55:49.3566667+00:00 Greetings! As I understand, you're not able to see any database under dashboard.
When a watcher is created, it is not started automatically because additional configuration might be required.
To start a watcher, it must have:
- A data store.
- At least one target.
- Access to the datastore and Targets
- Access to a Key vault is also required if SQL authentication was selected for any target.
- Either private or Public connectivity to targets, key vault (if using SQL authentication), and the data store.
- To use private connectivity, create private end points.
Once a watcher is fully configured, use the Start button on the Overview page to start data collection. In a few minutes, new monitoring data appears in the data store and dashboard. If you don't see new data within five minutes, please follow the below links for possible errors and solutions.
I hope this information helps. Please do let us know if you have any further queries.
-
Mitesh Prajapati • 20 Reputation points
2025-04-04T19:42:19.36+00:00 We aren't able to see any database here.
-
Mitesh Prajapati • 20 Reputation points
2025-04-05T18:13:02.7566667+00:00 @Anonymous can you please help here?
-
Anonymous
2025-04-07T10:03:18.47+00:00 Thank you for reaching out regarding your issue. We are always happy to assist you. Could you confirm whether you followed the steps I provided earlier? If possible, please share the error details, such as the error number or message, as this would help us investigate the problem in greater depth.
-
Mitesh Prajapati • 20 Reputation points
2025-04-07T21:14:24.3866667+00:00 @Anonymous We followed all the steps. We are not getting any error just it doesn't show any database.
-
Mitesh Prajapati • 20 Reputation points
2025-04-07T21:14:32.56+00:00 We followed all the steps. We are not getting any error just it doesn't show any database.
-
Mitesh Prajapati • 20 Reputation points
2025-04-07T21:33:09.87+00:00 We followed all the steps. We are not getting any error just it doesn't show any database.
-
Anonymous
2025-04-08T07:32:38.08+00:00 Thank you for getting back to me with your results.
Kindly request you to please share the details requested over the private message for further investigation.
-
Anonymous
2025-04-09T08:52:17.85+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Anonymous
2025-04-09T10:39:52.48+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Mitesh Prajapati • 20 Reputation points
2025-04-09T20:36:03.95+00:00 How can we provide private responses? as we would not like to share all the details here.
-
Mitesh Prajapati • 20 Reputation points
2025-04-10T15:30:32.22+00:00 @Anonymous Is it possible to setup a call? we can show you all the details over a call.
-
Anonymous
2025-04-10T17:16:50.47+00:00 Thank you for your response.
I have escalated this thread to the next level, and the specialized team is currently investigating the issue. @Pratik Lad will contact you soon with expected solution.
Thank you.
-
Deleted
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
-
PratikLad • 1,680 Reputation points • Microsoft External Staff • Moderator
2025-04-15T09:16:43.23+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
PratikLad • 1,680 Reputation points • Microsoft External Staff • Moderator
2025-04-16T08:48:03.76+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Mitesh Prajapati • 20 Reputation points
2025-04-16T12:28:27.8533333+00:00 Hi @PratikLad It did not work for us after following all the exact steps provided. would it be better to schedule a call to discuss this?
-
Diogo Lopez • 0 Reputation points
2025-06-10T15:44:25.73+00:00 I'm having the same problem to collect data of Azure SQL databases. Those are things I've checked:
- Watcher is running.
- Watcher has access to the data store (as Admin).
- Data Explorer cluster is running.
- Watcher has access to the SQL targets (using Microsoft Entra authentication and privilege script generated by Watcher portal).
- Microsoft Entra is enabled on the SQL Target.
- I'm using private connectivity. I've created Managed endpoints for each SQL Target and they have been approved.
- Private endpoint also configured on the Data Explorer cluster.
- The Azure Data Explorer database exists. I can run a query on the database and I can see the Watcher has Admin privilege and I myself have Viewer privilege.
Is there anything else that I can check?
-
Tom Zhao • 0 Reputation points
2026-01-06T01:18:10.2866667+00:00 I have the same issues - Failed to start watcher when clicking Start. I attempt Entra ID authentication and SQL authentication to grant SQL permission on Azure SQL server. Both are not working.
Sign in to comment
1 answer
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more