RE: Changing Authentication modes?

You should not hose anything by changing from Windows to Mixed Authentication mode or vice-versa. Any doubts, test it on your test cluster first and then do it on your production cluster.

From SQL Books Online ---

How to set up Mixed Mode security (Enterprise Manager)
--------------------------------------------------------------------------------------

Security Note When possible, use Windows Authentication.


To set up Mixed Mode security

- Expand a server group.
- Right-click a server, and then click Properties.
- Click the Security tab.
- Under Authentication, click SQL Server and Windows.
- Under Audit level, select the level at which user accesses to Microsoft® SQL Server? are recorded in the SQL Server error log:
* None causes no auditing to be performed.
* Success causes only successful login attempts to be audited.
* Failure causes only failed login attempts to be audited.
* 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.

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx


.

Relevant Pages

  • RE: SQL Server in different machine
    ... You can enable security auditing on the SQL Server: ... Right-click the SQL server, and then click Properties. ... All causes successful and failed login attempts to be audited. ...
    (microsoft.public.sqlserver.connect)
  • RE: SQL Server in different machine
    ... You can enable security auditing on the SQL Server: ... > All causes successful and failed login attempts to be audited. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting to the bottom of MSDE network connection problems ...
    ... Brilliant, Nick, especially the explanation for local network user being ... authenticated as GUEST in WinXP SP2. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ... > again and selected the security tab. ...
    (microsoft.public.sqlserver.msde)