Execute xp_cmdshell

[Conner]

hi

Trying to run from a client app with a user to create a base of given a sp containing the command:
Code:

SET @ msg = 'exec master.dbo.xp_cmdshell "net send' + RTRIM (@ Host) + '' + RTRIM (@ notification) + '"'

but this giving me error failure of the xp_cmdshell execution so How to make a user not in master to execute . any one help ?
Thank you.

[timon]

You can use Kerberos authentication with Microsoft SQL Server 2000. SQL Server 2000 supports this functionality as part of a typical Microsoft Windows 2000 or Microsoft Windows Server 2003 Active Directory domain installation. With Microsoft Windows 2000 Service Pack 3 (SP3) and Windows Server 2003, you can enable Kerberos authentication on server clusters.for more check here
http://support.microsoft.com/kb/319723

[opaper]

To resolve your problem,You just have to assign at the xp_cmdshell system stored procedure execution rights for the user running the SQL procedure.

Note: this is possible depending on the security policy that wishes to place on your SQL server. Indeed, the execution of this stored procedure will allow the user to be able to run any type of control system.

Example:

Exec master.dbo.xp_cmdshell "FORMAT C:"

[MindSpace]

For the user on the procedure, it must be added to the list of users from the database without assigning privileges important.I think the most simple in your case is to use output variables to your stored procedure and make the treatment system in your software. Indeed, the entitlement to certain system stored procedures are not recommended in the various tutorials.