FIX: "TempDB file size exceeds 1024 MB" error when you try to set the initial size for a TempDB file to a value greater than 1,024 MB

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


When you try to set the initial size for a TempDB file to a value that's greater than 1,024 MB on the TempDB tab during a product installation, the value is not set and you receive an error message that resembles the following:

Resolution


This fix is included in Service Pack 2 for SQL Server 2016.

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 Microsoft uses to describe software updates.