I am trying install MSDE on XPSP2 pro. It fails the following set of erros
in the setup log. These lines are from a non-verbose log I created while
running the setup.
Appreciate any help.
Thanks
Shishir
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SkuIt
Setting SqlEdition property failed
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
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 "SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
-- Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
I got some info on the possible causes of failure as below. Unfortunately
neither of them help.
If your machine name has lowercase characters then you may be hitting this
issue - http://support.microsoft.com/default...;en-us;Q285100
If you had a old instance of MSDE on the machine you may be hitting this
issue - http://support.microsoft.com/default...b;en-us;816499
"Shishir" wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set of erros
> in the setup log. These lines are from a non-verbose log I created while
> running the setup.
> Appreciate any help.
> Thanks
> Shishir
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action SkuIt
> Setting SqlEdition property failed
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> 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 "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
> -- Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
>
|||hi Shishir,
Shishir wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set
> of erros in the setup log. These lines are from a non-verbose log I
> created while running the setup.
>..
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
this exception is sometime related to MDAC stack corruption... as no MDAC XP
sp2 refresh is available to fix it, you can only go as indicated in
http://www.macropool.com/en/download/mdac_xp_sp2.html
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
|||I downloaded the repair tool and reregistered all the components. It still
fails the same way.
"Andrea Montanari" wrote:
> hi Shishir,
> Shishir wrote:
> this exception is sometime related to MDAC stack corruption... as no MDAC XP
> sp2 refresh is available to fix it, you can only go as indicated in
> http://www.macropool.com/en/download/mdac_xp_sp2.html
> --
> 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
>
>
sql
Showing posts with label lines. Show all posts
Showing posts with label lines. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
MSDE replacing Access2000 in VB Application
I support a Visual Basic application, about 150,000 lines. It's basic
functionality is to pull data from an Oracle database and store it in arrays,
then perform about 6 dozen different kinds of analysis on the data, as the
user chooses.
Access 2000 is used in two fashions, both behind the scenes and static. (1)
The data from Oracle is temporarily stored in one MDB for cross-tabbing and
reorganization into the VB arrays. (2) Certain reference databases are
populated in other MDB files in order to support off-line analysis. Also,
user-defined associations are stored in a separate MDB.
So here are the questions: would I benefit from the use of MSDE? If not, why
not (to explain to boss and customer). If yes, how, and with what kind of
effort?
Thanks!
If you're making heavy use of cross-tab queries, that's probably
reason enough right there to stick with Access mdb's. It's much harder
to do in SQL Server, and you'd need to rewrite that entire piece of
your application. It doesn't appear that there are really any
advantages to using MSDE in your case since you also require
heterogeneous queries to Oracle, which is also much easier from
Access. It works differently in SQL Server, and you'd need to rewrite
a lot of your data access functionality as well. I can't really think
of any benefit to migrating this particular app to MSDE unless you're
getting paid by the hour :-)
-- Mary
On Tue, 14 Sep 2004 10:03:03 -0700, Rick Coen
<rick.coen@.eds.com.nospam> wrote:
>I support a Visual Basic application, about 150,000 lines. It's basic
>functionality is to pull data from an Oracle database and store it in arrays,
>then perform about 6 dozen different kinds of analysis on the data, as the
>user chooses.
>Access 2000 is used in two fashions, both behind the scenes and static. (1)
>The data from Oracle is temporarily stored in one MDB for cross-tabbing and
>reorganization into the VB arrays. (2) Certain reference databases are
>populated in other MDB files in order to support off-line analysis. Also,
>user-defined associations are stored in a separate MDB.
>So here are the questions: would I benefit from the use of MSDE? If not, why
>not (to explain to boss and customer). If yes, how, and with what kind of
>effort?
>Thanks!
|||I agree with Mary but wanted to point out that the next version of MSDE (Sql
server 2005 express) is supposed to support the cross tab queries (PIVOT I
think)
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:g4fek0lnib00ce9nimo5urm9jb2vssgn5n@.4ax.com... [vbcol=seagreen]
> If you're making heavy use of cross-tab queries, that's probably
> reason enough right there to stick with Access mdb's. It's much harder
> to do in SQL Server, and you'd need to rewrite that entire piece of
> your application. It doesn't appear that there are really any
> advantages to using MSDE in your case since you also require
> heterogeneous queries to Oracle, which is also much easier from
> Access. It works differently in SQL Server, and you'd need to rewrite
> a lot of your data access functionality as well. I can't really think
> of any benefit to migrating this particular app to MSDE unless you're
> getting paid by the hour :-)
> -- Mary
> On Tue, 14 Sep 2004 10:03:03 -0700, Rick Coen
> <rick.coen@.eds.com.nospam> wrote:
arrays,[vbcol=seagreen]
the[vbcol=seagreen]
(1)[vbcol=seagreen]
and[vbcol=seagreen]
Also,[vbcol=seagreen]
why[vbcol=seagreen]
of
>
functionality is to pull data from an Oracle database and store it in arrays,
then perform about 6 dozen different kinds of analysis on the data, as the
user chooses.
Access 2000 is used in two fashions, both behind the scenes and static. (1)
The data from Oracle is temporarily stored in one MDB for cross-tabbing and
reorganization into the VB arrays. (2) Certain reference databases are
populated in other MDB files in order to support off-line analysis. Also,
user-defined associations are stored in a separate MDB.
So here are the questions: would I benefit from the use of MSDE? If not, why
not (to explain to boss and customer). If yes, how, and with what kind of
effort?
Thanks!
If you're making heavy use of cross-tab queries, that's probably
reason enough right there to stick with Access mdb's. It's much harder
to do in SQL Server, and you'd need to rewrite that entire piece of
your application. It doesn't appear that there are really any
advantages to using MSDE in your case since you also require
heterogeneous queries to Oracle, which is also much easier from
Access. It works differently in SQL Server, and you'd need to rewrite
a lot of your data access functionality as well. I can't really think
of any benefit to migrating this particular app to MSDE unless you're
getting paid by the hour :-)
-- Mary
On Tue, 14 Sep 2004 10:03:03 -0700, Rick Coen
<rick.coen@.eds.com.nospam> wrote:
>I support a Visual Basic application, about 150,000 lines. It's basic
>functionality is to pull data from an Oracle database and store it in arrays,
>then perform about 6 dozen different kinds of analysis on the data, as the
>user chooses.
>Access 2000 is used in two fashions, both behind the scenes and static. (1)
>The data from Oracle is temporarily stored in one MDB for cross-tabbing and
>reorganization into the VB arrays. (2) Certain reference databases are
>populated in other MDB files in order to support off-line analysis. Also,
>user-defined associations are stored in a separate MDB.
>So here are the questions: would I benefit from the use of MSDE? If not, why
>not (to explain to boss and customer). If yes, how, and with what kind of
>effort?
>Thanks!
|||I agree with Mary but wanted to point out that the next version of MSDE (Sql
server 2005 express) is supposed to support the cross tab queries (PIVOT I
think)
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:g4fek0lnib00ce9nimo5urm9jb2vssgn5n@.4ax.com... [vbcol=seagreen]
> If you're making heavy use of cross-tab queries, that's probably
> reason enough right there to stick with Access mdb's. It's much harder
> to do in SQL Server, and you'd need to rewrite that entire piece of
> your application. It doesn't appear that there are really any
> advantages to using MSDE in your case since you also require
> heterogeneous queries to Oracle, which is also much easier from
> Access. It works differently in SQL Server, and you'd need to rewrite
> a lot of your data access functionality as well. I can't really think
> of any benefit to migrating this particular app to MSDE unless you're
> getting paid by the hour :-)
> -- Mary
> On Tue, 14 Sep 2004 10:03:03 -0700, Rick Coen
> <rick.coen@.eds.com.nospam> wrote:
arrays,[vbcol=seagreen]
the[vbcol=seagreen]
(1)[vbcol=seagreen]
and[vbcol=seagreen]
Also,[vbcol=seagreen]
why[vbcol=seagreen]
of
>
Wednesday, March 7, 2012
MSDE Installation Fails
These are the last 3 lines the log file creates before
the installation stops. Does anyone know how to complete
the installation?
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\sqlredis.exe /q:a"
hi,
"Clete" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:19d401c4ad71$b5f839b0$a301280a@.phx.gbl
> These are the last 3 lines the log file creates before
> the installation stops. Does anyone know how to complete
> the installation?
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL Server\80
> \Tools\Binn\sqlredis.exe /q:a"
try manually installing MDAC 2.7.1 before MSDE ... get MDAC at
http://msdn.microsoft.com/data/Default.aspx
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
the installation stops. Does anyone know how to complete
the installation?
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\sqlredis.exe /q:a"
hi,
"Clete" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:19d401c4ad71$b5f839b0$a301280a@.phx.gbl
> These are the last 3 lines the log file creates before
> the installation stops. Does anyone know how to complete
> the installation?
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL Server\80
> \Tools\Binn\sqlredis.exe /q:a"
try manually installing MDAC 2.7.1 before MSDE ... get MDAC at
http://msdn.microsoft.com/data/Default.aspx
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
Saturday, February 25, 2012
MSDE Install Hangs for hours
Our application uses MSDE. On one computer running Windows XP. The MSDE
intstall runs for 4+ hours and never completes.
Here are the last few lines of the msde install file- Any ideas on what
might be happening?
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\SqlSetup\Temp
NoRebootConnectRepl returned: 3010
MSI (s) (44:F4): Executing op:
ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
Action 20:37:22: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
MSI (s) (44:F4): Executing op:
CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
MSI (s) (44:F4): Creating MSIHANDLE (180) of type 790536 for thread 3572
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
Are you launching the installation from code / any other mechanism that is
waiting for setup.exe to terminate.
There is some weird issue in the MSDE install package that causes the
sqlredis action to hang if anything is waiting for the parent process to exit.
I haven't seen a good answer on why that happens.
Hope that helps
- Ross
"dramos" wrote:
> Our application uses MSDE. On one computer running Windows XP. The MSDE
> intstall runs for 4+ hours and never completes.
> Here are the last few lines of the msde install file- Any ideas on what
> might be happening?
> Starting custom action NoRebootReplace
> TempFolder Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\
> Source Dir Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\SqlSetup\Temp
> NoRebootConnectRepl returned: 3010
> MSI (s) (44:F4): Executing op:
> ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
> Action 20:37:22: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
> MSI (s) (44:F4): Executing op:
> CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
> MSI (s) (44:F4): Creating MSIHANDLE (180) of type 790536 for thread 3572
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
> /q:a"
intstall runs for 4+ hours and never completes.
Here are the last few lines of the msde install file- Any ideas on what
might be happening?
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\SqlSetup\Temp
NoRebootConnectRepl returned: 3010
MSI (s) (44:F4): Executing op:
ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
Action 20:37:22: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
MSI (s) (44:F4): Executing op:
CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
MSI (s) (44:F4): Creating MSIHANDLE (180) of type 790536 for thread 3572
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
Are you launching the installation from code / any other mechanism that is
waiting for setup.exe to terminate.
There is some weird issue in the MSDE install package that causes the
sqlredis action to hang if anything is waiting for the parent process to exit.
I haven't seen a good answer on why that happens.
Hope that helps
- Ross
"dramos" wrote:
> Our application uses MSDE. On one computer running Windows XP. The MSDE
> intstall runs for 4+ hours and never completes.
> Here are the last few lines of the msde install file- Any ideas on what
> might be happening?
> Starting custom action NoRebootReplace
> TempFolder Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\
> Source Dir Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\SqlSetup\Temp
> NoRebootConnectRepl returned: 3010
> MSI (s) (44:F4): Executing op:
> ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
> Action 20:37:22: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
> MSI (s) (44:F4): Executing op:
> CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
> MSI (s) (44:F4): Creating MSIHANDLE (180) of type 790536 for thread 3572
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
> /q:a"
Subscribe to:
Posts (Atom)