October 21, 2014 at 9:12 am
I am very new to SQL Server. This is the first error I am working on myself. I have sent time trying to figure it out but I can't seem to find a solution that has document steps for a person of my knowledge level. I am in need of help to fix this. I understand that this a problem that has been fixed before.
2008 R2 SP1 Standard Edition 64-bit
Error: 701, Severity: 17, State: 193.
There is insufficient system memory in resource pool 'internal' to run this query.
I also have other errors that are coming up along with this one including,
Error: 18456, Severity: 14, State: 38.
Login failed for user 'XXXX_USER'. Reason: Failed to open the explicitly specified database. [CLIENT: XX.XXX.XX.XXX]
Any help would be great. Thank you.
October 21, 2014 at 10:24 am
For your first error, are you getting this for all queries or a specific query? If a specific query or queries can you post them (anonymized as needed)?
For your second error, it sounds like the default database for the specific login(s) either no longer exist or the login(s) have had permissions removed from that database. You can fix this in SSMS by going to the login properties and changing the default database to a system database or one the user has permissions in or by running:
ALTER LOGIN [login name] WITH DEFAULT_DATABASE = [Database Name]
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 21, 2014 at 10:45 am
Seems to be all queries. Sometimes I will run one and it will create the error other times It wont. I have just increased the memory from the default. This seems to be the most common thing people have done.
Thanks for the information on the other error I will work with that to fix it.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply