Figured it out. The SQL Service account was a domain account and did not have administrator privilege on the server it ran on. Strangely enough the procedure needs some kind of special local permissions.
<>< Ryan -----Original Message----- From: Ryan Jameson (USA) Sent: Friday, July 12, 2002 9:57 AM To: php.db Subject: [PHP-DB] MS Sql Server xp_sqlagent_proxy_account exec master.dbo.xp_sqlagent_proxy_account N'GET' Anyone ever had the above give you "Access is denied." When you run it as 'sa' ??? <>< Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
