October 28, 2002 at 2:17 pm
When changing the settings in SQL Server 2000 with the gui from Enterprise manager, the settings do not stay set. Example: When you right click on the server, click on properties, change the max memory from 1024 to 924. Click ok, then go back into the settings, it is back to 1024. If we use sp_configure, the settings change correctly. If we change the default data directory and log directory, these settings also do not stick. We actually had to go into the registery add a value DefaultData and DefaultLog before this value would be changed.
If you know of an issue or problems with this and the correct fix, please let me know.
Info which might be helpful: We start both the SQL Server and SQL Server Agent with an account other than the local administrator, however the user is in the local admin group and is a domain admin.
thanks for your help
October 29, 2002 at 8:43 am
Which Service Pack? My SQL 2000 SP2 server (one I tested) works.
Steve Jones
October 29, 2002 at 4:21 pm
this is service pack is 2 with the latest security hot patches.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply