Co-Existence of MSDE Instances

My server has an instance of MSDE that was installed by the VERITAS backup
software.I have a new application now thats to be deployed which will need
MSDE,Is it ok to load another instance of MSDE for the new application or can
I use the one instance to run both VERITAS and the New application...any
suggestions will be much appreciated.
Thank you all.
hi Maverick,
"maverick" <maverick@.discussions.microsoft.com> ha scritto nel messaggio
news:2239EDC1-15D6-4F6E-B0DC-093D5199D97E@.microsoft.com...
> My server has an instance of MSDE that was installed by the VERITAS backup
> software.I have a new application now thats to be deployed which will need
> MSDE,Is it ok to load another instance of MSDE for the new application or
can
> I use the one instance to run both VERITAS and the New application...any
> suggestions will be much appreciated.
> Thank you all.
as you already know, technically you can install up to 16 MSDE/SQL Server
instances on the same server... only 1 instance can be the default
instances, where all others will be named instances..
legally, it's all another story.
since MSDE has become rellay free, the original constraint that each ISV
MUST install his/her own instance has become obsolete, but....
but each ISV can legally protect his/her own installed instance so that it
can not be used by other applications/external databases
so you have to check Verits documentation or directly ask them for such an
info
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You don't really want to share another application's instance anyway. What
is the SA password they are using? Even if you are granted access (which I
doubt), what happens when the software is updated and they replace the
database or you uninstall the application and the database (and the MSDE)
instance is removed?
No, you really should install your own instance until we get to SQL Express
which does suggest/encourage use of a common instance.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2q2sltFqoea4U1@.uni-berlin.de...
> hi Maverick,
> "maverick" <maverick@.discussions.microsoft.com> ha scritto nel messaggio
> news:2239EDC1-15D6-4F6E-B0DC-093D5199D97E@.microsoft.com...
> can
> as you already know, technically you can install up to 16 MSDE/SQL Server
> instances on the same server... only 1 instance can be the default
> instances, where all others will be named instances..
> legally, it's all another story.
> since MSDE has become rellay free, the original constraint that each ISV
> MUST install his/her own instance has become obsolete, but....
> but each ISV can legally protect his/her own installed instance so that it
> can not be used by other applications/external databases
> so you have to check Verits documentation or directly ask them for such an
> info
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Well, it worked for me. I installed the MSCRM Outlook Sales client on my
laptop. It installs MSDE for it's database.
They I installed Microsoft Small business Manager which will also create a
MSDE database.
It worked and the machine did not complain too much.
But beyond that I did not do much.
Also this worked with full SqL and MSDE on the same laptop.
MSDE supported Sales Outlook Client for MSCRM and I had the Great Plains 7.5
running and connecting the client to the full MSSQL Databases.
I slowed the laptop down but that was about it.
Hope that helps.
"maverick" wrote:

> My server has an instance of MSDE that was installed by the VERITAS backup
> software.I have a new application now thats to be deployed which will need
> MSDE,Is it ok to load another instance of MSDE for the new application or can
> I use the one instance to run both VERITAS and the New application...any
> suggestions will be much appreciated.
> Thank you all.
|||With the MSDE, you are encouraged to run your application in its own
instance. This also avoids issues with administrative passwords, etc. In the
future (with SQL Express), the situation changes though and you'll be
encouraged to use the single SQLExpress instance.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Curt Spanburgh" <CurtSpanburgh@.discussions.microsoft.com> wrote in message
news:D42533B2-F027-40F4-B2B8-E05E3299857F@.microsoft.com...
> Well, it worked for me. I installed the MSCRM Outlook Sales client on my
> laptop. It installs MSDE for it's database.
> They I installed Microsoft Small business Manager which will also create a
> MSDE database.
> It worked and the machine did not complain too much.
> But beyond that I did not do much.
> Also this worked with full SqL and MSDE on the same laptop.
> MSDE supported Sales Outlook Client for MSCRM and I had the Great Plains
7.5[vbcol=seagreen]
> running and connecting the client to the full MSSQL Databases.
> I slowed the laptop down but that was about it.
> Hope that helps.
>
> "maverick" wrote:
backup[vbcol=seagreen]
need[vbcol=seagreen]
or can[vbcol=seagreen]