Re: Unable to set SQL proxy for xp_cmdshell
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 20 Mar 2006 06:55:48 -0600
You should be able to get the SID using SUSER_SID for any domain account.
One thing you might check is to make sure the SQL Server service account has
the needed permissions. Perhaps the service account rights were lost as a
result of your AD migration.
The easiest way to do this is to use EM to change the SQL Server service
account to local system and then back to a domain account. You'll need to
restart SQL Server for the change to take affect. Then try to set the proxy
account again.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Bry" <fqies_bry@xxxxxxxxx> wrote in message
news:1142821926.265461.187210@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
When I select the SID of the proxy account, it returns NULL values.
yes, i can login to SQL box using the proxy account via terminal
services. i tried to use the same account as of the SQL services and it
returns the same error. but it is just for testing, i am using a domain
account and I add it in User group of the box. What could be the
possible problem of these boxes? our last resolution is to reinstall
the SQL but this is not our priority approach since our team dont want
any downtimes on their development environments. hope you could help
me. thanks.
Dan Guzman wrote:
Do you get the account SID back when you SELECT SUSER_SID('<your ad
domain>/<your proxy account>')? Can you login locally on the SQL box
using
the proxy account?
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Bry" <fqies_bry@xxxxxxxxx> wrote in message
news:1142575692.017795.18830@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have checked the google group search and found a topic regarding
the setting Proxy account for SQL agent. The topic was logged last Dec.
2003. I have the same issue but this time, a changed with Domain might
be the cause. we moved from NT domain to AD. I am encountering 'No
mapping between account names and security IDS was done.' error, when i
tried to reset the proxy using the new domain account. I have tried to
delete the proxy using the DEL of xp_sqlagent_proxy_account but i
encountered the same error. I used GET and it returned the result
having the old
domain name and user name. I am wondering if the SQL is still looking
for the SID of the NT domain account. please someone attended this
topic asap. i need to resolve this ASAP.. =)
.
- Follow-Ups:
- References:
- Unable to set SQL proxy for xp_cmdshell
- From: Bry
- Re: Unable to set SQL proxy for xp_cmdshell
- From: Dan Guzman
- Re: Unable to set SQL proxy for xp_cmdshell
- From: Bry
- Unable to set SQL proxy for xp_cmdshell
- Prev by Date: Re: dbo Owner
- Next by Date: Error accessig Diagram Folder (MSDE -> SQL Express Database)
- Previous by thread: Re: Unable to set SQL proxy for xp_cmdshell
- Next by thread: Re: Unable to set SQL proxy for xp_cmdshell
- Index(es):
Relevant Pages
|
|
