Skip to main content

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

Labels:

Comments

Post a Comment

Popular posts from this blog

Join the Beauty Course for Massage Beauty License Training

Massage Beauty School of California: Massage beauty program is one of the top ten beauty courses which are well recognized and sought after in the beauty sector. Several students from various cities and states enroll in this training program to get better learning opportunities and understand the minute technicalities of beauty massaging services. Certified schools and beauty institutes located in Los Angeles are offering cutting-edge training to the students who are eligible for the program. Palace Beauty College is an accredited beauty school that does offer a massage therapy program and also offers holistic learning facilities to the students. The college has years of experience in providing massage therapy license training in Los Angeles for more than half a decade now. The college maintains its official website to reach out to distant students and provide them relevant information related to the available beauty courses. The college takes pride in its impressive infrastru...
Post a Comment
Explore More »

Former President APJ Abdul Kalam Died at 83

"Missile Man is no more" A.P.J Abdul Kalam died in Shillong. He was brought into the hospital without a pulse or BP. There was no sign of life John Sailo Ryntathiang, director of Bethany Hospital," told the Quint. About Abdul Kalam: Abdul Kalam was an Indian scientist who was the 11th President of India from 2002 to 2007. Kalam was born and raised in Rameswaram(Tamil Nadu) and studied physics and aerospace engineering. He worked as a scientist and science administrator, mainly at the Defence Research and Development Organisation (DRDO) and Indian Space Research Organisation (ISRO) before he became president. The Centre has declared national mourning for seven days. Kalam served as president for five years from 2002, enjoying the support of both the ruling BJP and the opposition Congress. He graduated from Saint Joseph's College, Tiruchirappalli in 1954 but not satisfied with his degree, he left for Madras later next year to study aerospace engineering. He enrolled ...
Post a Comment
Explore More »

Cryptocurrency: The future currency and bitcoin investment

What is Cryptocurrency? Cryptocurrency is a digital or virtual currency that uses cryptography for security. A cryptocurrency is a medium of exchange that uses cryptography to secure transactions and control the creation of additional units. Cryptocurrency uses a decentralized system of records called a blockchain to track transactions instead of using a traditional database like a conventional currency. The crypto world is full of surprises. New coins and tokens are being launched almost every day. Some of these go on to change the world, while others will fizzle out and be forgotten. It’s impossible to predict which ones will thrive and which ones will fail, but crypto is a great way to keep up with the latest developments in technology and finance. Cryptocurrency is a digital or virtual currency that uses cryptography for security. A cryptocurrency is difficult to counterfeit because of this security feature. A defining feature of a cryptocurrency, and arguably its most alluring ass...
Post a Comment
Explore More »