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