Solved

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

Posted on 2012-04-12
3
298 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
  • 2
3 Comments
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 500 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 24

Expert Comment

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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

820 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