November 18, 2011 at 5:47 am
Hi all
In trying to get a remote server to upload information to my Data Warehouse in data collector I am getting errors that the service account doesn't have the permissions.
One way round this is to create a proxy account. I have created a credential and a proxy account and added the dc_proxy role to the proxy, however the upload jobs still fail. The jobs themselves are already using the SQL Service agent account.
Does anyone have any ideas?
Thanks
November 18, 2011 at 6:48 am
did you specify the proxy account for the job step ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 18, 2011 at 7:10 am
Yeah I tried to do that but the jobs use TSQL and a CMDEXEC steps. I guess I won't be able to change the TSQL one, but the CMDEXEC step doesn't give me the option to use the proxy. Its just not available!!
I have got round this though by adding the target service account to the MDW_Writer role on the instance where the MDW database is present.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply