Coonecting from management studio -- non admin account -
07-18-2006
, 09:28 AM
Hello,
I'm trying configuring SSIS to allow remote connections from management
studio for non-admin account but get the following error:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
Connect to SSIS Service on machine "XYZ" failed:
Access is denied.
I tried differnet solutions posted on the inet, such as reconfigure
permissions for MsDtsServer in Dcom components, editing MsDtsSrvr.ini.xml
file -- I added servername\instance_name there, I added account to
SQLServer2005DTSUser$ local group. Nothing helps.
This not networking issue because at the moment when I'm adding user acount
to Administrators group on the SSIS server the connection starts working.
I would be very grateful for any help.
Thanks,
Gary. |