Problem solve Get help with specific problems with your technologies, process and projects.

SQL Server and MSDE version compatibility

SQL Server 2005 Expert Adam Machanic explains the version compatibility between SQL Server and other servers such as MSDE.

I am having difficulty finding version compatibility information for the many versions of SQL Server. Can two different versions of SQL and/or Microsoft SQL Server Database Engine (MSDE)/Windows MSDE co-exist on one server? I have two applications that utilize MSDE (2000) and Windows Server Update Services (WSUS) wanting WMSDE.
As of SQL Server 2000, and continuing with SQL Server 2005, all versions are effectively compatible and can safely co-exist on the same server using separate named instances. This applies to both the core database engine and MSDE, as well as the newer SQL Server Express.

You might also want to read the following link, which presents an overview of some differences between the editions: Sharepoint Services

This was last published in May 2006

Dig Deeper on Microsoft SQL Server 2005

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.