MSDE and Installshield

I need a better installation procedure for my software, so I wanted to merge
the MSDE install into the main one. At the moment the Setup has been built
by a third part developer, who use Installshiled.
Problem is, he doesn't know which version of Installshield he needs. Someone
can give me a hint?
On Thu, 1 Jul 2004 16:18:40 +0200, Drizzt <drizzt.du@.libero.it> wrote:

> I need a better installation procedure for my software, so I wanted to
> merge
> the MSDE install into the main one. At the moment the Setup has been
> built
> by a third part developer, who use Installshiled.
> Problem is, he doesn't know which version of Installshield he needs.
> Someone can give me a hint?
From what I read, InstallShield 7 should be alright; maybe even 6.
Not related to MSDE, I am struggling with it, though: I am unable to
create simple Upgrade packages that replace a couple of files in an
installation. something that InnoSetup and InstallShield 5 do perfectly
well.
Stefan
|||When I last spoke to them, the installshield guys didn't have the bootstrapper out for MSDE. They still had the merge modules but be warned microsoft does not want you to continue that route. I even spoke with WISE Solutions and they also mentioned that
they were working on replacing the merge module for MSDE.. so something to keep in mind.
Thanks
dev
"Stefan M. Huber" wrote:

> On Thu, 1 Jul 2004 16:18:40 +0200, Drizzt <drizzt.du@.libero.it> wrote:
>
> From what I read, InstallShield 7 should be alright; maybe even 6.
> Not related to MSDE, I am struggling with it, though: I am unable to
> create simple Upgrade packages that replace a couple of files in an
> installation. something that InnoSetup and InstallShield 5 do perfectly
> well.
> Stefan
>
|||"dev_kh" <devkh@.discussions.microsoft.com> ha scritto nel messaggio
news:3014BFB6-1C09-49FB-BA4E-C21475CDD808@.microsoft.com...
> When I last spoke to them, the installshield guys didn't
> have the bootstrapper out for MSDE. They still had the merge
> modules but be warned microsoft does not want you to continue
> that route. I even spoke with WISE Solutions and they also mentioned
> that they were working on replacing the merge module for MSDE.. so
something to keep in mind.
Sorry, I got lost.
Our product must be a self-easy-installing one. I have no experience about
Installations packages, and the (external)guy who must build it needs
directions from me, as he have never installed MSDE before.
We need a tight integration between the two -installshield and MSDE- 'cause
in case of errors we need the installation to halt and report the error,
while now it simply goes on...
So, is there a simply solution? What are the methods commonly used for this?
Sorry to bother, but I really have no clues...
|||| So, is there a simply solution? What are the methods commonly used for this?
I plan on using InnoSetup. I have been using it for over a year - love it. I
have not used it for MSDE, but I plan to.
<quote>
Yes, we now know how to. But it has taken a *LOT* of effort to
integrate it into InnoSetup in such a way that it:
* Checks the existence of an earlier MSDE installation
* If found check if it was done from our software
* If not, install a new instance using Microsoft setup
* Make sure to use the correct MSI file during install
* Make sure to set all install parameters correct
* Start the MSDE after install
* Connect to MSDE and install database
* Make sure it works on all NT platforms (big problems on NT4)
* etc etc etc
We have probably spent one man-moth on this task alone... Bo
</quote>
http://fox.wikis.com/wc.dll?Wiki~Inn...ScriptMSDE~VFP
Carl K
|||So, do you have a workable solution for installing an app and MSDE or not?
TIA,
Paul
"Carl Karsten" <carl@.personnelware.com> wrote in message
news:%23dnKozoYEHA.3988@.tk2msftngp13.phx.gbl...
> | So, is there a simply solution? What are the methods commonly used for
this?
> I plan on using InnoSetup. I have been using it for over a year - love
it. I
> have not used it for MSDE, but I plan to.
> <quote>
> Yes, we now know how to. But it has taken a *LOT* of effort to
> integrate it into InnoSetup in such a way that it:
> * Checks the existence of an earlier MSDE installation
> * If found check if it was done from our software
> * If not, install a new instance using Microsoft setup
> * Make sure to use the correct MSI file during install
> * Make sure to set all install parameters correct
> * Start the MSDE after install
> * Connect to MSDE and install database
> * Make sure it works on all NT platforms (big problems on NT4)
> * etc etc etc
> We have probably spent one man-moth on this task alone... Bo
> </quote>
> http://fox.wikis.com/wc.dll?Wiki~Inn...ScriptMSDE~VFP
> Carl K
>
|||Personally, no.
If the Inno guys say it will fly, I have no reason to doubt them. They aren't
trying to sell me something - the beauty of open source software.
Carl K
"Paul McTeigue" <paul_mcteigue@.msn.com> wrote in message
news:%23vGPGesYEHA.2816@.TK2MSFTNGP11.phx.gbl...
| So, do you have a workable solution for installing an app and MSDE or not?
|
| TIA,
| Paul
|
| "Carl Karsten" <carl@.personnelware.com> wrote in message
| news:%23dnKozoYEHA.3988@.tk2msftngp13.phx.gbl...
| >
| > | So, is there a simply solution? What are the methods commonly used for
| this?
| >
| > I plan on using InnoSetup. I have been using it for over a year - love
| it. I
| > have not used it for MSDE, but I plan to.
| >
| > <quote>
| > Yes, we now know how to. But it has taken a *LOT* of effort to
| > integrate it into InnoSetup in such a way that it:
| > * Checks the existence of an earlier MSDE installation
| > * If found check if it was done from our software
| > * If not, install a new instance using Microsoft setup
| > * Make sure to use the correct MSI file during install
| > * Make sure to set all install parameters correct
| > * Start the MSDE after install
| > * Connect to MSDE and install database
| > * Make sure it works on all NT platforms (big problems on NT4)
| > * etc etc etc
| >
| > We have probably spent one man-moth on this task alone... Bo
| > </quote>
| >
| > http://fox.wikis.com/wc.dll?Wiki~Inn...ScriptMSDE~VFP
| >
| > Carl K
| >
|
|
sql

