Hi guys, I want to create a use sql membership for my website but am recieving this error when trying to create a database 'Generating user instances in SQL server is disabled'. I have even run the command (exec sp_configure 'user instances enabled') but I still get the error. Please help...
larsh 0 Newbie Poster
mono_jit23 1 Junior Poster in Training
Have you registered your sql database with asp.net?????
else you first run
regsql.exefrom visual studio command prompt.
larsh 0 Newbie Poster
I still get the error after doing that.
kouroshnik 0 Light Poster
are run Reconfigure after enable 'user instances'
when u type : exec sp_configure 'user instances enabled', 1 in query editor
then u must type : Reconfigure
and then restart the SQL Server database.
larsh 0 Newbie Poster
The problem is still there, Could it be because am using windows authentification for SQL?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.