Wednesday, March 21, 2012

Mixed Security Mode for MSDE?

Hi all... MSDE installs with pure Windows Security. Can it be
reconfigured to use mixed security? Does somebody know how this can be
done?
I have tried it using Enterprise Manager in a scenario where that tool
was availeable due to presence of SQL 2K Standard, however, MSDE did
not accept a configuration change to mixed security mode.
Somebody's got a clue?
Tim
hi Tim,
"Tim" <TimWalter@.hotmail.com> ha scritto nel messaggio
news:ca5b4dee.0410200712.4615c0a7@.posting.google.c om
> Hi all... MSDE installs with pure Windows Security. Can it be
> reconfigured to use mixed security? Does somebody know how this can be
> done?
> I have tried it using Enterprise Manager in a scenario where that tool
> was availeable due to presence of SQL 2K Standard, however, MSDE did
> not accept a configuration change to mixed security mode.
> Somebody's got a clue?
after modifying the Security mode via EM, you have to restart the server...
anyway, you can have a look at
http://support.microsoft.com/default...en-us;Q285097, in the part
regarding the window registry...
for your convenience, at the link following my sign., you can find a user
interface similar to Entrprise Manager where you can graphically perform
this task too..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment