Post reply

deployed package is running without errors on only deployed user account not for other users?

  • October 21, 2008 at 1:14 pm

    #131786

    Hello All,

    i deployed package on server (as file system)

    and then connect to Sql Server Management Studio

    then Server Type as Integration Services

    it allows only authentication as windows authentication

    when i login to server with my user, package is running fine (running in Sql server Mgmt studio--> SS integration service)

    but when i login to server as other users the package is giving error

    can any one please let me know

    how to make it available to all users (whom ever it may login to server)

    Regards

    asini

  • October 21, 2008 at 2:36 pm

    #887837

    If you set the package ProtectionLevel to EncryptAllWithUserKey or EncryptSensitiveWithUserKey, you're the only one who can execute it. You'll have to set ProtectionLevel to EncryptAllWithPassword or EncryptSensitiveWithPassword to allow others to execute it.

    See "protection levels for packages" in BOL.

    Greg

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

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