Re: Run SQL Server services with the lowest possible privileges.
From: Derek (dg364_at_juno.com)
Date: 03/29/04
- Next message: Alex: "sp_validatelogins"
- Previous message: Sue Hoegemeier: "Re: audit"
- In reply to: Aaron Weiker: "Re: Run SQL Server services with the lowest possible privileges."
- Next in thread: Kevin McDonnell [MSFT]: "RE: Run SQL Server services with the lowest possible privileges."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 29 Mar 2004 11:29:12 -0700
Aaron,
I have followed your directions to the letter, and had also previously
attempted this with MS's article Q283811, but am coming up with a problem
when I attempt to make the change in Ent. Manager:
Error 22042: xp_SetSQLSecurity() returned error -2147024890, 'The Handle is
invalid.'
Should I be setting this up elsewhere? Has anybody else encountered this
before?
Derek
"Aaron Weiker" <msnews.SPAM@aaronweiker.com> wrote in message
news:efQXgRcDEHA.3016@TK2MSFTNGP11.phx.gbl...
> Ken wrote:
> > I see the phrase "Run SQL Server services with the lowest possible
privileges." but the exact lowest possible privileges are not exactly
discussed anywhere. I am betting that the answer depends on exactly what
you are doing with SQL Server. Some guidelines and discussion of this would
be helpful.
> >
> >
>
> I wrote up a small article on this that can help point you in the right
> direction.
>
> http://blogs.sqladvice.com/aweiker/archive/2004/03/07/712.aspx
>
>
> --
> Aaron Weiker
> http://blogs.sqladvice.com/aweiker
> http://aaronweiker.com/
>
- Next message: Alex: "sp_validatelogins"
- Previous message: Sue Hoegemeier: "Re: audit"
- In reply to: Aaron Weiker: "Re: Run SQL Server services with the lowest possible privileges."
- Next in thread: Kevin McDonnell [MSFT]: "RE: Run SQL Server services with the lowest possible privileges."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
