Re: Distributing application that use MSDE

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 06/15/04


Date: Tue, 15 Jun 2004 13:31:44 +0200

hi Dan,
"Dan" <ddeward@msn.com> ha scritto nel messaggio
news:686970bc.0406141634.30e23b96@posting.google.com...
> Hi,
>
> When distributing an application that uses MSDE, should you install
> your application databases into a named instance or into the default
> instance? Are there any guidelines on when to create a named instance
> versus using the default one?

you usually have to ask your user... since MSDE is now free, you are not
obliged from Miscrosoft to create a new instance for each ISV relased
application...
but ISVs can "protect" with a personal EULA asserving their installed
instance only to their application...

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.8.0  -  DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply


Relevant Pages

  • Re: Multi-Boot and sharing MSDE data?
    ... I would like to install ... I would like to share a common location for the MSDE ... > Is there any way to share a DataDir location? ... databases, so you do are not allowed to share the DataDir among instances... ...
    (microsoft.public.sqlserver.msde)
  • Re: question about patching MSDE 2000
    ... >So it's a named instance? ... Are you applying the patch to ... To install a named istance MS documentation says to add to ... MSDE 2000 using a file different than sqlrun01.msi and I ...
    (microsoft.public.sqlserver.security)
  • Re: Change default to named instance??
    ... Take a backup of all databases ... Stop SQL Server and copy the MDF and LDF to a safe place ... Un Install the MSDE ... > conflicts with other app's msdes, I now want to use a named instance. ...
    (microsoft.public.sqlserver.msde)
  • Re: Named Instance, Connectivity Question
    ... with SQL Server 2000 Client ... I installed MSDE 2000 under Named Instance. ... yes, you can install only a named instance, only a default instance, or upt ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE
    ... can you please post your command line you used to install MSDE? ... I've just installed an MSDE named instance on a brand new ... and that installed a named instance named "MSDE", allowing SQL Server ...
    (microsoft.public.sqlserver.msde)