MSDE and Exchange

HI all,
I have a pentium 4 3.GIG dual processor 1GIG ram server, that has Exchange
5.5 and MSDE 2000. Are their any bad side effects to this setup. That is,
speed issues, load etc. Will the current setup support this.
Thanks
Robert
hi Robert,
Robert Bravery wrote:
> HI all,
> I have a pentium 4 3.GIG dual processor 1GIG ram server, that has
> Exchange
> 5.5 and MSDE 2000. Are their any bad side effects to this setup. That
> is, speed issues, load etc. Will the current setup support this.
usually Exchange is not a good companion for SQL Server... it is supported,
but if you can afford separated boxes.... :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
|||HI Andrea,
THanks for the info. I'm trying to isolate some networking problems. Re- my
repvious post concerning MSDE, which you answered. What I am trying to
figure out is that if MSDE is on the same box as Exchange, would I
experience offline and connections dropping from client pc's. The server in
question is a pIV3.0gig, 1gig RAM, raid5, 180gig free HD
THanks
Robert
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3sbpu5Fn2vgmU1@.individual.net...
> hi Robert,
> Robert Bravery wrote:
> usually Exchange is not a good companion for SQL Server... it is
supported,
> but if you can afford separated boxes.... :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
>

MSDE and Enterprise Manager Trouble

I have installed an MSDE instance on my PC. I have used both the setup.exe program and installed MSDE with the merge modules. Everything works fine - I am able to programmatically connect to the database and execute all of my statements. However, when I t
ry to register the database with Enterprise Manager, Enterprise Manager doesn't see the instance. Similarly, my program that uses SQLDMO.DLL to enumerate all servers does not see the MSDE instance. Both the database, my program, and Enterprise Manager are
running locally on the same machine.
This is a development box, and I have had to uninstall MSDE by hand several times by removing registry keys manually. I suspect that my problem is that I have deleted a key that I needed. Does anyone have any clues? Thanks in advance.
Rob Reagan
MSDE with Sp3a or MSDE Release A installs by default without network
connections enabled and will not advertise itself on the network. You can
still register the instance in Enterprise Manager by typing the name in the
textbox during registration.
You can install MSDE with network connections, see the "Customizing Desktop
Engine Setup.exe" topic in Books Online for details. You can also enable
network connections after installation with (I think) svrnetcn.exe in the
Tools\Bin directory, but I have no MSDe instance to check that at the
moment.
Jacco Schalkwijk
SQL Server MVP
"Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
news:AEC24187-ADA9-48D1-ADC3-837FEE031CEB@.microsoft.com...
> I have installed an MSDE instance on my PC. I have used both the setup.exe
program and installed MSDE with the merge modules. Everything works fine - I
am able to programmatically connect to the database and execute all of my
statements. However, when I try to register the database with Enterprise
Manager, Enterprise Manager doesn't see the instance. Similarly, my program
that uses SQLDMO.DLL to enumerate all servers does not see the MSDE
instance. Both the database, my program, and Enterprise Manager are running
locally on the same machine.
> This is a development box, and I have had to uninstall MSDE by hand
several times by removing registry keys manually. I suspect that my problem
is that I have deleted a key that I needed. Does anyone have any clues?
Thanks in advance.
> Rob Reagan

