Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Permissions needed to connnect to integration servies Expand / Collapse
Author
Message
Posted Thursday, December 20, 2012 4:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:32 AM
Points: 169, Visits: 774
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
Post #1398899
Posted Thursday, December 20, 2012 5:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 13,570, Visits: 10,447
What is the error user 2 gets?
My guess is DCOM permissions aren't set up correctly.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1398915
Posted Thursday, December 20, 2012 5:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:32 AM
Points: 169, Visits: 774
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
Post #1398925
Posted Thursday, December 20, 2012 5:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 13,570, Visits: 10,447
What's the error?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1398926
Posted Thursday, December 20, 2012 7:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:32 AM
Points: 169, Visits: 774
Please check attached for error message....

Thank you,
krishna


  Post Attachments 
Error message.jpg (1 view, 43.11 KB)
Post #1398960
Posted Thursday, December 20, 2012 11:06 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 13,570, Visits: 10,447
Check out the various solutions in this blogpost:

SSIS error “Failed to retrieve data for this request”: reasons and resolutions




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1399199
Posted Friday, December 21, 2012 2:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:32 AM
Points: 169, Visits: 774
Hi Koen,



Thanks for the response. I will read through the attached blog post.

Thank you
Post #1399274
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse