Integration Services logins

• coenzyme77

  SSCommitted

  Points: 1669

  More actions

  August 6, 2008 at 8:38 am

  #191996

  Hi everyone.

  Developers can't connect to Integration Services thru SSMS Object Explorer unless they are in the O/S admin group of the box where the instance is running, otherwise the Integration Services login is denied. I don't want users with O/S admin rights on the boxes. Any ideas?

  Thanks,

  Ed

  SQL 2005 Standard SP2

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  August 6, 2008 at 9:28 am

  #853920

  You may use SSIS from the BIDS (Business Intelligence Development Studio).