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...

Have you registered your sql database with asp.net?????
else you first run

regsql.exe

from visual studio command prompt.

I still get the error after doing that.

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.

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.