April 14, 2008 at 2:17 pm
Wondering if you could help me with an error we’re receiving. One of our developers (who used to be a DBA) is unable to connect to SSIS remotely since he was taken out of the Local Administrators group of the Server. Since we’ve added him back, he was able to successfully connect to SSIS. I’ve looked online and on BOL to find out what permissions non-admin accounts need to connect to SSIS. I’ve tried a bunch of DCOM settings and used the db roles for SSIS and none of it is working. Do you have any advice for us?
April 15, 2008 at 7:12 am
The DCOM settings are what you need to fix. You have either found bad instructions, or you missed something.
When you install SQL, you get a SQLServer2005DTSUser.
Adding your developers to this group should allow them to connect to the SSIS server.
April 17, 2008 at 6:21 am
FYI.. These instructions were the best for resolving the issue. We all also added the user to the database roles in msdb for SSIS.
May 2, 2010 at 12:35 pm
Wondering what msdb role or what permissions you granted users on msdn if anyone can advise.
Thank you.
July 7, 2010 at 3:00 pm
Regarding msdb permissions, I gave dtsadmin, dtstlduser, and SQLAgentReader, and my users use the proxy account to run the jobs.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply