Time zone of SQL Server Reporting Services

Posted on 2011-04-27
Last Modified: 2012-05-11
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
Question by:m1itsupport
    1 Comment
    LVL 13

    Accepted Solution

    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

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
    This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now