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
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…
When you first install the Reporting Services Point in System Center 2012 R2 Configuration Manager (SCCM), it comes with 468 built in reports, and all these great reports uses the default System Center banner. The default banner is a really nice banner, but I often get the question from some of my customers “How to we replace the default SCCM report banner with our company branded banner?”. So I decided to make this blog post that explains how this can be done. Actually, it’s a really simple task, but it can’t be done directly from the UI. First we need…
When you install a new ConfigMgr 2012 site, you should always use the latest supported SQL Service Pack and Cumulative update, and I just noticed that Cumulative update package 6 for SQL Server 2008 R2 Service Pack 1, has been released. The build number of this cumulative update package is 10.50.2811.0. You can download the update here: http://support.microsoft.com/kb/2679367/ If you always want to be up-to date on your SQL versions and releases, I would recommend that you follow this blog: http://sqlserverbuilds.blogspot.com/ Enjoy.
The current supported configuration of SQL Server for System Center 2012 Configuration Manager (SCCM), is Microsoft SQL Server 2008 R2 with Service Pack 1 and Cumulative Update 4. I always use unattended installation of SQL (and anything else if possible). Here are the command lines I uses to setup SQL for ConfigMgr 2012: SQL Server 2008 R2 RTM Setup: setup.exe /q /ACTION=Install /ERRORREPORTING=”False” /FEATURES=SQLENGINE,RS,AS,IS,SSMS,TOOLS,BIDS,ADV_SSMS,CONN /INSTANCENAME=MSSQLSERVER /INSTANCEDIR=D:MSSQL /SQLSVCACCOUNT=”NT AUTHORITYSystem” /SQLSYSADMINACCOUNTS=”BUILTINADMINISTRATORS” /SQLSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT=”NT AUTHORITYSYSTEM” /AGTSVCSTARTUPTYPE=Automatic /RSSVCACCOUNT=”NT AUTHORITYSystem” /RSSVCSTARTUPTYPE=Automatic /ASSVCACCOUNT=”NT AUTHORITYSystem” /ASSVCSTARTUPTYPE=Disabled /ASSYSADMINACCOUNTS=”BUILTINADMINISTRATORS” /ISSVCACCOUNT=”NT AUTHORITYSystem” /ISSVCSTARTUPTYPE=Disabled /ASCOLLATION=”Latin1_General_CI_AS” /SQLCOLLATION=”SQL_Latin1_General_CP1_CI_AS” /TCPENABLED=”1″ /NPENABLED=”1″ /IAcceptSQLServerLicenseTerms SQL Server 2008 R2 SP1 Setup: SQLServer2008R2SP1-KB2528583-x64-ENU.exe /Action=Patch /IAcceptSQLServerLicenseTerms…
Microsoft has released Service Pack 2 to SQL Server 2008. More details and the download are available from the following link: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17 Note: New service packs to SQL Server is usually supported with System Center Configuration Manager within 30 days of the release.
System Center Configuration Manager 2007 SP1 and SP2 now support Microsoft SQL Server 2008 R2 as a Configuration Manager 2007 site database. System Center Configuration Manager 2007 R2 now supports Microsoft SQL Server 2008 R2 Reporting Services. No software updates are required. Source and more Configuration Manager Support Announcements for June 2010 here.
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…
Microsoft Corp. today announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence platform. This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services. SQL Server 2008 provides the trusted, productive and intelligent platform necessary for business-critical applications. Continue at source. SQL Server 2008 is now available to MSDN and TechNet subscribers and will be available for evaluation download on Aug. 7, 2008. SQL Server 2008 Express and SQL Server Compact…