MSDE 2000: Authentication failed despite BLANKSAPWD

Hi!
We're having troubles on a Windows 2003 Server. MSDE 1.0 does not
install (even though we already have this setup at other customers).
So I downloaded MSDE 2000. Unfortunately, somebody else just executed the
installation procedure without setup-parameters. I wanted to have an empty
password (I know, I know. But it is a closed system) and I need SQL
security mode and network protocols.
Thus I uninstalled MSDE 2000 again and launched setup.exe this way:
setup DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL BLANKSAPWD=1
The installation went fine and I did *no* receive the error about the
trusted connections. However, I received "Authentication for user sa
failed" when simply doing this
osql -Usa -P -dmaster
Any clues?
Stefan
On Thu, 28 Oct 2004 10:31:15 +0200, Stefan M. Huber <looseleaf@.gmx.net>
wrote:

> The installation went fine and I did *no* receive the error about the
> trusted connections. However, I received "Authentication for user sa
> failed" when simply doing this
> osql -Usa -P -dmaster
> Any clues?
The only thing that I can tell you is that the MSDE instance accepts the
administrator password as sa password...So the problem is solved but not
the circumstances that produced this setup.
Stefan

MSDE 2000 Vs MS SQL 2000 Server

I am about to setup an application server. This app will generate reports and instead of just having a HTML page up, I am considering running dotnetnuke type portal to offer the userbase a better interface for the reports, info, announcement, etc.

Server isn't too bad (2x1.7Ghz Xeon I think, 2GIG RAM) type of setup (may be little more or less). App doesn't require as much resources, but we are planning for the future )

While I have some resource to play with, I also need to make sure I don't load much that may impact the application performance. In my experience, SQL Server 2000 will take a lot of resources even when not used as much. So I am considering MSDE.

I am curious however, WHAT ARE THE MAIN DIFFERENCES BETWEEN SQL 2000 Server Vs MSDE 2000 ?

Beside no Client tool and mostly command line specific command, what else there to convince that I should go for server vs desktop engine?

Now our company has Enterprise license for SQL, so I am not worried about the cost (well a little maybe), but mostly wondering about performance.

If you think of any reason why I go to SQL Server 2000 over MSDE, please let me. Otherwise, I think MSDE in this case is the appropriate RDBMS to go for.

Regards,

ImpuMicrosoft has a good chart summarizing each of the SQL Server products:SQL Server 2000 Product Overview. You will see that MSDE is the same thing as SQL ServerStandard Edition, with these exceptions:
-- does not include graphical management tools
-- has a workload governor that limits the number of concurrent transactions
-- does not include any analysis capbilities (OLAP, DTS, data mining & warehousing)
-- has different scalability limits

On top of all of that, theEnterprise edition (which you already own), gives you the ability to use failover clustering, log shipping, advanced analysis features, improved scalability, availability, and performance. (SeeFeatures by Edition for more specifics in this area.)

You might find that your database access is your bottleneck, and that you'd want the best performance possible from the database, which would be the Enterprise edition. We inadvertently had moved from the Enterprise Edition to the Standard Edition a while back, and there was a SIGNIFICANT decrease in performance. We had maybe 2 dozen people hitting the database and it was awful. The Standard Edition just would/could not take advantage of the hardware in the server. But looking at the hardware you have on your server (dual processor with 2 gig of RAM, it would seem that the Standard would be able to fully utiltize that)

How many users will be hitting your application at once? MSDE will only handle 25 concurrent processes (note: not USERS), which may or may not be enough for your purposes.

Terri|||Awesome response Terri (Thanks).

since this would be an applicaiton server (reporting software that uses built-in db), we will have very limited use for the MS SQL Server or even MSDE. Mainly I need to install it because I want to install dotnetnuke :) ...

