SCCM Upload RDL File to Report Server

Benoit LecoursSCCM, SSRS62 Comments

SCCM Reporting is a great way to see insight of your inventory and data. There’s many custom reports out there on the internet. If you download a custom report, you’ll have a RDL file. This RDL then need to be uploaded on your report server. You can do it manually using the web portal or use a script. This post will show all the ways you can upload an RDL file on an SCCM Reporting Point. An RDL file is simply an XML application and a standard proposed by Microsoft for defining reports. SCCM Upload RDL file Requirements SSRS installed and all running components. If you don’t have a reporting server, you can refer to our post on how to install SCCM 2012 Reporting Services Point. A healthy RDL file. A user account with enough access to upload a report. Please read predefined roles on MSDN for more detailed information. Upload the RDL … Read More

How to upgrade SCCM SQL version

Jonathan LefebvreSCCM, SQL6 Comments

SQL Server is obviously a key component to take care of, for a healthy SCCM infrastructure. While SCCM supports a wide variety of SQL Server versions, keeping it up to date may be a good idea to avoid getting out of support. In this post, we will detail how to upgrade SCCM SQL 2014 to SQL 2017. SQL 2019 is available for a couple of weeks, but it’s still not listed as supported in the SCCM documentation. If you’re looking to install SQL 2017 from scratch, jump to our post on this topic. Upgrade SCCM SQL version Requirements Current SQL versions must be one of the following : SQL Server 2008 SP4 or later SQL Server 2008 R2 SP3 or later SQL Server 2012 SP2 or later SQL Server 2014 or later SQL Server 2016 or later Download SQL reporting services Download SQL Management studio The operating system is still … Read More