Azure SQL database not deleting

Jobby Joseph 1 Reputation point
2021-05-27T22:37:53.217+00:00

Even after deleting an azure database the application is apparently accessing it from somewhere. The database is shown under deleted databases but the application is still accessing it. How do you delete a db so that it cannot be accessed?

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 34,676 Reputation points MVP Volunteer Moderator
    2021-05-27T23:43:01.743+00:00

    Please make sure the application is not getting connected to the "master" database instead of the database that was deleted. Connect to the master database on the same Azure SQL logical server and run the stored procedure sp_who2. There you may probably find the application is getting connected, to the <default> database (the master).

    0 comments No comments

  2. Adrian Martinez 1 Reputation point
    2021-06-02T01:46:21.317+00:00

    Hello, I think that you will maybe need to delete the cluster that you used for this, or maybe try deleting the machine learning system.
    If the stuff does not work then I would recommend for you create a new project and copy the previous project files.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.