Traffic would be very few to this site as the site will have link to reports that are running off of that other reporting engine. As I said, I could easily get by with a IIS/HTML based website for this purpose.

Having the Enterprise or Standard SQL server will give us a lot of advantages, but you are suggesting I will have performance gain too? Even though MSDE have so little functionality than SQL server (Std or Ent)? Then I oughta go for MS SQL Server then (even though it would be pretty much useless other than housing the dotnetnuke tables.

Regards,

impu|||For others if anyone curious, I found this response from a MSFT guy to another person who asked similar question (Lesson learn, do a little more searching before asking a question :))

*************Start of MSFT engineer's response***********************

SQL Server 2000 Desktop Engine (MSDE 2000) is a version of the
SQL Server data engine designed for redistribution with client-side
applications. Desktop Engine supports most of the functionality of the
other editions of SQL Server 2000, as well as the APIs they support.
Desktop Engine has been optimized for use on smaller computer systems such
as laptops, stand-alone workstations, and servers that support small
workgroups.

Therefore, if there is an instance of SQL server 2000 (Enterprise) on your
computer, it is not necessary to install MSDE 2000 again on the same
machine. In this case, if MSDE 2000 is still installed on your machine, it
will be the named instance. Generally, the application requiring
installation of MSDE will run the .sql files to install the databases on
the SQL Server instance. You can check and see the introductions of your
application if it also does the same. If so, based on my experience, there
is not obvious difference between SQL Server 2000 and MSDE 2000.

Desktop Engine implements all of the basic functionality of SQL Server
2000, as well as most of the additional services. There are, however, a few
differences to keep in mind while planning your installation:

1. The size of Desktop Engine databases cannot exceed 2 gigabytes (GB).

2. Desktop Engine supports symmetric multiprocessing on a maximum of two
processors.

3. Desktop Engine uses the same concurrent workload governor as SQL Server
2000 Personal Edition. When more than five batches are run concurrently,
the workload governor will insert no-ops in direct proportion to the number
of excess batches submitted for processing, thereby reducing system
performance.

4. Desktop Engine participates in replication as:
a. A Subscriber in transactional replication.
b. Both Subscriber and Publisher in snapshot and merge replication.

5. Desktop Engine does not support SQL Mail.

6. Desktop Engine is not supported on Windows? Advanced Server, Limited
Edition.

For more information about the features supported by Desktop Engine, please
refer to the article on SQL Server Books Online.
Topic "Features Supported by the Editions of SQL Server 2000."

817788 Support WebCast: Microsoft SQL Server 2000 Desktop Engine (MSDE)
http://support.microsoft.com/?id=817788

***************end of his response**********************

p.s. Notice #3 (same thing Terri pointed out). May be a decision factor why I should choose SQL Server Ent over MSDE. Didn't think of it from this angle (but then again, would I see more than 4 users? I might. :p

Thanks

Impu|||Take a look at this:http://www.microsoft.com/sql/msde/productinfo/features.asp According to this Microsoft MSDE 2000 Features Article, MSDE does in fact support DTS, it just cannot create them by default because it does not come with the DTS designer (if you have access to SQL Enterprise Manager you should have no problem designing the package).

I will be testing to verify, I will let you know what I find...

MSDE 2000 Release A does not support merge modules

MSDE 2000 Release A does not support merge modules to embed MSDE with custom
application setup. I went through MSDE Bootstrapper Toolkit and apparently it
is still in beta.
How would I distribute my application? Is there any other way of embedding
MSDE 2000 Release A with setup package?
Rats, I get to pass the news you won't like again :-)
Every option I've seen/tried to install the MSDE silently has issues. We've
given up and just ship a setup.ini file that's appropriately modified to
suit our requirements and then just get the end user to run the setup.exe
program. Since doing so, we've gone from tons of setup issues to almost
none.
The situation improves greatly with SQL Express but that's not today.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Job Lot" <JobLot@.discussions.microsoft.com> wrote in message
news:218E1FE0-C55A-41F1-B011-6D98799B3815@.microsoft.com...
> MSDE 2000 Release A does not support merge modules to embed MSDE with
> custom
> application setup. I went through MSDE Bootstrapper Toolkit and apparently
> it
> is still in beta.
> How would I distribute my application? Is there any other way of embedding
> MSDE 2000 Release A with setup package?
|||Hello,
Personally, I launch msde msi file with msiexec /i. (in the
installUISequence)
I have changed the msi from msde to have the password for sa and all is
fine.
Marc Allard
Allcomp
"Job Lot" <JobLot@.discussions.microsoft.com> a crit dans le message de
news: 218E1FE0-C55A-41F1-B011-6D98799B3815@.microsoft.com...
> MSDE 2000 Release A does not support merge modules to embed MSDE with
> custom
> application setup. I went through MSDE Bootstrapper Toolkit and apparently
> it
> is still in beta.
> How would I distribute my application? Is there any other way of embedding
> MSDE 2000 Release A with setup package?
sql

