Keep your SSRS ExecutionLog more than 60 days

Keep your SSRS ExecutionLog more than 60 days
5 (100%) 2 votes

Hello,

Welcome back! As 2017 begins, things are going to change around here. A new challenge has arrived, #22posts12months. I will try to keep posts shorter and objective. I will publish every 15 days. Keep me updated on how it all works for you!

ExecutionLogDaysKept

Probably you didn’t noticed yet but if you try to collect usage information for our Microsoft SQL Server Reporting Services (execution log), by default Reporting Services instance will only keep the most recent 60 days in the execution log . Even though the server had been running a good deal longer than that!

Parameter: ExecutionLogDaysKept

The number of days to keep report execution information in the execution log. Valid values for this property include 0 through 2,147,483,647. If the value is 0 entries are not deleted from the Execution Log table. The default value is 60.

Source: https://technet.microsoft.com/en-us/library/bb934303(v=sql.105).aspx

How to keep them then?

There’re 2 ways to do this: (1) through Server Properties page or (2) a SQL statement.  Continue reading “Keep your SSRS ExecutionLog more than 60 days”

LMCompatibility – Failed to connect remote server via Remote Desktop (RDP)

LMCompatibility – Failed to connect remote server via Remote Desktop (RDP)
4.5 (90%) 2 votes
Hey guys,

Everything has been working great until recently for some reason you cannot use your RDP client to access your remote server? Did your remote desktop client continues to pop-up and you’re sure that entered the right password? Or your session unexpectedly exits? The following procedure could work on you.

Continue reading “LMCompatibility – Failed to connect remote server via Remote Desktop (RDP)”

Excel found unreadable content when exporting a SSRS report

Excel found unreadable content when exporting a SSRS report
4.7 (93.33%) 3 votes

Hi guys,

I ran into a strange bug in Visual Studio when I was developing a new report to track the effort of each team member. Noticed that “description” field on the incidents was containing an invalid ASCII symbol,called “VT”. Imagine field “description” as a field available on a random ITIL platform where the users enters the full incident description.

Continue reading “Excel found unreadable content when exporting a SSRS report”