Wednesday, March 7, 2012

Can't register SSIS server in SMS...need permissions help.

I have a user who can't register the SSIS server in SMS. What permissions do I need to give him to allow this ... without making him sysadmin of course?

Check out the article by Kirk Haselden @. http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

Thanks,
Loonysan

|||

Yes, I found this online.

Unfortunately, after all this I'm still getting an error.

Could not get proxy data for proxy_id = 1

When I set up the credential, what kind of account should the "identity" be? SQL or Windows? What kind of permission should the "identity" have?

No comments:

Post a Comment