Re: xp_cmdshell right for non sysadmin
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/06/04
- Next message: Steve Z: "Cursor vs Set - is it possible"
- Previous message: Anita: "Navision/Great Plains data dictionary"
- In reply to: mikew: "xp_cmdshell right for non sysadmin"
- Next in thread: mikew: "Re: xp_cmdshell right for non sysadmin"
- Reply: mikew: "Re: xp_cmdshell right for non sysadmin"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 06 Apr 2004 13:20:44 -0600
You can get the error when the SQL Server service account
does not have the necessary permissions to change security
context. If you change your SQL Server service accounts
using Enterprise Manager, the correct permissions will be
given to the service account. If you use another method to
change the service accounts (i.e. the services applet) you
won't necessarily get the correct permissions and rights
assigned to the service account. You can reset your service
account though Enterprise Manager or refer to the following
for permissions that are needed:
HOW TO: Change the SQL Server or SQL Server Agent Service
Account Without Using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811
-Sue
On Tue, 6 Apr 2004 11:31:23 -0700, "mikew"
<anonymous@discussions.microsoft.com> wrote:
>Hi, All.
>This is a win2k and SQL2k server.
>I have an SQL application user and want it to have right to execute xp_cmdshell. I have done:
>1. Give this SQL user the execute permission on xp_cmdshell
>2. Enable SQL server agent non sysadmin job step proxy account by a domain NT user (member of local server user group too)
>I got an error when I login as this user to run master..xp_cmdshell 'dir c:\'
>Msg 50001, Level 1, State 50001
>xpsql.cpp: Error 1326 from LogonUserW on line 620
>Any ideas? What else do I need to do?
>Thanks in advance.
- Next message: Steve Z: "Cursor vs Set - is it possible"
- Previous message: Anita: "Navision/Great Plains data dictionary"
- In reply to: mikew: "xp_cmdshell right for non sysadmin"
- Next in thread: mikew: "Re: xp_cmdshell right for non sysadmin"
- Reply: mikew: "Re: xp_cmdshell right for non sysadmin"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
