SSIS Access Is Denied

• VegasL

  Hall of Fame

  Points: 3006

  More actions

  January 22, 2016 at 9:55 pm

  #303908

  Hi All,

  I'm trying to run SSIS, but get Access is Denied. I am new at this..so when I choose the server, since its ssms installation is on local pc, i am by default admin as well. How can I fix?

• gdemayo

  Valued Member

  Points: 57

  More actions

  January 25, 2016 at 4:58 am

  #1854121

  Hi Vegasi,

  Try opening SSMS as Administrator and that should work. Even as local admin, SSIS is "picky" that way.

• Brad Feaker-195979

  SSChasing Mays

  Points: 639

  More actions

  January 25, 2016 at 11:50 am

  #1854259

  This article explains how to resolve this issue permanently...

  https://www.mssqltips.com/sqlservertip/3086/how-to-resolve-ssis-access-denied-error-in-sql-server-management-studio/

  Brad Feaker"Tantum religio potuit suadere malorum." - Lucretius