I am a beginning programmer and am tying to add a database to my visual basic 2005 express program. Following the add items and selecting the sqldatabase icon (and change the name) I get the following message:
"Generating user instances in SQLServer is disabled. Use sp-configure 'user instances enabled' to generate user instances".
I have downloaded SQL Management Studio, started a query that stated: " sp_configure 'user instances enabled','1' " Reconfigure. Even though i type Reconfigure I get a message below stating:
"Configuration option 'user instances enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
I always type RECONFIGURE. I guess thats not good enought. What does it mean by Run the RECONFIGURE statement to install? What do I do?
Thanks for your help in advance,
View Complete Post