use sp_configure to set the max memory value. Note performance could be affected. Change 4096 to what value in MB you want sql to use the most

sp_configure 'show advanced options',...