May 27, 2015 at 5:26 am
Set Server Max memory too low accidentally and now its refusing connection.
How to increase the same.DAC is failing with Timeout Error
May 27, 2015 at 7:21 am
If you can't get in with the DAC you may need to restart the service. Do it with the command lines -f and -m to get it to a minimal configuration and single user mode so you can connect up (although, depending on the level of access and control you'll have other others connecting, -m might be dangerous). Documentation is here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2015 at 7:12 am
Thanks Grant. Able to fix the issue by starting in single user
May 29, 2015 at 2:33 pm
Thanks for reporting back with the solution. That'll help anyone who finds your question through searches.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply