Side by side install of MSDE and SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Joseph Geretz (jgeretz_at_nospam.com)
Date: 04/02/04 

Date: Thu, 1 Apr 2004 19:53:16 -0500

My app needs to support both SQL Server and MSDE. So on my SQL Server box, I
just installed a new instance of MSDE, named MacName\MSDE, so that I can
test my app against both SQL Server and MSDE.

Question. Given that the machine is fully licensed for SQL Server, is the
MSDE instance actually an MSDE instance (that is constrained by the
limitations of MSDE), or is this actually just another SQL Server instance
named MSDE? (Frankly, in Enterprise Manager, except for the name of the
instance, I'm hard pressed to see any difference between the default SQL
Server instance and the MSDE instance.)

Thanks for your advice.

- Joe Geretz -

Relevant Pages

  • RE: Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC
    ... MSDE 2000 is supported. ... Microsoft Developer Support - Web Data ... Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Upsizing to SQL Server
    ... We are migrating from Jet to MSDE with Access 2000. ... Should we be able to support the same number of concurrent ... > you have SQL server licenses for everyone. ... The limitation was probably ...
    (microsoft.public.access.conversion)
  • Re: Need help & support regarding MBSA 2.1 beta 2
    ... Issue: Local Account Password Test ... Check is skipped on Windows XP Home Edition computers. ... SQL Server and/or MSDE authentication mode is set to Windows ...
    (microsoft.public.security)