View Single Post
  #4 (permalink)  
Old December 7th, 2009, 03:15 PM
Lee Dumond's Avatar
Lee Dumond Lee Dumond is offline
Wrox Author
Points: 4,942, Level: 29
Points: 4,942, Level: 29 Points: 4,942, Level: 29 Points: 4,942, Level: 29
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2008
Location: Decatur, IL, USA.
Posts: 923
Thanks: 12
Thanked 166 Times in 162 Posts
Default

When installing SQL Express 2008, the default instance name is SQLEXPRESS.

Unfortunately, this is the same default as SQL Express 2005. That means if you have SQL 2005 Express installed, you probably already have an SQLEXPRESS instance, which is a conflict.

The trick is, when installing SQL Express 2008, to change the name of the default instance to something different. Mine is named SQLEXPRESS2008.

I have SQL 2005 Express, SQL 2005 Developer, SQL 2008 Express, and SQL 2008 Developer on my main machine, and they all work.
__________________
Visit my blog at http://leedumond.com
Follow me on Twitter: http://twitter.com/LeeDumond

Code:
if (this.PostHelpedYou)
{
   ClickThanksButton(); 
}
The Following User Says Thank You to Lee Dumond For This Useful Post:
kneten73 (December 8th, 2009)