I have installed the MSDE and I didn't set the securitymode = sql. How can I go back and change it to SQL?

There are two types of security, Windows authentication and mixed mode. There is no SQL mode.
Windows authenthication uses the windows accounts to grant access, mixed mode uses both windows and SQL Server accounts.
Are you trying to set it up as mixed mode?
Either way, here is a extract from microsofts web site.
____________________

Expand a server group.

Right-click a server, and then click Properties.

On the Security tab, under Authentication, click Windows only.

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.
____________

hope this helps.





Sal

There is a registry edit you can use to change security modes.

open regedit and find the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\ MSSqlServerThen
double-click the LoginMode subkey.

In the DWORD Editor dialog box, set the value of this subkey to 2, make sure that the Hex option is selected, and then click OK.

Restart the MSSQLSERVER and the SQLSERVERAgent services for this change to take effect.


You can always click here for the full microsoft version of the above steps:
http://support.microsoft.com/default...en-us;319930#6

It does work I used it!



---
David Thorne, Student
UK

That worked CFerthorney.

Thanks.