Member Avatar for larsh

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

  • 3 Contributors
  • 4 Replies
  • 108 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by larsh
Member Avatar for mono_jit23

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

regsql.exe

from visual studio command prompt.

Member Avatar for larsh

I still get the error after doing that.

Member Avatar for kouroshnik

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.

Member Avatar for larsh

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.