Posted by qintian on 08/18/06 02:24

Dan Guzman Wrote:
> I usually suggest that Enterprise manager be used to change the SQL
> Server
> service account after installation because EM will grant additional
> advanced
> user rights that don't get assigned with the Computer Management
> method.
> The advanced rights are needed for functionality like changing
> security
> context to the proxy account and using AWE. The permissions
> (documented in
> the BOL) can be granted manually but it's more work.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
>

hi dan.. thanks for ur help but can u tell me more specified how to did
it with the EM ?? i finding whole day there but i cant find the security
part that u mentioning here..:( sorry need ur help again...


--
qintian
------------------------------------------------------------------------
qintian's Profile: http://www.dbtalk.net/m671
View this thread: http://www.dbtalk.net/t325996

• Next in forum: Re: Weird situation - Stored procedure executed twice
• Prev in forum: Alter a SQL table
• Thread view: Re: installation problem for SQL 2000 Development Edition

[Reply to this message]