ProLiant Servers (ML,DL,SL)
cancel
Showing results for 
Search instead for 
Did you mean: 

MSDE 2000 and SQL 2005 Express on one machine

 
Mark_672
Advisor

MSDE 2000 and SQL 2005 Express on one machine

Is it possible to have these two services on one machine? I notice that my server(Proliant ML 370 G4 with Windows 2000 Server) requires MSDE 2000 SP3a (for Insight Manager) and don't know it there will be a conflict if I will install it (or is it possible to have these on the same machine) or I will just install the 2005 version since it was the replacement of MSDE. Hoping for your response.
4 REPLIES
Igor Karasik
Honored Contributor

Re: MSDE 2000 and SQL 2005 Express on one machine

Mark,
SQL 2005 and SQL 2000 can be installed on same server, I think MSDE 2000 and SQL 2005 Express will work on same server as well.
Regarding SQL 2005 and Insight manager 5 see David Claypool answer in this thread
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=990006
Mark_672
Advisor

Re: MSDE 2000 and SQL 2005 Express on one machine

I just receive a reply from MSNewsgroup and he posted that MS SQL Server 2005 express edition attempts to upgrade MSDE. Need comment on this.
Igor Karasik
Honored Contributor

Re: MSDE 2000 and SQL 2005 Express on one machine

Mark,
I think you can install SQL 2005 Express as another Named Instance
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
"Multiple SQL Server 2005 Express installations can coexist on the same machine along with other installations of SQL Server 2000, SQL Server 2005, or Microsoft Desktop Engine (MSDE) "
and
"1.1.6 Upgrading MSDE to SQL Server Express"
in http://support.microsoft.com/default.aspx?scid=kb;en-us;910229
Anyway, you need to test it in the lab.
Mark_672
Advisor

Re: MSDE 2000 and SQL 2005 Express on one machine

thanks for the info. i will read on this and will post info.