Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled’ to generate user instances.

Ekrem Önsoy

5 years ago

You may experience this error when you try to create a database by using Visual Studio or in another database-related job.

Execute the following script from SQL Server Management Studio.

EXEC sp_configure 'user instances enabled', 1;
GO
RECONFIGURE
GO

EXEC sp_configure 'user instances enabled', 1;

RECONFIGURE

This script will enable the “User Instances” option. So you won’t get this error.