Re: Using proxy account and msde.

Maria,

Could this be the problem?

From the Books Online: If you choose to use a Windows NT account that is
not a member of the local administrator's group for the MSSQLServer service,
users who are not members of the sysadmin fixed server role cannot execute
xp_cmdshell.

RLF

"MariaGuzman" <marisa@xxxxxxxxxx> wrote in message
news:e8wGozKqHHA.3508@xxxxxxxxxxxxxxxxxxxxxxx
Hi, I have installed a msde in a windows 2003 server r2. I need a user
to use de xp_cmdshell on this instance, and i already configure the
proxy account with a domain account that is server admin and sysadmin
sql server, I give access to execute de xp_cmdshell store procedure on
the master database too.

After that I try to execute the xp_cmdshell but it doesn´t works. If i
give sysadmin access to that user It works fine.

Do some body know any issue to configure and can execute xp_cmdshell
without been a sysadmin member in a msde instance??

Thanks a lot for your help.





*** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: How do I get the current date without Excels VBA!Now()?
    ... OK, so maybe Excel is not the problem, but when I execute this on an AS 2000 ... server with Excel installed, on good old Foodmart: ... WITH MEMBER Measures.VBAYear AS VBA!TRIM))) ... I am using Analysis Services 2005 without any service packs. ...
    (microsoft.public.sqlserver.olap)
  • Re: xp_cmdshell
    ... When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed ... which the SQL Server service is running. ... Set the "Non sysadmin job step proxy account ... > I have a user and I want to to give persmission of that user to execute ...
    (microsoft.public.sqlserver.clients)
  • Re: Effective Permissions Error with Domain User
    ... group nor a member of the sysadmin server role on the machine I am running ... SQL Server. ... Is the 'MYDOMAIN\Domain Users' login a member of sysadmin server role.Is ... server profile trace and found that it was calling the Execute As User. ...
    (microsoft.public.sqlserver.security)
  • Using proxy account and msde.
    ... I have installed a msde in a windows 2003 server r2. ... After that I try to execute the xp_cmdshell but it doesn´t works. ... give sysadmin access to that user It works fine. ...
    (microsoft.public.sqlserver.security)
  • Re: securityadmin server role - change password
    ... password (e.g. member of SysAdmin or SecurityAdmin fixed server role) ... SysAdmin never have to enter the old password (i.e. the field in the ... editable for members of the SecurityAdmin role. ... The only exception to this rule is when a member ...
    (microsoft.public.sqlserver.setup)