July 17, 2013 at 12:49 pm
From my SQL 2008 installed development machine, to connect to Integration services of an SQL 2008 server, do I have to do anything. I do have sysadmin access, but still i cant connect to IS of that server, geting an error
Connect to SSIS Service on machine "ABC" failed:
Access is denied.
I dont want to login into the server box and open the IS to view my packages. I should be able to connect and view them from my dev machine.
July 17, 2013 at 2:50 pm
Connect to a Remote Integration Services Server (SSIS Service)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 17, 2013 at 11:45 pm
+ 1
Also summarized this in my blog post http://coffeeandsql.com/2013/07/11/access-denied-on-your-ssis-sql-server-2008/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply