locked
SharePoint server 2019 CU configuration failed RRS feed

  • Question

  • Hey all,

    I'm trying to run the config wizard after installing the following updates:

    However I'm running into the following error when running the SharePoint Products configuration wizard.

    I've checked the database compatibility levels in SQL server and these are set to 120....

    Any ideas anyone?

    Log error:

    07/13/2020 17:23:52  12  ERR                  Exception: System.Data.SqlClient.SqlException (0x80131904): Valid values of the database compatibility level are 100, 110, or 120.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command, SqlInfoMessageEventHandler handler)
       at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)
       at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.ExecuteDataDefinitionMethodCore(SqlSession sqlSession, ISqlSession isqlSession, String sqlscript, SPLog log)
       at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.fixDBCompatLevel(SqlSession sqlsession, SPLog log)
       at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.Upgrade()
       at Microsoft.SharePoint.Upgrade.SPDatabaseWssSequence.Upgrade()
       at Microsoft.SharePoint.Upgrade.SPUpgradeSession.RunUpgraders(Object o, List`1 lstClass)
       at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)
       at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean recursively)
       at Microsoft.SharePoint.Administration.SPDatabase.Upgrade(Boolean recursively)
       at Microsoft.SharePoint.Upgrade.SPManager.BootStrap(Guid sessionId, SPUpgradeOperationFlags flags)
       at Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.Run()
       at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()
    ClientConnectionId:dda71465-a733-4397-8803-36079a93c95a


    • Edited by boozi00 Monday, July 13, 2020 4:31 PM
    Monday, July 13, 2020 4:30 PM

Answers

  • Hi boozi00,

    As Sharath suggests, change the compatibility level of a database in the SQL Server by using SQL Server Management Studio or Transact-SQL, following this document.

    After that, run the SharePoint Configuration Wizard again.

    Please note that the minimum software requirements for SharePoint Server 2019 is a Standard or Enterprise Edition of SQL Server for Windows that supports database compatibility level 130, which includes SQL Server 2016 or higher.

    Best regards,

    Chelsea Wu


    "SharePoint" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

    Tuesday, July 14, 2020 5:49 AM

All replies

  • SharePoint Server 2019 supports SQL compatibility level 130 and correctly creates the databases with this compatibility level. follow below article to upgrade your SQL Server Compatability.

    https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver15

    Thanks & Regards,


    sharath aluri

    Monday, July 13, 2020 6:45 PM
  • Hi boozi00,

    As Sharath suggests, change the compatibility level of a database in the SQL Server by using SQL Server Management Studio or Transact-SQL, following this document.

    After that, run the SharePoint Configuration Wizard again.

    Please note that the minimum software requirements for SharePoint Server 2019 is a Standard or Enterprise Edition of SQL Server for Windows that supports database compatibility level 130, which includes SQL Server 2016 or higher.

    Best regards,

    Chelsea Wu


    "SharePoint" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

    Tuesday, July 14, 2020 5:49 AM
  • It has come to light that the version of SQL Server installed was 2014. The initial installation of the farm using SQL Server 2014 was fine, however upon trying to install the latest CU it seems to be conflicting therefore I will attempt to upgrade to SQL Server 2016.

    Please note, I tried sharath attempt to alter the database compatibility but 130 was unavailable due to SQL Server 2014.

    Friday, July 17, 2020 10:00 AM