Hello Folks,

I just installed 2014 SQL Instance and configured max and min memory settings and in hurry i did not see what the max value is set to, guess what it was too low 128MB which is lower than minimum memory accepted by SQL Engine and all the errors followed.

Event Viewer Messages :

Event ID : 18053 with below error messages ….

Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

Error: 33086, Severity: 10, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ET W, notifications etc are skipped.

Solution :

Steps:

1. Put the SQL Server in single user mode by adding -f ( this will work same as -m mode with minimum resources required for engine to start)
2. use CMD or Power Shell ( Run as Administrator ).
3. execute the command NET START MSSQLSERVER ; sqlcmd -S -A.
4. all the above command in single line if not one the SQL is started it will only accept single thread in  single user mode.
5. once we are in prompt execute the command below…
6. sp_configure ‘show advanced options’, 1;
   GO
   RECONFIGURE;
   GO
   sp_configure ‘max server memory’, 4096;– 4gb of ram
   GO
   RECONFIGURE;
   GO
7. Then check the value set.. execute the command below
8. use master
   select * from sys.sysconfigures where config=’1544′;
   GO
9. NET STOP MSSQLSERVER
10. Remove the “-f” from the startup parameters.
11. Restart the service and check the instance is up and running.

That’s it you are back on track.