Search

Monday, August 6, 2012

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

To solve this issue, please follow the following steps:


1. Start the SQL Server Management Studio Express.
2. Connect to the default instance of that server (Your Machine Name\SQLEXPRESS)
3. Then open a New Query Window. Please check that you are connecting to the master database
4. Type: exec sp_configure ‘user instances enabled’, 1
5. Type: RECONFIGURE
6. Restart the SQL Server

No comments:

Post a Comment