Time zone of SQL Server Reporting Services

Posted on 2011-04-27
Medium Priority
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

devlab2012 earned 2000 total points
ID: 35477632
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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

831 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