question

azeemurrehman-1958 avatar image
0 Votes"
azeemurrehman-1958 asked Cathyji-msft commented

Insufficient resources in database

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-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @azeemurrehman-1958,

As Olaf mentioned, which too/app that you are using? The connection to SQL server failed? The error message do not point out which resource insufficient. Please share us the error message from SQL server error log or windows event log. Or sharing us a screenshot about the login failed include the error message. Please mask the sensitive data.

0 Votes 0 ·

Hi @azeemurrehman-1958,

Any update for this thread?

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered
 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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.