Deployment of MSDE

Is there a way to turn off System Administrators in Server Roles for the
Builtin\Administrators using the deployment toolkit?
No
"Jon" <Jon@.discussions.microsoft.com> wrote in message
news:1364DDFA-764B-4C65-AC14-BBBFEB979DD2@.microsoft.com...
> Is there a way to turn off System Administrators in Server Roles for the
> Builtin\Administrators using the deployment toolkit?
|||Hi Jon,
I install MSDE with my C# app via the deployment toolkit.
As soon as my C# app starts, I run the command against the DB
EXEC sp_denylogin [BUILTIN\\Administrators]
This removes the admins from the built in group
HTH
Paul
"Jon" <Jon@.discussions.microsoft.com> wrote in message
news:1364DDFA-764B-4C65-AC14-BBBFEB979DD2@.microsoft.com...
> Is there a way to turn off System Administrators in Server Roles for the
> Builtin\Administrators using the deployment toolkit?
|||hi Paul,
Paul Aspinall wrote:
> Hi Jon,
> I install MSDE with my C# app via the deployment toolkit.
> As soon as my C# app starts, I run the command against the DB
> EXEC sp_denylogin [BUILTIN\\Administrators]
> This removes the admins from the built in group
>
and the SQL Server Agent can run without problems?
(http://support.microsoft.com/default.aspx?kbid=237604)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Deny remote network access to MSDE

HI!
I'd like turn off remote network access for a user group in the user
manager.
Are users of this group still capable of accessing the MSDE while
working on the local machine?
What does local access mean?
Can they access the MSDE via TCP to 127.0.0.1?
Or must they access the MSDE through a named pipe?
Ciao, Michael.
If I'm not mistaken, MSDE 2000 SP3a already disables remote access by
default.
joe.
"Michael Strder" <michael@.stroeder.com> wrote in message
news:sauhi2-5k4.ln1@.nb2.stroeder.com...
> HI!
> I'd like turn off remote network access for a user group in the user
> manager.
> Are users of this group still capable of accessing the MSDE while
> working on the local machine?
> What does local access mean?
> Can they access the MSDE via TCP to 127.0.0.1?
> Or must they access the MSDE through a named pipe?
> Ciao, Michael.