Groups | Blog | Home
all groups > sql server msde > august 2006 >

sql server msde : SQL 2000 & 2005 on the same server


Dave
8/9/2006 10:07:26 AM
I have a client which is using SQL 2005 Express (for WSUS) and is now
looking at a package which uses MSDE 2000.

Can I put it on the same server?

Any help is greatly appreciated!

Dave

Arnie Rowland
8/9/2006 10:21:39 AM
They can both reside on the same server. However, you should check with the
application provider to determine if the application is capable of using a
'named' instance -or must it use the 'default' instance. (The first SQL
Server installed is the 'default' instance.)

If the application must use the default instance, then you could remove SQL
Server 2005 Express, and all other entries in the [Add or Remove Programs]
applet that have SQL in their name, i.e., "SQL Server", "XMLSQL", etc. Then
install the MSDE package, and after that is running, install SQL Server 2005
Express Edition. WSUS 'should' not have any problem using the then 'named'
instance of SQL Server.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


[quoted text, click to view]

AddThis Social Bookmark Button