IntroductionWith the 1702 release of Configuration Manager, Microsoft released (pre-release) the Data Warehouse service point that can be used to report on long-term historical data. And with the 1706 release, this feature is no longer a pre-release feature.Setting up the Data Warehouse feature is pretty much straight forward, but depending on your environment you might see some challenges.Prerequisites and Installation guide can be found here: https://docs.microsoft.com/en-us/sccm/core/servers/manage/data-warehouseThe Remote SQL challengesLast week I was asked to setup a new Data Warehouse server for one of my customers. The Data Warehouse Database should be hosted on a new dedicated SQL Server 2016.Setup:SERVER1 (Primary…
Browsing: SQL Reporting Services
If you run System Center 2012 Configuration Manager and wants to use the Report Builder from a remote console, you might see the following error message: Unable to connect to data source The certificate chain was issued by an authority that is not trusted ——————————– A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider: 0 – The certificate chain was issued by an authority that is not trusted.) To fix this little issue you need to do the following: Export the required certificate: On the Site Server (or the…
Microsoft System Center Configuration Manager 2007 Dashboard lets customers track application and operating system deployments, security updates, the health status, and IT compliance with key regulations—with an easy to use, customizable Web interface. Because the Dashboard is built on Windows SharePoint Services, IT staff can access information without using the Configuration Manager console. Overview IT Challenges IT administrators and IT support staff need easier access to key information about software and operating system deployments, client health, and compliance with regulations. They must ensure that their systems and software meet the configuration requirements established for the organization. And they need the…