Running MSDE 2000 side-by-side with SQL Express 2008 on same machine

I would like to install SQL Express 2008 on a machine to host a database.

However, I have discovered that the customer's machine already has MSSQL 8.00.760 (MSDE) installed and running. It hosts a DB for an application, but nobody knows the security details / sa login, etc.

Is it possible to install SQL Express 2008 on the same machine and run it side-by-side with the existing MSDE instance?  If so, is there anything special that needs to be done or considered?

Thanks for your help.
mikealsweilerAsked:
Who is Participating?
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
They should run side-by-side because it will be another instance name which would make it unique to the machine.
0
 
mikealsweilerAuthor Commented:
Thanks, so installing MS SQL Server 2008 Express won't end up fighting over ports or anything due to it being a unique instance name?
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
No it will pick its own port
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.