Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2012-04-12
3
Medium Priority
?
303 Views
Last Modified: 2012-04-17
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.
0
Comment
Question by:mikealsweiler
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
DBAduck - Ben Miller earned 2000 total points
ID: 37841144
They should run side-by-side because it will be another instance name which would make it unique to the machine.
0
 

Author Comment

by:mikealsweiler
ID: 37841223
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
 
LVL 25

Expert Comment

by:DBAduck - Ben Miller
ID: 37842364
No it will pick its own port
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question