Post reply

Error creating security descriptor for shared objects (reason: The trust relationship between this workstation and the primary domain failed). The step failed.

  • February 6, 2010 at 12:01 pm

    #144765

    Hi,

    We have SQL Server 2005 x86 developer edition with SP3 and I have SQL Agent job to delete old bak files(using VB Script). It's running fine since I created but last night, after some maintenance by Network team, this job is failing with below message:

    Error creating security descriptor for shared objects (reason: The trust relationship between this workstation and the primary domain failed). The step failed.

    please advice

    Thanks

  • February 6, 2010 at 7:17 pm

    #1115126

    I appreciate your help on this because the old bak files are not getting deleted as the job is failing with the above message and the space is full on the server. Right now I'm deleting manually, but I would like to know what this error referring to

    Thanks

  • February 8, 2010 at 12:04 am

    #1115302

    Try running the job after changing the owner to 'sa' if its not sa. Also, try running the job step script manually under SSMS after logging in with user account having admin rights.

    MJ

  • February 8, 2010 at 1:16 pm

    #1115771

    Thanks Manu,

    But it's a VB Script. Can we run the VB script from SSMS?

    Thanks

  • February 10, 2010 at 4:36 pm

    #1117280

    Yes, you can. Go to New Agent Job-->New Job Step-->Under Type-->choose Active X Script. In down window select VBScript as lanaguage and paste your script.

    MJ

Viewing 5 posts - 1 through 4 (of 4 total)

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