MSDE 2000 install problem - Setup failed to configure the server

Hi,
I keep getting a "Setup failed to configure the server" message everytime i
try to install MSDE 2000. I have entered a strong pasword, as that was
required, removed any instances of previous msde installations and it makes
no difference.
I have read and followed instructions from various web sites and still no
installation.
Any help/advice appreciated.
Thanks
Jen
P.S. I am running XP SP2
Hello,
When you say that you removed every msde instance, did you remove the
Microsoft SQL Server directory?
My custommers have problems when they uninstall msde and they don't delete
the directory by hand after
Marc Allard
Allcomp
"JenC" <JenC@.discussions.microsoft.com> a crit dans le message de news:
EB81AD99-9F73-4731-B15F-BA1624075E9A@.microsoft.com...
> Hi,
> I keep getting a "Setup failed to configure the server" message everytime
> i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it
> makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
|||If you setup is failing, specify a command line parameter DISABLEROLLBACK =
1, this would stop MSDE Installer from rolling back in case of failure.
Also specify /L*v <log file patch with name>. This would enable setup to
write logs into the specified file. Try to search "return value 3" and
check where did it fail.
Once we know where it is failing we can help better. Also add the logfile
when you reply next.
|||Try changing the parameters you use for setup.exe. For example, I removed the
DISABLENETWORKPROTOCOLS =1 and INSTANCENAME=MSDE2 parameters and it worked
fine after that.
Good luck.
"JenC" wrote:

> Hi,
> I keep getting a "Setup failed to configure the server" message everytime i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
sql

MSDE 2000 Install - setup.ini

I have installed MSDE 2000 on my Windows 2000 laptop using the SP3 setup.exe and associated setup.ini file.
So far I have included the following parameters in the setup.ini file -
SAPWD=<my own SA password>
SECURITYMODE=SQL
COLLATION=SQL_Latin1_General_CP1_CI_AS

My next test is to connect to a database on the laptop from my desktop (via my LAN) using SQL Server 2000 Enterprise Manager and/or Query Analyser.

The problem is that although I can 'see' my laptop (ping/My Network Places etc.), I can not see the MSDE installation hense my database on the laptop. The message I get is '[Microsoft]ODBC SQL server driver [DBNETLIB] SQL Server does not exist or access denied'

Have I missed a parameter i.e. do I need to set up a parameter to ensure I can connect to the installation from remote?

Being new to installing MSDE, are there any other parameters I have missed?

Ian

p.s. Anyone know of a simple to follow install instruction set for MSDE 2000 which shows what parameters can be set upSolved the problem myself.
With Service Pack 3, msde has added a new parameter to the install = DISABLENETWORKPROTOCOLS. This parameter is defaulted to 1 which blocks remote access to the database. By adding the parameter with a value of 0 to the setup.ini file I can now connect from remote.
Ian

Originally posted by Ian Grant
I have installed MSDE 2000 on my Windows 2000 laptop using the SP3 setup.exe and associated setup.ini file.
So far I have included the following parameters in the setup.ini file -
SAPWD=<my own SA password>
SECURITYMODE=SQL
COLLATION=SQL_Latin1_General_CP1_CI_AS

My next test is to connect to a database on the laptop from my desktop (via my LAN) using SQL Server 2000 Enterprise Manager and/or Query Analyser.

The problem is that although I can 'see' my laptop (ping/My Network Places etc.), I can not see the MSDE installation hense my database on the laptop. The message I get is '[Microsoft]ODBC SQL server driver [DBNETLIB] SQL Server does not exist or access denied'

Have I missed a parameter i.e. do I need to set up a parameter to ensure I can connect to the installation from remote?

Being new to installing MSDE, are there any other parameters I have missed?

Ian

