MSDE 2000a Deployment Issues

I need to deploy MSDE 2000a with a custom app built in VB6. I found the
setup package to add MSDE 1.0 through the Package & Deployment Wizard, but
the link I found for MSDE 2000 goes to the same article as 1.0. I've also
seen a lot of info on using merge modules to deploy MSDE 2000, but I'm
clueless about them. What is the best (and hopefully easiest) way to deploy
MSDE 2000 with a custom app built with VB6 using the Package & Deployment
Wizard? Any help would be greatly appreciated.
My advice is don't.
Package the setup program from MS, configure the setup.ini file the way you
want it and get the user to run it. Every other option seems to end up in
pain at present. Much better story coming for SQL Express.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"pbb" <pbb@.discussions.microsoft.com> wrote in message
news:DDFFD02B-301D-4273-B32B-D6CCFAB50A76@.microsoft.com...
>I need to deploy MSDE 2000a with a custom app built in VB6. I found the
> setup package to add MSDE 1.0 through the Package & Deployment Wizard, but
> the link I found for MSDE 2000 goes to the same article as 1.0. I've also
> seen a lot of info on using merge modules to deploy MSDE 2000, but I'm
> clueless about them. What is the best (and hopefully easiest) way to
> deploy
> MSDE 2000 with a custom app built with VB6 using the Package & Deployment
> Wizard? Any help would be greatly appreciated.
|||Okay, so it sounds like what you're saying is that it's best to include 2
setup programs? First have the user run the setup.exe that comes with MSDE
(with the customized ini file), and then have them run the setup package for
the custom app?
"Greg Low [MVP]" wrote:

> My advice is don't.
> Package the setup program from MS, configure the setup.ini file the way you
> want it and get the user to run it. Every other option seems to end up in
> pain at present. Much better story coming for SQL Express.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "pbb" <pbb@.discussions.microsoft.com> wrote in message
> news:DDFFD02B-301D-4273-B32B-D6CCFAB50A76@.microsoft.com...
>
>
|||Yep
"pbb" <pbb@.discussions.microsoft.com> wrote in message
news:4203C438-9A56-48F0-B36D-22793F26F4AD@.microsoft.com...[vbcol=seagreen]
> Okay, so it sounds like what you're saying is that it's best to include 2
> setup programs? First have the user run the setup.exe that comes with
> MSDE
> (with the customized ini file), and then have them run the setup package
> for
> the custom app?
> "Greg Low [MVP]" wrote:

MSDE 2000 installation problem

" Starting custom action ConfigServer
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "Latin1_General""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information. "
that is the last action before the install fail in the log
does anyone know what's wrong?
thanx
Lok
hi Lok,
"Lok" <Lok@.discussions.microsoft.com> ha scritto nel messaggio
news:7B1D91E0-00CA-4C32-AC67-267BCFF7958A@.microsoft.com
> " Starting custom action ConfigServer
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
> "Latin1_General""
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information. "
> that is the last action before the install fail in the log
> does anyone know what's wrong?
> thanx
> Lok
please have a look at
http://support.microsoft.com/default...99&Product=sql
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
|||I have tried every resolutions found on the website and it was still not
installing.
I've always set the lanaguage for non Unicode programs to chinese( Hong
Kong) to be able to display chinese character in the system natively. I have
specified the collation to Latin1_General in order for the setup to start but
the installation was never successful.
After switching the language back to English(United States), MSDE installed
fine.
Now my question is if I switch the language back to Chinese(Hong Kong),
would that mess up the MSDE install.
thanx
Lok
"Andrea Montanari" wrote:

> hi Lok,
> "Lok" <Lok@.discussions.microsoft.com> ha scritto nel messaggio
> news:7B1D91E0-00CA-4C32-AC67-267BCFF7958A@.microsoft.com
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
> --
> 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
>