Par2: MSDE install instructions - Part I 2000-10-12 -- Greg Berthume MSDE is essentially SQL Server 7 with a 2gb limitation and I believe won't
work with more than 5 clients. The same SQL Server 7 service packs are
applied. You can also install SQL Server 7 on top of MSDE should you need
to use a larger DB or need more users. Do not install MSDE on top of SQL
Server 7.
It's working great for us. We use it for demos of our product as well as
training sessions and may use it in a "Lite" version of our product.
There are a few potential install issues to be aware of. The install is
essentially silent after the files are unpacked to a temporary folder so be
sure and wait until the install has fully completed before rebooting. Look
at \windows\sqlstp.log to verify if the install was successful. This is a
chronological step by step of the install. If it fails, it will pretty much
tell you what the problem was. I'm attaching a file that shows a successful
install. One failure I had was because of some old sql server entries that
were in the win registry that I deleted and then the install worked. Also,
if an install fails, be sure and delete \mssql7 or run the uninstall option
if it got that far to remove any registry entries.
After installing MSDE, there should be a c:\mssql7 folder and c:\mssql7\binn
will be added to your path so if you need to use osql.exe to process a sql
file to create the db, you'll need to reboot before doing so. I use my
PowerRUN product to run osql to create my db and user logins. Here's the
command line I use:
!'c:\mssql7\binn\osql.exe -S' & GLO:ServerName & ' -Usa -P -i wdl30.sql'
After installing MSDE, there will be a new MSDE option on your Programs menu
with two options. One to start SQL Server and an uninstall option. Be sure
and start SQL Server and set the option to AutoStart when Windows starts.
I've incorporated the MSDE install in my Wise install and in a Clarion
setup.exe type pgm that also drives the Wise install. Here is the code for
installing from Wise and the Clarion pgm install code follows:
Execute Program Settings:
EXE Path: %INST%\msdex86.exe
Command Line: -a -f1 "%INST%\unattend.iss"
Default Directory: %folder%
Clarion source embed behind my "Install MS Data Engine (MSDE)" button:
BEEP(BEEP:SystemQuestion) ; YIELD()
Btn#=MESSAGE('Do you really want to install MSDE?', |
'MS Data Engine Installation', ICON:Question, |
BUTTON:Yes+BUTTON:No, BUTTON:Yes, 0)
IF Btn# = BUTTON:Yes
BEEP(BEEP:SystemAsterisk) ; YIELD()
MESSAGE('A status bar is displayed during part of the installation, but
'&|
'the setup will continue for several minutes after the status bar
'&|
'is no longer displayed.'&|
'||To verify MSDE has been completely installed, \MSSQL7 should
have '&|
'been created, there should be a new group on the Start\Programs
menu '&|
'called MSDE and \windows\setup.log should contain a ResultCode
setting '&|
'of 0 and a Completed Status of 1 indicating a successfull
installation.'&|
'||Please reboot the computer after the installation is complete
so '&|
'that the \MSSQL7 folder is added to the PATH.', |
'MS Data Engine Installation Message', ICON:Asterisk)
TIPath=path()
P#=LEN(TIPath)
IF P#>3
IPath=TIPath & '\'
ELSE
IPath=TIPath
.
LOC:MSDECMD = 'msdex86.exe -a -f1 "' & IPath & 'unattend.iss"' !
prefix -s for silent install
RUN(LOC:MSDECMD)
Log is in separate article.
Printed May 8, 2024, 7:06 pm This article has been viewed/printed 35114 times. |