I accidentally set my sql server maximum memory too low (32MB). After I changed it, no one could log on. We get an error message "Shared Memory Provider: No process is on the other end of the pipe".
I stopped and end task SQLServer service. I could not start the db again. I tried to start sqlserver with:
And try to log in using "c:\sqlcmd -A" but I could not log on to change maximum memory. Then I tried to start with
I still could not log in. It complaint that only one adminstrator can log in.
After two hours of frustration, I started the database again using