MSDE sp3 install problems

I recently had to install 40 german NT 4 laptops with MSDE sp3.

I prepared a setup.ini file:
[Options]
DATADIR="C:\Programme\Microsoft SQL Server\"
TARGETDIR="C:\Programme\Microsoft SQL Server\"
SAPWD="AStrongPwd"
SECURITYMODE=SQL

and installed most of them sucessfully. Some of them I installed via network, some of them were installed from CD. I tested each installation by copying a prepared database into the data directory and tried to connect to this database using the specified sapwd and found out
When i installed from CD, I could connect to the databases.
Some of the network installs produce a logon failure. it looks like the sapwd was ignored during install - I could not figure out, which password was used, I uninstalled it and reinstalled from CD.

Does anyone know what's the reason for this behaviour?

Thanks,

clothildeGet any information from SQLSTP.LOG on those failed installations for this behaviour.

MSDE Settings not being used

I'm trying to install MSDE 2000 in and XP environment. I want to install it in a specific sub-directory therfore, I'm using a setting ini file to give the instance name, target dir and data dir. I've included both the command line and ini file below:
Command Line Entry:
C:\MSDE2000\setup.exe SAPWD="xxxxxx" /settings "C:\SageQuestLou\DispatcherDB.INI" /L*v C:\SageQuestLou\MSDE.LOG
Settings file:
INSTANCENAME=SageQuest
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
DATADIR="C:\SageQuestLou\Data\"
TARGETDIR="C:\SageQuestLou\"
The installation does occur successfully however it installs using default parameters. However I don't know what the SA password is and it's not where I want it to be.
Can some tell me what wrong with my command line or ini file?
Thanks
Louis
try this to solve pwd problem:
setup /settings="C:\SageQuestLou\DispatcherDB.INI" /i
DISABLENETWORKPROTOCOLS=0 SAPWD=xxxxx SecurityMode=SQL /L*v
C:\SageQuestLou\MSDE.LOG
I'm guessing the SecurityMode param might help here.
"Louis" <anonymous@.discussions.microsoft.com> wrote in message
news:41C137B8-4DEB-430C-A10D-95200B9060A4@.microsoft.com...
> I'm trying to install MSDE 2000 in and XP environment. I want to install
it in a specific sub-directory therfore, I'm using a setting ini file to
give the instance name, target dir and data dir. I've included both the
command line and ini file below:
> Command Line Entry:
> C:\MSDE2000\setup.exe SAPWD="xxxxxx" /settings
"C:\SageQuestLou\DispatcherDB.INI" /L*v C:\SageQuestLou\MSDE.LOG
> Settings file:
> INSTANCENAME=SageQuest
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> DATADIR="C:\SageQuestLou\Data\"
> TARGETDIR="C:\SageQuestLou\"
> The installation does occur successfully however it installs using default
parameters. However I don't know what the SA password is and it's not where
I want it to be.
> Can some tell me what wrong with my command line or ini file?
>
> Thanks
> Louis

MSDE installation without reboot

Hi all, I'm trying to install MSDE in silent mode and without using a .ini file (on a machine with windows 2000 server and SQL 2000 already insatalled).
At the end of the installation, the machine reboot automatically, but I need to stop this reboot to register some information and then reboot the machine.
Someone can help me?
Thanks all
Its something like 'REBOOT=REALLY_SUPPRESS'. Not sure about the spelling.
Its not documented in the SQL install but may be on MS site somewhere.
"A@.Rome" wrote:

> Hi all, I'm trying to install MSDE in silent mode and without using a .ini file (on a machine with windows 2000 server and SQL 2000 already insatalled).
> At the end of the installation, the machine reboot automatically, but I need to stop this reboot to register some information and then reboot the machine.
> Someone can help me?
> Thanks all
|||Thank you very much Jon, I'll try to look for that
"Jon Bishop" wrote:
[vbcol=seagreen]
> Its something like 'REBOOT=REALLY_SUPPRESS'. Not sure about the spelling.
> Its not documented in the SQL install but may be on MS site somewhere.
> "A@.Rome" wrote:
|||Jon, you're right. The exact spelling is 'reboot=reallysuppress' and it's the
option that REALLY suppress the reboot
Here it is the link to the research I've done restricted to the microsoft
support site:
http://www.google.com/search?hl=en&l...ally suppress
thank you so much, Andrew @. Rome
"Jon Bishop" wrote:
[vbcol=seagreen]
> Its something like 'REBOOT=REALLY_SUPPRESS'. Not sure about the spelling.
> Its not documented in the SQL install but may be on MS site somewhere.
> "A@.Rome" wrote:

MSDE Install

Running MSDE 2000 Rel A install with the following information:
[Setup.ini File]
[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
Step 2: Reboot -- Ensure service starts.
Step 3: Extract Service Pack 4
Step 4: Run Service Pack 4 for MSDE
Step 5: Error on install of Service Pack 4 -- Specified 'Instance Name could
not be found'
Any work-arounds for Step 5 ?
Uninstalling MSDE 2000 Rel a does not uninstall all registry entrys, and
rerunning the setup files does not work and gives the following error:
'Specified Instance Name' could not be found.
Seems to work fine by taking a previous system restore point...
Are they bugs ?
I launched the MSDE 2000 Rel A(SP3) install with the following command line:
setup.exe SAPWD="sa" INSTANCENAME="Image_Archive" DISABLENETWORKPROTOCOLS=1
SECURITYMODE=SQL
After reboot the MSDE works fine.
Downloading and extract SP4 for MSDE and try to launch with the following
command line will failed:
setup.exe /upgradesp sqlrun INSTANCENAME="Image_Archive" SECURITYMODE=SQL
UPGRADEUSER=sa UPGRADEPWD=sa /L*v C:\MSDESP4Install.log
The error message that displayed:
"This product is not installed. Check if a appropiate instance of MSDE is
installed."
Ok button.
After this installation failure I try on a clean machine to install MSDE SP3
without instance name:
setup.exe SAPWD="sa" DISABLENETWORKPROTOCOLS=1 SECURITYMODE=SQL
After reboot the MSDE works fine.
Launch the SP4 with the following command line will success:
setup.exe /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=sa
/L*v C:\MSDESP4Install.log
So my question is the same: Is this a bug?
It seems to me that with instance name doesn't work the upgrade or I'm
missed somewhere.
|||hi,
Ketchup wrote:
> setup.exe /upgradesp sqlrun INSTANCENAME="Image_Archive"
> SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=sa /L*v
> C:\MSDESP4Install.log
try INSTANCENAME=Image_Archive
without quotes..
seem to remember this solved the problem last time I upgraded a named
instance to sp4
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you Andrea!That's the solution.
"Andrea Montanari" wrote:

>try INSTANCENAME=Image_Archive
> without quotes..