Enabled multiple instance in Sql Server. By:Tanuj Kumar

You must have Sql server express installed in your system

Step 1. Enabling User Instances on your SQL Server installation.First we are  make sure we have enabled User Instances for SQL Server 2005 installation.

Go to Query Window in SQL Server Management Studio and type this:

exec sp_configure 'user instances enabled', 1.

GoReconfigure

execute this query

Step 2. Deleting old filesNow we need to delete any old User Instances.

Go to your C drive and find and completely DELETE this path (and all files inside):

C:\Documents and Settings\YOUR_USERNAME\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

After deleting this folder you can go to Visual Studio2008, create ASP.NET Web Site and click on your App_Data folder and choose Add New Item and then choose SQL Server Database2005 and it should work!

Posted By:Tanuj Kumar 

On:Shareyourconscience