How to set "max memory size" in MS SQL Server 2012?

Question

Windows Server

Set the value of "maximum memory size" in SSMS to 0 (zero) now, the MSSQLSERVER service lives for 10 seconds at startup and stops. I can't connect via sqlcmd either. Is there a given parameter that is written in any file that can be edited? Or how to return the default value of the memory, because I essentially put the server?

Answer 1

I close
the question just in memory,
just when I figured this out, I had to run sqlserver as an application with the attributes of a single autonomous instance and manually set the required amount of memory via sqlcmd, returning the original value:
1) sqlservr -F -M
2) SQLCMD -E
3) sp_configure 'max server memory', %your RAM value%;
GO

Answer 2

MSSQLSERVER service lives for 10 seconds at startup

You need to read the reason for the stop in the MS SQL log. Perhaps the memory is not to do with it.