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

Change Password After 1st Login

I've tried Books Online, MSDN online and google but cannot get the answer.
Can I get ann SQL account configured such that the user will have to change
the next time they login.
Apologies if this is a simple flag somewhere but I can assure you I have
tried to find the answer.
Any help welcome.
MPMForgot to mention SQL 2000 + SP3a
"MANCPOLYMAN" wrote:
> I've tried Books Online, MSDN online and google but cannot get the answer.
> Can I get ann SQL account configured such that the user will have to change
> the next time they login.
> Apologies if this is a simple flag somewhere but I can assure you I have
> tried to find the answer.
> Any help welcome.
> MPM|||You can't do this in SQL2000. You will be able to do this in SQL2005 using
the MUST_CHANGE option for CREATE/ALTER LOGIN.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:86EFDFC9-3AAE-4397-8722-671962F54AB1@.microsoft.com...
> Forgot to mention SQL 2000 + SP3a
> "MANCPOLYMAN" wrote:
>> I've tried Books Online, MSDN online and google but cannot get the
>> answer.
>> Can I get ann SQL account configured such that the user will have to
>> change
>> the next time they login.
>> Apologies if this is a simple flag somewhere but I can assure you I have
>> tried to find the answer.
>> Any help welcome.
>> MPM