July 18, 2013 at 12:01 am
Comments posted to this topic are about the item Resolving Errors While Connecting to SSIS
July 18, 2013 at 8:35 am
Very useful article. Especially for those who don't spend a lot of time dealing with SSIS, and need to debug something a couple of times a year.
July 18, 2013 at 11:34 am
There is a problem with item 16. The db_dtsadmin from 2005 was replaced by db_ssisadmin in 2008. The problem dbas need to be aware of is that a member of db_ssisadmin has the ability to elevate themselves to the full sysadmin role. Not good. Instead, add the group or account to both the db_ssisltduser and db_ssisoperator roles. Strikes me as a pretty serious flaw which should be addressed by MS, but this behavior still exists in 2012 version.
Bob Feldsien
July 18, 2013 at 1:35 pm
This is a very nice copy of this MSDN article:
Connect to a Remote Integration Services Server
Didn't notice the copyright at the bottom?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 18, 2013 at 2:37 pm
// accidentally hit quote instead of edit... :blush:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy