If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > SQL Server 2000 and 2005 Express on the same machine?

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 08-22-06, 08:42
Coolberg Coolberg is offline
Registered User
 
Join Date: Jul 2002
Posts: 225
SQL Server 2000 and 2005 Express on the same machine?

Can I install SQL Server 2005 Express Edition on the same server where I already have SQL Server 2000 Enterprise Edition?

Doing this also includes replacing .Net Framework 1.1 with 2.0, could that cause any disturbances to the already existing SQL Server 2000 ?

(None of these two databases are heavy production databases)
Reply With Quote
  #2 (permalink)  
Old 08-22-06, 11:24
KamenG KamenG is offline
Registered User
 
Join Date: Dec 2005
Posts: 57
I don't know about the Server software, although I believe reading a Microsoft document stating that you can do that, but as far as the .Net framework is considered - 2.0 is not an upgrade to 1.1, it is a rightful departure from it, and thus they will coexist very peacefully on the same computer. I'd search the Microsoft knowledge base about SQL Server 2000 and 2005 Express, there should be something authoritative about it there. I, too would be curious to find out how it actually works.
Kamen
Reply With Quote
  #3 (permalink)  
Old 08-22-06, 11:27
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 10,511
You can definitely run SQL 2000 and SQL 2005 on the same machine, but any one machine can only have one default (un-named) instance. As long as at least one of the two uses a named instance (which Express uses by default), you'll be fine.

-PatP
Reply With Quote
  #4 (permalink)  
Old 08-24-06, 05:25
Coolberg Coolberg is offline
Registered User
 
Join Date: Jul 2002
Posts: 225
So, having 2000 and 2005 in parallel is no more dramatic than having multiple 2000 instances then, in summary?

And, I saw some web page where someone said SP4 should be installed before installing SQL Server 2005. I'm not
sure if they meant SP4 of Windows or SP4 of SQL Server, though. Any ideas?

Last edited by Coolberg; 08-24-06 at 06:11.
Reply With Quote
  #5 (permalink)  
Old 08-24-06, 09:29
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 10,511
Technically SQL Server 2000 sp3a is required in order to install SQL 2005, but as long as the machine has less than 4 Gb of total RAM I really prefer to apply SQL 2000 sp4 and SQL 2005 sp1.

-PatP
Reply With Quote
  #6 (permalink)  
Old 08-24-06, 09:59
Coolberg Coolberg is offline
Registered User
 
Join Date: Jul 2002
Posts: 225
Eh... do you really mean "less than 4Gb", not "at least 4Gb" ?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On