Post reply

DTS access

  • January 8, 2007 at 2:05 pm

    #76636

    One of the developer don't see the DTS pacakage rest everyone can see, what should I do to get him the access

    I gave him Readonly access to all the DB

  • January 8, 2007 at 2:17 pm

    #681888

    Add the user to the TargetServerRole in the MSDB database

  • January 8, 2007 at 2:21 pm

    #681892

    Its windows attentication

    Nita

  • January 8, 2007 at 2:31 pm

    #681898

    It does not matter what the user authentication is, you can just add the LOGIN to the TargetServerRole in MSDB

  • January 8, 2007 at 2:37 pm

    #681901

    I have dev and staging....in dev its working fine without adding the LOGIN to the TargetServerRole in MSDB??

  • January 9, 2007 at 7:37 am

    #682018

    I did that still its not working??

    Nita

     

  • January 9, 2007 at 8:52 am

    #682040

    Compare the permissions for sp_enum_dtspackages in msdb of the dev and staging instances.  That's the stored procedure that Enterprise Manager executes to list DTS packages. 

    Greg

    Greg

  • January 9, 2007 at 3:36 pm

    #682221

    It might be caused by the following two reasons, but not limited.

    1. Users have different privilege to access DTS;

    2. Users use different versions of SQL Server Client tools.

  • January 10, 2007 at 7:29 am

    #682370

    Thanks I added that user in MSDB Db and it worked.

    Thanks to everyone

    Nita

Viewing 9 posts - 1 through 8 (of 8 total)

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