p.s. Anyone know of a simple to follow install instruction set for MSDE 2000 which shows what parameters can be set up

MSDE 2000 database setup trouble

Hello
I am running a stand-alone test environment for an application in XP Pro
which I can only use MSDE to manage my databases.
I've successfully installed msde and am finally able to connect using 'osql
-Usa -Ppassword -S (local)\testmachine' , because I can get the '1>' command
prompt.
My trouble is when I try to create and/or restore a database for the test
application to use I'm running into trouble. For example enter this :
1> USE master
2> RESTORE DATABASE master FROM DISK='C:\master\master_db2.BAK'
3>GO
and I get an error message telling me that "RESTORE DATABASE must be used in
single user mode when trying to restore the master database" ...... I also
get a similar message when trying to create and restore a database called
'public'.
how do I successfully get into 'single user mode' ?
hi,
APB wrote:
> Hello
> I am running a stand-alone test environment for an application in XP
> Pro which I can only use MSDE to manage my databases.
> I've successfully installed msde and am finally able to connect using
> 'osql -Usa -Ppassword -S (local)\testmachine' , because I can get the
> '1>' command prompt.
> My trouble is when I try to create and/or restore a database for the
> test application to use I'm running into trouble. For example enter
> this :
> 1> USE master
> 2> RESTORE DATABASE master FROM DISK='C:\master\master_db2.BAK'
> 3>GO
> and I get an error message telling me that "RESTORE DATABASE must be
> used in single user mode when trying to restore the master database"
> ...... I also get a similar message when trying to create and
> restore a database called 'public'.
> how do I successfully get into 'single user mode' ?
have a look at http://msdn2.microsoft.com/en-us/library/ms180965.aspx ..
typically you open a command window, navigate to the \Binn folder of the
instance you want to start and execute something like
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\>sqlservr.exe -s
InstanceName -m
this will start the instance in single user modo, so that you'll be able to
restore the master database...
to restore "normal user's" database(s) the single user mode is not required,
but the database(s) to be restored must not be in use... so no active
connections must be running against the database(s) to be restored..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply

msde 2000 and sql server

Hi group!
I am developing an application using MSDE 2000.
I made a Setup.exe by using Installshield tool.
in Installshield I add the msde2000.msm with named
instance. so msde2000 will be installed to the end client
machine.
my question is if the end client machine has SQL server
(for example version 2000, 7.5, 6.0), after my installtion
the sql server in end client machine is still OK?
I found the msde installtion will install dll file to
C:\Program Files\Microsoft SQL Server\80,if end client
machine has SQL server, the msde installtion will rewrite
C:\Program Files\Microsoft SQL Server\80.
thank?
yan
Hi Yan,
I'd strongly suggest you:
1. Modify the setup.ini file to have the settings you want for MSDE and to
install it with an instance name that is unique to you. (That will avoid any
clash with an existing installation)
2. Get the end-customer to run the ms-supplied setup for the MSDE before
installing your app.
Unfortunately, there are just way too many problems with auto-installing it
at present. These will be rectified with SQL Express in the future.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"ycjj" <yan@.mcr-sol.pic.melco.co.jp> wrote in message
news:061a01c49b8f$74866590$a301280a@.phx.gbl...
> Hi group!
> I am developing an application using MSDE 2000.
> I made a Setup.exe by using Installshield tool.
> in Installshield I add the msde2000.msm with named
> instance. so msde2000 will be installed to the end client
> machine.
> my question is if the end client machine has SQL server
> (for example version 2000, 7.5, 6.0), after my installtion
> the sql server in end client machine is still OK?
> I found the msde installtion will install dll file to
> C:\Program Files\Microsoft SQL Server\80,if end client
> machine has SQL server, the msde installtion will rewrite
> C:\Program Files\Microsoft SQL Server\80.
> thank?
> yan

MSDE 2000 and merge modules

I have a vb.net desktop application that uses msde 2000 for its databasing. I am trying to create a setup file using the output of my desktop application and the msde 2000 merge modules in order to install my own build plus an instance of msde 2000.

The setup runs properly and then asks me to restart my machine. After the restart, however, there is no such instance running on my machine. I am adding the following internal properties to my msi file using ocra:

