Changes to SQL 2000 Server Properties Don't "Stick"

Hello,
I have a new installation of SQL 2000 (via SBS 2003). When it was originally
setup, "Windows Only" security was configured. Using the "Server Properties
" dialog in Enterprise Manager, I tried changing it to "Windows and SQL", bu
t the changes don't "stick"
after clicking OK. I tried some other general changes (for example: min/max
memory) and none of the changes I make are stored after clicking OK.
Has anyone run across this before?
ThanksHi,
I have not encountered this sort of sitiuations before,
For changing the Memory and other parameters please try executing
SP_CONFIGURE procedure (Look books online for info).
For changing the Authentication mode you have to change the registry entry
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\Microsoft SQL
Server\HARISQL\MSSQLServer]
Change the value for "LoginMode" to 2 for SQL server and Windows , AFter
this restart SQL server sevice and verify the status.
Thanks
Hari
MCDBA
"FJOHN" <anonymous@.discussions.microsoft.com> wrote in message
news:A9887B4F-FFD3-4E7A-B465-210476166479@.microsoft.com...
> Hello,
> I have a new installation of SQL 2000 (via SBS 2003). When it was
originally setup, "Windows Only" security was configured. Using the "Server
Properties" dialog in Enterprise Manager, I tried changing it to "Windows
and SQL", but the changes don't "stick" after clicking OK. I tried some
other general changes (for example: min/max memory) and none of the changes
I make are stored after clicking OK.
> Has anyone run across this before?
> Thanks|||It sounds like the login that SQL Server is running under may NOT have
permissions to alter the registry keys for SQL Server...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"FJOHN" <anonymous@.discussions.microsoft.com> wrote in message
news:A9887B4F-FFD3-4E7A-B465-210476166479@.microsoft.com...
> Hello,
> I have a new installation of SQL 2000 (via SBS 2003). When it was
originally setup, "Windows Only" security was configured. Using the "Server
Properties" dialog in Enterprise Manager, I tried changing it to "Windows
and SQL", but the changes don't "stick" after clicking OK. I tried some
other general changes (for example: min/max memory) and none of the changes
I make are stored after clicking OK.
> Has anyone run across this before?
> Thankssql