MSDE Opinions

My software currently runs on Access 2000 Engine. The database is 600 MB and
I can have up to 10 users (6 constantly). I currently run a terminal server
to share out access database. it is Dual XEON 2.8 Ghz with 4 GB RAM.
Is MSDE an option for my setup?
Would I need a second Database server?
Do I need to go all the way up to SQL 2000?
Our software company tells me that MSDE only can handle 10 connections. I
have read that that is not true. Are they basically trying to sell me full
blown SQL for nothing?
Opions greatly appreciated.
Chris
"Chris Blackwelder" <Chris Blackwelder@.discussions.microsoft.com> wrote in
message news:A1F1F198-3357-4657-A0F4-0F2EA7F2F84D@.microsoft.com...
| My software currently runs on Access 2000 Engine. The database is 600 MB and
| I can have up to 10 users (6 constantly). I currently run a terminal server
| to share out access database. it is Dual XEON 2.8 Ghz with 4 GB RAM.
|
| Is MSDE an option for my setup?
Yes.
| Would I need a second Database server?
No.
| Do I need to go all the way up to SQL 2000?
No.
|
| Our software company tells me that MSDE only can handle 10 connections.
Where did they get 10 from? That is a toatly made up number. 5 and 8 are at
least in the docs, but you can exceed them. I have tested heavy loads up to 26
and then my P2-333 server couldn't cope.
I
| have read that that is not true. Are they basically trying to sell me full
| blown SQL for nothing?
Yes, but don't be mad at them. My guess is they don't know better unless they
have load tested it themselvs. MS dosn't allow anyone to publish benchmarks and
there is no reason for MS to advertise them.
|
| Opions greatly appreciated.
I belive MSDE can handle just as much as Enterprise or any other flavor of SQL,
unless you need more than 2Gig of data or 4 CPUs. Here is my tests
http://fox.wikis.com/wc.dll?Wiki~MSD...ks~SoftwareEng
Carl K
sql

MSDE needs to be installed for BackupEXec

I have a windows 2003 ent server that we cannot install MSDE on.
If we run this from terminal services and a command line, we get nothing:
Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log
Not even a log file.
Does anyone have any suggestions?
Eric Sabo
NT Administrator
hi,
Sabo, Eric wrote:
> I have a windows 2003 ent server that we cannot install MSDE on.
> If we run this from terminal services and a command line, we get
> nothing: Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log
> Not even a log file.
> Does anyone have any suggestions?
I do not think MSDE setup is a viable solution via terminal session.. have
you tried locally connected to the server?
(FWIW, is BLANKSAPWD=1 mandatory? ... and you'll get an instance without
networkprotocols support..)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea is correct. The setup program for MSDE (and SQL Server for that
matter) needs to be done on the physical console of the machine it is being
installed on.
Jim
"Sabo, Eric" <sabo_e@.cup.edu> wrote in message
news:e$fzrbiBFHA.3976@.tk2msftngp13.phx.gbl...
>I have a windows 2003 ent server that we cannot install MSDE on.
> If we run this from terminal services and a command line, we get nothing:
> Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log
> Not even a log file.
> Does anyone have any suggestions?
> --
> Eric Sabo
> NT Administrator
>
|||I tried it this morning and got the same results from the console of the
machine.
Is there a way to complete remove MSDE?
It will not install.
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:OrjflHvBFHA.3096@.TK2MSFTNGP14.phx.gbl...
> Andrea is correct. The setup program for MSDE (and SQL Server for that
> matter) needs to be done on the physical console of the machine it is
> being installed on.
> Jim
> "Sabo, Eric" <sabo_e@.cup.edu> wrote in message
> news:e$fzrbiBFHA.3976@.tk2msftngp13.phx.gbl...
>
|||hi Eric,
Sabo, Eric wrote:
> I tried it this morning and got the same results from the console of
> the machine.
> Is there a way to complete remove MSDE?
> It will not install.
please have a look at
http://support.microsoft.com/default...;EN-US;Q290991 ...
this will not clear the Windows Installer related entries in the Windows
registry, that requires MSIZap.exe from the Platform SDK as reported in
http://support.microsoft.com/default...b;en-us;320873
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

msde licence