SQLMSDESelected 1
SqlInstanceName Midas
SqlSaPwd Password1
SqlSecurityMode SQL
SqlDataDir C:\Program Files\Microsoft SQL Server\MSSQL$Midas\Data
SqlProgramDir C:\Program Files\Microsoft SQL Server
This should create an instance of msde on my machine but when I try to connect using enterprize manager or query analizer (I connect to <<machinename>>\Midas), then I get the standard can not connect error.

I am at my witt's end and would really appreciate any help.

Thanks.

Hi,

maybe you could help me....

I'm trying to create a setup file using the VS2003 "Setup Project" and MSDE2000SP4 Merge Modules (editing properties with ORCA).

But when I run the installation file, it shows the following message:

"The Error Code is 2920".

Do you know how to fix that ?

Thanks,

Jo?o Paulo.

sql

MSDE 2000 and merge modules

I have a vb.net desktop application that uses msde 2000 for its databasing. I am trying to create a setup file using the output of my desktop application and the msde 2000 merge modules in order to install my own build plus an instance of msde 2000.

The setup runs properly and then asks me to restart my machine. After the restart, however, there is no such instance running on my machine. I am adding the following internal properties to my msi file using ocra:

SQLMSDESelected 1
SqlInstanceName Midas
SqlSaPwd Password1
SqlSecurityMode SQL
SqlDataDir C:\Program Files\Microsoft SQL Server\MSSQL$Midas\Data
SqlProgramDir C:\Program Files\Microsoft SQL Server
This should create an instance of msde on my machine but when I try to connect using enterprize manager or query analizer (I connect to <<machinename>>\Midas), then I get the standard can not connect error.

I am at my witt's end and would really appreciate any help.

Thanks.

Hi,

maybe you could help me....

I'm trying to create a setup file using the VS2003 "Setup Project" and MSDE2000SP4 Merge Modules (editing properties with ORCA).

But when I run the installation file, it shows the following message:

"The Error Code is 2920".

Do you know how to fix that ?

Thanks,

Jo?o Paulo.

Msde 2000

Hi folks!

Ive got here a Windows 2000 Professional PC and want to install the MSDE 2000 (incl. SP3) Desktop Server.

But when i execute the setup.exe the following Error Message will return:

http://www.dorst.de/sql.jpg

Here is the setup.ini

[Options]
TARGETDIR="C:\Programme\MSDE2000"
DATADIR="C:\Programme\MSDE2000\Daten"
SAPWD="*****"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0

Can anyone help?

THX !!!!!

Bye
CdRNoone knows why i cant install?|||Where did you get the the MDSE CD from? In seems that it may be corrupt.

I don't recall any internet calls during any installation I have performed. The fact that the website called s in Germany makes me wonder about the validity of the installation CD.

Be careful that it isn't corrupting your system.

Is there a reason that you are installing the German version?
("C:\Programme" as opposed to "C:\Program Files")|||The MSDE is included in a Program CD of Microsoft, but i tried to download it and install the MSDE... nothing change.

"C:\Programme" <- Thats the Standard-Programm-Dir :)

thx 4 help!

Bye

MSDE 2000

I'm trying to install this application but i get an error
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
I'm running Windows XP SP2.
Could my SP2 be causing me problems considering I successfully installed it previously.
Many thanksWhat do the error logs say? That will be the key to solving theproblem. You might consider using the verbose setup log fileswitch on your SETUP.EXE command:

/L*v [filename]

sql

MSDE 2000

I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

A SA password is required for security reasons. Use SAPWD switch to supply the same.

What does this mean and how can I sort it out?

Many thanks

Jim::I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

lets see.

::A SA password is required for security reasons.

You need to provide a password for the user SA in the database. The SA user is the Administrator of the database server.

::Use SAPWD switch to supply the same.

You need to speficy this password using - a command line parameter, called a switch.|||How do I do that?

Cheers

Jim|||Look at the bottom of this page...

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1|||just run setup.exe SAPWD="passwd" in the cmd line

MSDE 1.0 TO MSDE 2000 Release A

