MSDE security

Hello,
Article Q319930 states that MSDE clients must be members
of the Administrators group on the machine which is
hosting MSDE. Is this really correct? I want to use MSDE
with non-admin clients, and have done the appropriate
sp_grantdbaccess, but still get 'login failed' errors when
using a non-admin account.
No, you can use Windows Auth. from the network not only locally. Did you set
the Auth. mode to mixed mode ? Sound like you ddidnt. Try to connect on the
computer MSDE is running to verify if its turned on via.: (must be in the
local administrators group when logged on)
Commandprompt: OSQL -E and then from a remote computer via
SQL -SYourServername -E
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Chris" <csmith@.mail.eascorp.org> schrieb im Newsbeitrag
news:042401c54a72$703536f0$a601280a@.phx.gbl...
> Hello,
> Article Q319930 states that MSDE clients must be members
> of the Administrators group on the machine which is
> hosting MSDE. Is this really correct? I want to use MSDE
> with non-admin clients, and have done the appropriate
> sp_grantdbaccess, but still get 'login failed' errors when
> using a non-admin account.
sql