Time zone on reporting services

• Roust_m

  SSCoach

  Points: 17410

  More actions

  October 6, 2014 at 11:09 pm

  #397469

  Hi,

  I've migrated a server with SQL Server 2008R2 and Reporting services into a new box with SQL Server 2014, but forgot to change the timezone to the correct one. I've changed it later, but it seems like the reports are running by the old default timezone. The schedule says that the report should run at 6:30am, but the Last Run column shows 8:30 PM.

  I need to fix it without manually updating each subscription with some date/time conversion.

  Any ideas?

  Thanks.

• Vishal Singh

  SSCertifiable

  Points: 5830

  More actions

  October 8, 2014 at 4:43 am

  #1750882

  Did you try recycling the services post changing the Time Zone?

  -Forum Etiquette: How to post Performance Problems[/url]

  -Forum Etiquette: How to post data/code to get the best help [/url]