Security problem running SSIS package from SSMS

  • Just got a new laptop and installed SSMS on it. Setup is the same as my old laptop (same user, same service accounts, etc.). When connecting to Integration Services from within SSMS and running a stored package, I get error message stating I need to run from console or as administrator. I can do the exact same thing on my old laptop and it runs fine. I am connecting to a separate SQL Server 2008 R2 instance and not a local machine instance. My network login is the same. Any ideas would be greatly appreciated. I am pulling my hair out (or what is left anyway).

  • Is user account control turned off on your new laptop?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Turned user control off and it worked like a charm. Many Thanks !!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply