Wednesday, April 11, 2007

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

Just in case you ran into the same problem: 1. Open the SQL Server Management Studio Express. This is the downloadable program in the same site where you downloaded the SQL Server 2005 express used to manage SQL Server 2005 Express. 2. In the query editor type this text (everything between the double quotes): "exec sp_configure 'user instances enabled', 1" 3. Execute the query, e.g. by clicking the "Execute" button. 4. Clear the query window, then type (everything between the double quotes): "Reconfigure" 5. Execute the query. 6. Then restart the SQL Server database, e.g. in SQL Server Configuration Manager or by simply restarting the service in the control panel. This solution is based on a forum entry by 'kabalweg' I found at an MSDN SQL Server Forum. And yes, it did work for me. And yes it works for both SQL Server 2005 and SQL Server 2005 Express.


Post a Comment

All comments, questions and other feedback is much appreciated. Thank you!