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??
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??
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.
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?
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.
6 people are following this question.