we get from a company installed at our customer sides an application using
msde in a win 2000 server (terminal) or higher network enwironment. We have a
lot of troubles because this application is going to let our application fail
often , and we get a lot of instability.
Hi rudolph,
Sorry, but dont' see a question here. Why do you think that the MSDE is
causing instability for your app?
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"rudolph" <rudolph@.discussions.microsoft.com> wrote in message
news:121817FD-B051-4D59-9690-BDD6DA952ADA@.microsoft.com...
> we get from a company installed at our customer sides an application using
> msde in a win 2000 server (terminal) or higher network enwironment. We
> have a
> lot of troubles because this application is going to let our application
> fail
> often , and we get a lot of instability.
|||Hi Greg!
My question is, that we have done out of a pervasive sql based application
an Interface to a small application. This small application is using msde in
a enviroment, we are using, win 2003 or winn200 Server with terminal clients.
The company, who has done the small aplication we are interfacing has
installed at our clients side either msde or MSSQL Server products, depending
on their stability.We have not been asked by them what they are going to
install I thought, that msde is a client product and not a server product. IS
msde a product which can run simitaniosly in our environment?
"Greg Low [MVP]" wrote:

> Hi rudolph,
> Sorry, but dont' see a question here. Why do you think that the MSDE is
> causing instability for your app?
> Regards,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "rudolph" <rudolph@.discussions.microsoft.com> wrote in message
> news:121817FD-B051-4D59-9690-BDD6DA952ADA@.microsoft.com...
>
>
|||hi Rudolph,
rudolph wrote:
> Hi Greg!
> My question is, that we have done out of a pervasive sql based
> application an Interface to a small application. This small
> application is using msde in a enviroment, we are using, win 2003 or
> winn200 Server with terminal clients. The company, who has done the
> small aplication we are interfacing has installed at our clients side
> either msde or MSSQL Server products, depending on their stability. We
> have not been asked by them what they are going to install I thought,
> that msde is a client product and not a server product. IS msde a
> product which can run simitaniosly in our environment?
I'm not Greg (hi Greg :D) but, again, I do not understand the "stability"
problems...
MSDE is one of the editions of SQL Server, limited some way, but shares the
same core functionnalities and features...
MSDE is not a client product as Access, it's a "scaled down" version of a
full blown "enterprise" DBMS, with built-in limitation for database size,
concurrent workloads, and so on...
as regard as your last question,
>IS msde a
> product which can run simitaniosly in our environment?
I should say yes, but your environment is not public , and of course it
all depends on your requirements..
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Rudolph,
And to add to what Andrea said, we've used it in that sort of environment
many, many times without issue.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:35pbuqF4pmdlaU1@.individual.net...
> hi Rudolph,
> rudolph wrote:
> I'm not Greg (hi Greg :D) but, again, I do not understand the "stability"
> problems...
> MSDE is one of the editions of SQL Server, limited some way, but shares
> the
> same core functionnalities and features...
> MSDE is not a client product as Access, it's a "scaled down" version of a
> full blown "enterprise" DBMS, with built-in limitation for database size,
> concurrent workloads, and so on...
> as regard as your last question,
> I should say yes, but your environment is not public , and of course it
> all depends on your requirements..
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

MSDE Installation via Terminal Services

I'm seeing some conflicting information and wanted to try to get it
clarified. The original release of MSDE 2000 couldn't be installed from a
Terminal Services session on a TS in Application Mode. The release notes
for MSDE 2000 Release A (which contains SP3A) still mention that there could
be problems installing via Terminal Services. But KB artcle 317268 says
that you can install SP2 via Terminal Services.
So the obvious question is, can I install MSDE 2000 Release A from a W2K3
Terminal Services session while in Application Mode?
Hal Berenson, President
PredictableIT, LLC
hi Hal,
Hal Berenson wrote:
> I'm seeing some conflicting information and wanted to try to get it
> clarified. The original release of MSDE 2000 couldn't be installed
> from a Terminal Services session on a TS in Application Mode. The
> release notes for MSDE 2000 Release A (which contains SP3A) still
> mention that there could be problems installing via Terminal
> Services. But KB artcle 317268 says that you can install SP2 via
> Terminal Services.
> So the obvious question is, can I install MSDE 2000 Release A from a
> W2K3 Terminal Services session while in Application Mode?
nope, AFAIK, but never tested sp4.. I "consolidated" the original
"impossibility" :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply