I'm just starting out and trying to connect toÃÂ my firstÃÂ database using the following string:
Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RFPdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
I get the following error during debug:
"Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."
I've done this on every database - Master, Model, Tempdb, etc, and my database.
Still get the error.ÃÂ I may not be enabling it correctly.ÃÂ Any help would be appreciated.
The documentation suggests that I use user instances so that users without Admin rights can work with the database.ÃÂ Add, delete, edit data.ÃÂ Is this true?
View Complete Post