I was recently creating a web application in Visual Web Developer 2005 and I needed to create a database through the ASP.NET Configuration interface. When I opened the Security tab, I got the following error:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled’ to generate user instances.

Its not really clear how to fix that problem from the error message, so I did a search on Google and found the following solution.

Run the SQL Server Management Studio Express application and press the New Query button (or press Ctrl-N). Enter the following in the query editor:

exec sp_configure 'user instances enabled', 1
reconfigure

Execute the query and then restart the SQL Server database. You should be able to create the database now for your ASP.NET application.

Related posts:
	Who Is Hosting This? How to Uncompress Files in Linux Stopping Spam on phpBB How Much Money Are You Worth?

Share this post:

               

Follow Me:

Did you find this post interesting and useful? You can keep up to date on this blog by subscribing to my RSS feed, or you can have new posts sent to you by e-mail. You can also see what I'm up to by following me on Twitter or Facebook.

No Comments »

Trackback This Post | Subscribe to the comments through RSS Feed