January 19, 2011 at 4:15 am
Hi,
I'm a DBA and have a user with the following problem.
I have just installed SQL Server 2008 R2 on a new server and installed SSIS as well. When I connect to SSIS from my PC via Management Studio I'm able to connect, even locally on the server I'm able to connect. The user is running Windows 7 on his laptop and have Management Studion installed on it. The problem is that they can't connect to SSIS via Management Studio but the are able to connect to the Database Engine. I have tried the solution from this post http://msdn.microsoft.com/en-us/library/aa337083.aspx but it still gives the same error.
January 19, 2011 at 5:04 am
Couple of things you could try;
1. Try adding the user's account to the Distributed COM users group on the server.
2. Check MsDtsServer in Component Services:
add all permissions for msdtsserver for the problem desktop user's account
component services > My computer properties > MSDTC > Security Configuration > Network DTC Access > Allow Remote clients
COM Security > Access permissions > Edit Limits
add all permissions for msdtsserver for the user account
COM Security > Launch and activation permissions > Edit Limits
add all permissions for msdtsserver for the user account
Allow inbound
allow outbound
restart MSDTC
restart SSIS
January 19, 2011 at 5:15 am
Hi,
I've done the part on Step 2 yesterday and it didn't work....just added the user to the DCOM Users Group now. Just waiting for them to test.
January 19, 2011 at 6:18 am
Hi,
They have just tested after doing Step 1, which is adding the user to the DCOM User Group and everything works just fine.
Thanks!
January 19, 2011 at 7:16 am
Nice one!
And no problem 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply