Re: Altering Authenication Modes - SQL2000
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 11/06/03
- Next message: Ben: "Finding SQL Servers and Patch levels on a network"
- Previous message: Sue Hoegemeier: "Re: DRI?"
- In reply to: Suze: "Altering Authenication Modes - SQL2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 6 Nov 2003 17:59:06 -0000
You need to restart the SQL Service but you don't need a reboot. And yes
make sure the sa account has a very strong password and just record it and
lock it away.This should actually be done even in Windows only mode.
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Suze" <anonymous@discussions.microsoft.com> wrote in message news:098201c3a41b$c5d2baa0$a101280a@phx.gbl... Howdy Everyone, We wish to change our sql server environment to mixed mode & because this server is in PROD, I am concerned I may have missed potential consequences of my actions. Could someone please verify that I haven't missed a possible "gotcha's" This change involves a reboot No change to existing logins/ databases that have been setup to use NT authentication. Make sure SA password has a tough password to crack It that it ?? I'm not about to slap a gift horse in the mouth but it seems a little too easy... TIA Suze :-)
- Next message: Ben: "Finding SQL Servers and Patch levels on a network"
- Previous message: Sue Hoegemeier: "Re: DRI?"
- In reply to: Suze: "Altering Authenication Modes - SQL2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
