February 24, 2012 at 4:20 pm
I have been been given supposedly permissions to a SQL Server instance on a server. This server should also have SSIS installed on it but when I attempt to connect through SSMS "Integration Services" using my network credentials I am receiving the below error.
"Failed to retrieve data from this request.
Connect to SSIS Service on machine "MachineName" failed:
Access Denied"
I suspect that Integration Services isn't installed on the machine. How can I determine this from the Management Studio connection to the database?
Thanks
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 27, 2012 at 12:54 am
Read through this MSDN article. You probably don't have DCOM security privileges on that server.
Connecting to a Remote Integration Services Server
Especially read the Eliminating the "Access Is Denied" Error section 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2012 at 12:06 pm
Thanks Koen. I will check with the Admin to see if I am in the Distributed COM Users group.
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply