When running the prerequisite check before upgrading SCCM to the newest releases you might see the following warning (this is taken from 1812): Warning details: SQL Server Native Client version [Completed with warning]:Verifies that the version of Microsoft SQL Server Native Client installed on the site server meets the minimum
If you choose to do an in place upgrade of SQL 2012 to SQL 2014 on your SCCM server, you might see this error when trying to run a report: Failed to load expression host assembly. Details: Could not load file or assembly ‘SrsResources, Culture=neutral’ or one of its dependencies.
If you choose to do an in place upgrade of SQL 2012 to SQL 2014, you might see this error when trying to access the report server: The version of the report server database is either in a format that is not valid, or it cannot be read. The found
I know this is old news, but I have seen the problem on various sites so now it’s time to write a short post about the issue. You may find that the SQL Server Reporting Services (SSRS) log database ReportServer_log.ldf file is using almost all diskspace. The reason for this
Today I will take a look on how we detect if our SCCM installation is running on a SQL 2012 evaluation version. The first thing we will have to do is to start SQL Server Management Studio: Connect to the server. Right click on the SQL server name and select
This time lets take a closer look at how we change our SCCM SQL 2012 server from an evaluation version to a standard version (ignoring downgrade warning). Identifying if SCCM is running on SQL evaluation version Why standard you may ask, that’s because its free when you are correctly licensed
When installing SCCM 2012 R2 you might see an error like this in the Prerequisite Check. SQL Server service running account The logon account for the SQL Server service cannot be a local user account, NT SERVICE<sql service name> or LOCAL SERVICE. You must configure the SQL Server service to
When installing SCCM 2012 R2 you might see this error: Required SQL Server Collation Configuration Manager requires that you configure your SQL Server instance and Configuration Manager site database (if already present) to use the SQL_Latin1_General_CP1_CI_AS collation, unless you are using a Chinese operating system and require GB18030 support. For
I often need to know the current version of a SQL 2012 installation to determine if it need an update. This KB includes a number of ways to do the work How to determine the version and edition of SQL Server and its components Latest update is Cumulative Update 4
You might see this error when trying to configure SQL Reporting Services after installation. User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. The problem is that UAC is active. We do not want to disable
I sometimes need a quick overview of the latest SQL server builds, while the information is available on different sites I have found this particular site to be very helpful. http://sqlserverbuilds.blogspot.com/ You might also be able to use this resource in your daily work
Modern Workplace consultant and a Microsoft MVP in Windows and Devices.
Infrastructure architect with focus on Modern Workplace and Microsoft 365 security.
Cloud & security specialist with focus on Microsoft backend products and cloud technologies.
Cloud & Security Specialist, with a passion for all things Cybersecurity
Cloud and infrastructure security specialist with background in networking.
Infrastructure architect with focus on design, implementation, migration and consolidation.
Infrastructure consultant with focus on cloud solutions in Office365 and Azure.
Modern workplace and infrastructure architect with a focus on Microsoft 365 and security.
