memory got changed from default to 128 I tried repairing but that didn't work. I can start service using net start but can't login to management console due to administrator account and you can only have one person logged in.
I know it's a bit late, but connecting using SQLCmd and the dedicated administrator connection should be possible. If it is, then using sp_configure to set the maximum memory is straightforward. So, on the server, in a CMD window: C:\> SQLCmd -S ADMIN:. -E You'll then see a prompt: 1> Start typing SQL Server statements here. exec sp_configure 'show advanced options', 1; -- might not be necessary. Check output from running 'sp_configure' on its own reconfigure; exec sp_configure 'max server memory', 4096; -- or something more, depending how much memory your server has reconfigure; GO Good luck.