SQL

Downgrade SQL server from Evaluation to Standard

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

Continue to read »

SCCM – SQL Server service running account error

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

Continue to read »

SCCM SQL database not using right Collation

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

Continue to read »

SSRS – User does not have required permissions

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

Continue to read »

Link: SQL Server Builds

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

Continue to read »
Search blog posts
Authors
Modern Workplace consultant and a Microsoft MVP in Enterprise Mobility.
Modern Workplace consultant and a Microsoft MVP in Windows and Devices for IT.

Infrastructure architect with focus on Modern Workplace and Microsoft 365 security.

Passionate IT professional with 20+ experience in IT architecture, consulting, and design. 

Cloud & security specialist with focus on Microsoft backend products and cloud technologies.

Infrastructure architect with focus on design, implementation, migration and consolidation.

Infrastructure consultant with focus on cloud solutions in Office365 and Azure.

follow us in feedly
Categories

Follow on SoMe