December 20, 2012 at 4:20 am
Hi
I got user1 and user2. They both got same level acccess on one server, including DB's. But user1 can connect to integration services but user2 is not. can you suggest me to resolve this issue please.
[what are the permissions needed to connect SSIS].
Right now user1 and user 2 got these permissions :
One perticulat DB both users got data reader permissions and on MSDB both got Db_ssisadmin, db_ssisltduser and db_ssisoperator
Please let me know if you need any other details.
Thanks in advance.
krishna
December 20, 2012 at 5:07 am
What is the error user 2 gets?
My guess is DCOM permissions aren't set up correctly.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2012 at 5:42 am
Hi Thank you for your reply...
Sorry I forgot to mention about DCOM..
I tried that but still same issue ...
http://sqlpowershell.blogspot.co.uk/2009/02/connecting-to-remote-ssis-server-with.html
Thank you,
Krishna
December 20, 2012 at 5:43 am
What's the error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 20, 2012 at 7:17 am
Please check attached for error message....
Thank you,
krishna
December 20, 2012 at 11:06 pm
Check out the various solutions in this blogpost:
SSIS error “Failed to retrieve data for this request”: reasons and resolutions
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2012 at 2:15 am
Hi Koen,
Thanks for the response. I will read through the attached blog post.
Thank you
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply