Executing report subscription from another server

• Casper101

  Hall of Fame

  Points: 3903

  More actions

  February 24, 2010 at 12:58 am

  #217016

  Hi,

  I have successfully been able to create a SQL job on server A, that executes a report subscription on reporting server B. It worked fine for weeks.

  I used the following in the SQL job step:

  EXEC [LinkedServer].ReportingServices.dbo.AddEvent @EventType='TimedSubscription', @EventData='04da604e-7f8e-49c2-9105-00734739477f'

  But now we have had the request to disable our SA account on this reporting server B.

  After doing that, the job on server A fails with error:

  Login failed for user 'sa'. Reason: The account is disabled.

  How do I resolve this, while keeping the SA account on reporting server B disabled?

  Thanks in advance...

• Casper101

  Hall of Fame

  Points: 3903

  More actions

  February 24, 2010 at 5:24 am

  #1124206

  Thought I would share with you all .... I resolved the issue.

  It was the [LinkedServer] that used the SA login as the security credentials.

  I replaced that with an alternative login, and all worked well

  Thanks,