Matter if Service acct has access to db when using UserID and Password in connection string?

• dndaughtery

  SSChampion

  Points: 11290

  More actions

  January 13, 2015 at 8:31 am

  #294201

  Hey guys, just want to verify something. If I have a package being executed from a job and the acct that is the service acct is MyJobRunner_acct and I need to connect to a data source but I have a connections string with "User ID" and "password" in it then I shouldn't need to worry if the MyJobRunner_acct has read access to the database right?

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 13, 2015 at 9:44 am

  #1769866

  Yes, that's right, provided there aren't any other connection managers that use a trusted connection.

  John