Home >

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

4. March 2011

Problem:If you are getting the following error:
"Generating user instances in SQL Server is disabled.
Use sp_configure 'user instances enabled' to generate user instances" 
What should I do?
 
Answer:
To fix this, please 
1. Open the SQL Server Management Studio Express.
2. In the query editor type this text: exec sp_configure 'user instances enabled', 1.
3. Then type: Reconfigure.

Then restart the SQL Server database.

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading