• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2879
  • Last Modified:

Time zone of SQL Server Reporting Services

An error happened because the time zone of SQL Server Reporting Services (SSRS) is inconsistent with the time zone of the call detail recording (CDR) database (time zone of SSRS : Middle East Standard Time, CDR database : Pacific Standard Time). All SSRS computers and the CDR database must use the same time zone. To make the time zone consistent between SSRS and CDR database, follow these steps:

- If you want to change time zone of SSRS, restart the SSRS after changing the time zone.
- If you want to change time zone of CDR database, follow these steps:
1. Run the dbo.RtcClearTimeZoneInfo stored procedure on the LcsCDR database.
2. Open the reports home page in your web browser using the SSRS that has the time zone that you want to use.
3. Run the dbo.RtcGenerateSummaryTables stored procedure on the LcsCDR database to improve your reporting performance.
 
 Where can i find "dbo.RtcClearTimeZoneInfo " to run it
0
m1itsupport
Asked:
m1itsupport
1 Solution
 
devlab2012Commented:
There should be a stored procedure "RtcClearTimeZoneInfo" in your LcsCDR database.

Open sql server management studio, in query editor window, execute the following command:
EXEC dbo.RtcClearTimeZoneInfo
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now