Insufficient resources in database

azeem ur rehman 1 Reputation point
2021-08-04T04:49:21.44+00:00

at login in SQL Server, we are getting this message "Insufficient resources either locally or on the server, check your database" . please guide what to check and how to fix??

SQL Server | Other
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2021-08-04T05:17:47.337+00:00
    select *
    from sys.messages
    where [Text] like '%Insufficient resources%'   
    

    ... gices me no real matching result => the message don't come from SQL Server itself.
    Which tool/app are you using to logon to SQL Server?

    0 comments No comments

  2. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2021-08-04T08:26:36.033+00:00

    I googled this error message, but the only hit was this message. This indicates one of:

    1) You did not include the exact error message.
    2) The message is unique to the application, you are using.

    In the first case, please make sure that you have the exact message, including a screenshot may be better. Or google the text yourself...

    In the second case, you will to talk the group responsible for the application, so they can find out why they are producing this message.

    0 comments No comments

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.