RE: [PHP-DB] MS Sql Server xp_sqlagent_proxy_account
| From: | USA) | Date: | Fri, 12 Jul 2002 16:14:54 +0000 |
| Subject: | RE: [PHP-DB] MS Sql Server xp_sqlagent_proxy_account | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20510@lists.php.net to get a copy of this message | ||
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