Administrators

I would like that local administrators or domain administrators dont have
administrative rights on some databases running with MSDE.
I've learned about to enable the user "sa" and to give a personal password
to this user, but apparently administrators continue having full access to
all databases.
Thanks.
Regards.
Jose Nuez
Montevideo - Uruguay
hi Jose,
"Jose Nuez" <josenunez70@.hotmail.com> ha scritto nel messaggio
news:OOeUxFovEHA.164@.TK2MSFTNGP10.phx.gbl
> I would like that local administrators or domain administrators dont
> have administrative rights on some databases running with MSDE.
> I've learned about to enable the user "sa" and to give a personal
> password to this user, but apparently administrators continue having
> full access to all databases.
> Thanks.
> Regards.
> Jose Nuez
> Montevideo - Uruguay
Hari already answered you in june.. http://tinyurl.com/4638l and gave you
additional pointers to troubles you could experience..
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