I've used MSDE 1.0 for a number of years.
Today I downloaded Release A with the intention of installing it, but when I
attempt to run Setup I get a dialog saying "The instance name specified is
invalid." What could be causing this?
Also... what impact will an installation of MSDE 2000 have on my existing
MSDE 1.0 databases? Is there a procedure I should be following?
Thanks in advance.
Nancy
hi Nancy,
"Nancy Lorieau" <NancyLorieau@.discussions.microsoft.com> ha scritto nel
messaggio news:81D8BF32-88C8-4F0C-AE24-0C8BCC213BC5@.microsoft.com...
> I've used MSDE 1.0 for a number of years.
> Today I downloaded Release A with the intention of installing it, but when
I
> attempt to run Setup I get a dialog saying "The instance name specified is
> invalid." What could be causing this?
>
personally I never "upgraded" MSDE 1.0 instance to MSDE 2000 ... I always
backedup the users database and restored them on the MSDE2000 new instance
after uninstalling MSDE 1.0.. but I had no reason to maintain the MSDE 1.0
instance at all...
anyway,
http://msdn.microsoft.com/library/de...stsql_84xl.asp
reports you have to add the
UPGRADE=1 UPGRADEUSER=username UPGRADEPWD=userpwd
commandline parameters to your call to the setup.exe bootstrap installer...

> Also... what impact will an installation of MSDE 2000 have on my existing
> MSDE 1.0 databases? Is there a procedure I should be following?
the users databases will be upgraded to MSDE 2000 level... you coul'd be
affected by cross database ownership chaining, which behaviour has been
changed... further info at
http://msdn.microsoft.com/library/de...onfig_8d7m.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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

MSDE / EM licensing

I'm aware you can install MSDE on a customers site if they dont have SQL
Server, correct? If so can you install the client setup off the SQL Server
cd so you get enterprise manager?
How do you handle backup/restore 'nicely' without EM?
LH
If so can you install the client setup off the SQL Server
> cd so you get enterprise manager?
-No, that would break the EULA.

> How do you handle backup/restore 'nicely' without EM?
-There aremany free tools outside to use:
One example: https://www.whitebearconsulting.com/Utilities.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"lh" <lh@.nowhere.com> schrieb im Newsbeitrag
news:_q1xe.22580$Le2.144904@.nasal.pacific.net.au.. .
> I'm aware you can install MSDE on a customers site if they dont have SQL
> Server, correct? If so can you install the client setup off the SQL
> Server cd so you get enterprise manager?
> How do you handle backup/restore 'nicely' without EM?
>
> LH
>

MSDE & WMSDE

Hi all,
i'm very new on MSSQL, recently i need to setup Windows
SharePoint Services and came across about the MSDE.
Appreciate if someone can answer my question below.
1) What is the different between MSDE & WMSDE ?
2) Possible description on the following executable
files? Or website.
bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and
svrnetcn.exe
3) What is storage limit? MSDE have limitation on 2Gb of
storage limit, how about WMSDE?1) What is the different between MSDE & WMSDE ?
WMSDE is a special MSDE on steroids without the 5 user limit and
without the 2GB limit
but you can't search in sharepoint sites
Re 2gb limit:
for most installations you shouldn't wory about this ceiling
you should worry about emphasizing to users that Sharepoint sites are
not for dumping anything like they did with their network shares
for others i recommend msd2d.com
it is a great place for the beautiful Sharepoint technlogies
hope this answered some of your questions
PS: i found a title from Elsevier very helpful..check amazon
the authors are from HP
mawrid
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message248322.html

MSDE - Installation Problems

I am attempting to install MSDE 2000A on a new PC using
command prompt.
My command prompt line is as follows:
C:\MSDERelA:\ setup SAPWD = "test" INSTANCENAME = "DBASE1"
When I hit enter, a "Windows Installer" window appears.
I have installed entreprise manager on the PC and tried
registering DBASE1 but I am told the Server does not exist
or access denied.
Please help!
Wes
I found that when I try and register it it fails, then I go into the
properties and simply click OK again and it starts and connects to the
instance, go figure!
"Wes" <wharrison@.adcbarcode.com> wrote in message
news:0bac01c4cb11$550833e0$a501280a@.phx.gbl...
> OK,
> I have solved the setup problem (simple spacing issue with
> command prompt).
> I have now successfully installed MSDE.
> However I cannot register the server using entreprise
> manager?
> Can anyone explain to me how to register the server for
> use in entreprise manager?
> thanks in advance,
> Wes

MSDE

hey everybody.

I am trying to become a newbie at DNN, but in order to do that i need to setup MSDE. Can someone tell me how to set that up correctly. Any information on how to install MSDE, how to setup MSDE, and how to configure the permissions so that i have them set correctly.

Thanks

--AdamCheckthis for download location and steps to set up MSDE.

Hope that helps
Kashif