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

Ekrem Önsoy December 8, 2018 MSSQL

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.

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux