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

MSDE Reboot Question (2 parts)

1) When I install and MSDE instance for the first time on a machine,
the install states that I must reboot the machine. However if I
manually start the instance, then my programs can access that instance
without a reboot.
2) If I uninstall the instance done in 1 above, through the Add/Remove
programs process, then subsequent installs of the same instance do not
prompt for a reboot.
So my basic question is:
Is a reboot REALLY necessary and if I manually (or programmatically)
start the instance? If a reboot is NOT really necessary, is there a
command line option that will keep that prompt from being displayed?
TIA for all replies
Wardell Castles
hi Wardell,
"Wardell Castles" <wardellcastles@.hotmail.com> ha scritto nel messaggio
news:65f20689.0412020822.1f340d53@.posting.google.c om
> 1) When I install and MSDE instance for the first time on a machine,
> the install states that I must reboot the machine. However if I
> manually start the instance, then my programs can access that instance
> without a reboot.
> 2) If I uninstall the instance done in 1 above, through the Add/Remove
> programs process, then subsequent installs of the same instance do not
> prompt for a reboot.
> So my basic question is:
> Is a reboot REALLY necessary and if I manually (or programmatically)
> start the instance? If a reboot is NOT really necessary, is there a
> command line option that will keep that prompt from being displayed?
> TIA for all replies
> Wardell Castles
usually a reboot is required to fullfill and commit all COM pending
registrations and services setting... and, when prompted, it's usually a
good idea to do it...
I do think that Windows Installer support a REBOOT=ReallySuppress
declaration, but I never used it... please have a look at
http://tinyurl.com/3tx4a
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