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.

Go
Reconfigure
execute this query

Step 2. Deleting old files
Now 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

Enabled multiple instance in Sql Server. By:Tanuj Kumar Enabled multiple instance in Sql Server. By:Tanuj Kumar Reviewed by Tanuj on 6:28:00 am Rating: 5

No comments:

Powered by Blogger.