Re: Can authentication mode be changed after installation
From: Tim S (stahta01_at_juno.com)
Date: 06/06/04
- Next message: Uri Dimant: "Re: **different place for creating a new table**"
- Previous message: Rohtash Kapoor: "Re: Sorting Table and moving to last row in Enterprise Manager"
- In reply to: Raymond Du: "Can authentication mode be changed after installation"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 5 Jun 2004 23:04:36 -0500
Tim S
BOL entry follows
To set up Mixed Mode security
1.. Expand a server group.
2.. Right-click a server, and then click Properties.
3.. Click the Security tab.
4.. Under Authentication, click SQL Server and Windows.
5.. Under Audit level, select the level at which user accesses to
Microsoft® SQL ServerT are recorded in the SQL Server error log:
a.. None causes no auditing to be performed.
b.. Success causes only successful login attempts to be audited.
c.. Failure causes only failed login attempts to be audited.
d.. All causes successful and failed login attempts to be audited.
Security Note Microsoft recommends auditing, at minimum, failed login
attempts. Auditing failed login attempts helps determine if unauthorized
users are attempting to access the system.
"Raymond Du" <rdrd@yahoo.com> wrote in message
news:en%23VXNrSEHA.3660@tk2msftngp13.phx.gbl...
> Hi,
>
> Is it possible to change SQL server authentication mode to mixed after
> installation?
>
> Thanks in Advance
>
>
begin 666 securitynote.gif
M1TE&.#EA# `+`/<`````_\;&QO__________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M_____________________R'Y! $```$`+ `````,``L```@O``,('$B0(("#
H" $$."@P(4.$#14.A!AQ(D.+$25B7*A0(\>%%3>&S.C0H,.+`0$`.P``
`
end
- Next message: Uri Dimant: "Re: **different place for creating a new table**"
- Previous message: Rohtash Kapoor: "Re: Sorting Table and moving to last row in Enterprise Manager"
- In reply to: Raymond Du: "Can authentication mode be changed after installation"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
