I am logged into a SBS2011 Server as the domain admin and want to lower the max ram usage setting for Sql. Its using 15gb RAM and the only Sql databases running are SBSMonitoring and BackupExec. Leaving around 200mb RAM free. The server runs like absolute crap so i am hoping setting the ram to a max of 2gb will help.
Only problem is i am logging into the databases using windows authentication and when i click apply to make the change... it comes up that i do not have access. Is there anyway i can get access to make this change easily?
I didn't originally setup this server so am not aware of any special sysadmin logins for sql, i would need to reset them if i have to use the sysadmin account.
Any help would be great.