May 19, 2008 at 11:22 am
Hello,
I am trying to configure memory usage on my SQL 2005 x64 enterprise edition server. When I go to Server Properties > Memory > Server Memory Options, the Minimum and Maximum server memory fields are grayed out, not allowing me to change them. I checked several other SQL servers and all are open and allow me to edit these values. I am an administrator on the server. Does anyone know why these options would be grayed out? All other server options seem to be open and editable. Any suggestions would be appreciated. Thanks.
Frank
May 19, 2008 at 11:58 am
If you are a sysadmin in SQL Server you should be able to change this settings.
Did you try using sp_configure.
Exec sp_configure 'max server memory (MB)', 1024
reconfigure
[font="Verdana"]Markus Bohse[/font]
May 19, 2008 at 12:02 pm
Hi Marcus,
Thanks. I am able to use script to change the setting. My question was why is the GUI option grayed out? Any thoughts? thanks.
May 19, 2008 at 12:09 pm
Sorry, no ideas. I've never seen something like that unless I had no admin rights.
[font="Verdana"]Markus Bohse[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply