FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014

దీనికి వర్తిస్తుంది: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core మరిన్ని

Symptoms


When you try to install Service Pack 2 (SP2) for Microsoft SQL Server 2014, as a part of the upgrade steps, the upgrading script sqlagent100_msdb_upgrade.sql may fail, and you receive the following error messages:

Granting login access LoginName to msdb database...

A problem was encountered granting access to MSDB database for login '(null)'. Make sure this login is provisioned with SQLServer and rerun sqlagent_msdb_upgrade.sql  

Adding user UserName to SQLAgentUserRole msdb role...

Granting login access LoginName to msdb database...

A problem was encountered granting access to MSDB database for login '(null)'. Make sure this login is provisioned with SQLServer and rerun sqlagent_msdb_upgrade.sql  

Adding user UserName to SQLAgentUserRole msdb role...

Granting login access LoginName to msdb database...

A problem was encountered granting access to MSDB database for login '(null)'. Make sure this login is provisioned with SQLServer and rerun sqlagent_msdb_upgrade.sql

Msg 574, Level 16, State 0

CONFIG statement cannot be used inside a user transaction

Resolution


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 8 for SQL Server 2016 RTM

       Cumulative Update 5 for SQL Server 2016 SP1

       Cumulative Update 6 for SQL Server 2014 SP2

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.