Re: Change username of "SA"

From: Morris Lewis (Morris@Holistech.com)
Date: 07/01/02 

From: "Morris Lewis" <Morris@Holistech.com>
Date: Mon, 1 Jul 2002 00:23:38 -0500

SS 7 and 2k use the SID for sa in all operations, not the name. Some sprocs
that limit access to sa, check the suser name instead of the SID, though, so
you would have to change all the system sprocs.

SQL Server authenticated logins are a bad idea that should have died with
SS65. Use Windows Authenticated logins instead. Check my article in the
July, 02 issue of SQL Mag for the benefits Kerberos offers when you use
Windows authenticated logins with SS2k running on W2k. If you're really
interested in securing admin access to the server, you should use only
Windows Auth logins.

Morris Lewis
MCDBA, MCSD, MCSE+I, MCT, CTT+
President, Holistech Inc.

"Schnyder Daniel" <daniel.schnyder@timeware.ch> wrote in message
news:etFThQ5GCHA.2148@tkmsftngp08...
> Hello NG
>
> A custumer of us would like to change the name of the "sa" for security
> reasons. Is this possible? Can it give some problems? Good or bad idea?
>
> Thanks
> Daniel
>
>