Trouble installing the Microsoft SQL Server Data Engine (MSDE)

[Guest]

When I try to install the MSDE it starts to install and just before the end,
it appears to uninstall itself!

I run Step up by chosing Run from the Start Menu and type:

C:\sql2ksp3\MSDE\setup.exe SAPWD=somepassword

This is really annoying me.

What can I do to install it please?

Thanks
Bon

 

[Sylvain Lafontaine]

You are trying to install MSDE or you are trying to install the SP3 for
MSDE? The name "sql2ksp3" looks like the SP3 to me.

If it's the SP3, then you must also add the name of the instance to upgrade,
if I remember correctly. Contrary to the more standard versions of
SQL-Server, for MSDE, the SP3 doesn't detect automatically the available
instances on your computer. You can also remove the MSDE and directly
install the latest version of MSDE
(http://www.microsoft.com/downloads/...D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
).

If it's not the SP3, then it is possible that you already have an installed
default instance of MSDE.

There is also the SP4:
http://www.microsoft.com/downloads/...8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en .

 

[Guest]

Hi

I downloaded MSDE 2000 Release A and entered the appropriate commands into
the command prompt. I also created a log file that told me the installation
operation failed. Instructions said I should search for the string "Value 3"
and I found the "Value 3" string 3 times. I figured the errors are as
follows:

First was:
InstallSQLAgentSecurity failed (HPPAV,LocalSystem,87).
Action ended 14:08:14: InstallFinalize. Return value 3.

Second was:
MSI (s) (6C:A8) [14:08:24:799]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (6C:A8) [14:08:24:799]: Error in rollback skipped. Return: 5
MSI (s) (6C:A8) [14:08:24:809]: Calling SRSetRestorePoint API.
dwRestorePtType: 13, dwEventType: 103, llSequenceNumber: 8, szDescription: "".
MSI (s) (6C:A8) [14:08:24:879]: The call to SRSetRestorePoint API succeeded.
Returned status: 0.
MSI (s) (6C:A8) [14:08:24:879]: Unlocking Server
MSI (s) (6C:A8) [14:08:24:879]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 14:08:24: INSTALL. Return value 3.

Third was:
MSI (s) (6C:A8) [14:08:25:240]: MainEngineThread is returning 1603
MSI (s) (6C:88) [14:08:25:280]: Destroying RemoteAPI object.
MSI (s) (6C:B0) [14:08:25:290]: Custom Action Manager thread ending.
MSI (c) (90:54) [14:08:25:320]: Back from server. Return value: 1603
MSI (c) (90:54) [14:08:25:320]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 14:08:25: INSTALL. Return value 3.

Can you suggest what I should do to fix the errors?
Thanks
Bon

 

[Sylvain Lafontaine]

This MSDE installation seems to be full of bugs. The last time I used it
was two years ago but excerpt for the missing instance name with the SP3
upgrade, I don't remember any particular trouble.

You should ask you question the microsoft.public.sqlserver.msde with the
maximum of details; for example: what you are trying to do (installing MSDE
or installing SP3 over a previous installation of MSDE), when installing
MSDE-2000-A, has any previous version been removed; installing as the
default instance or with an instance name; what parameters did you use;
etc., etc., etc.

I hope that you will find some help there because MSDE 2000 is becoming very
old stuff.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Hi

I downloaded MSDE 2000 Release A and entered the appropriate commands into
the command prompt. I also created a log file that told me the
installation
operation failed. Instructions said I should search for the string "Value
3"
and I found the "Value 3" string 3 times. I figured the errors are as
follows:

First was:
InstallSQLAgentSecurity failed (HPPAV,LocalSystem,87).
Action ended 14:08:14: InstallFinalize. Return value 3.

Second was:
MSI (s) (6C:A8) [14:08:24:799]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (6C:A8) [14:08:24:799]: Error in rollback skipped. Return: 5
MSI (s) (6C:A8) [14:08:24:809]: Calling SRSetRestorePoint API.
dwRestorePtType: 13, dwEventType: 103, llSequenceNumber: 8, szDescription:
"".
MSI (s) (6C:A8) [14:08:24:879]: The call to SRSetRestorePoint API
succeeded.
Returned status: 0.
MSI (s) (6C:A8) [14:08:24:879]: Unlocking Server
MSI (s) (6C:A8) [14:08:24:879]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 14:08:24: INSTALL. Return value 3.

Third was:
MSI (s) (6C:A8) [14:08:25:240]: MainEngineThread is returning 1603
MSI (s) (6C:88) [14:08:25:280]: Destroying RemoteAPI object.
MSI (s) (6C:B0) [14:08:25:290]: Custom Action Manager thread ending.
MSI (c) (90:54) [14:08:25:320]: Back from server. Return value: 1603
MSI (c) (90:54) [14:08:25:320]: Decrementing counter to disable shutdown.
If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 14:08:25: INSTALL. Return value 3.

Can you suggest what I should do to fix the errors?
Thanks
Bon

You are trying to install MSDE or you are trying to install the SP3 for
MSDE? The name "sql2ksp3" looks like the SP3 to me.

If it's the SP3, then you must also add the name of the instance to
upgrade,
if I remember correctly. Contrary to the more standard versions of
SQL-Server, for MSDE, the SP3 doesn't detect automatically the available
instances on your computer. You can also remove the MSDE and directly
install the latest version of MSDE
(http://www.microsoft.com/downloads/...D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
).

If it's not the SP3, then it is possible that you already have an
installed
default instance of MSDE.

There is also the SP4:
http://www.microsoft.com/downloads/...8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en .

 

[Guest]

Dear Sylvain,
Many thanks for your reply. I bought a book called Microsoft Access 2003 by
John Viescas and he has a CD at the back and some examples. To use some of
these examples, I need to install MSDE so that is why I started.
You say it is old stuff - so what should I use then?
Thanks
Bon

This MSDE installation seems to be full of bugs. The last time I used it
was two years ago but excerpt for the missing instance name with the SP3
upgrade, I don't remember any particular trouble.

You should ask you question the microsoft.public.sqlserver.msde with the
maximum of details; for example: what you are trying to do (installing MSDE
or installing SP3 over a previous installation of MSDE), when installing
MSDE-2000-A, has any previous version been removed; installing as the
default instance or with an instance name; what parameters did you use;
etc., etc., etc.

I hope that you will find some help there because MSDE 2000 is becoming very
old stuff.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Hi

I downloaded MSDE 2000 Release A and entered the appropriate commands into
the command prompt. I also created a log file that told me the
installation
operation failed. Instructions said I should search for the string "Value
3"
and I found the "Value 3" string 3 times. I figured the errors are as
follows:

First was:
InstallSQLAgentSecurity failed (HPPAV,LocalSystem,87).
Action ended 14:08:14: InstallFinalize. Return value 3.

Second was:
MSI (s) (6C:A8) [14:08:24:799]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (6C:A8) [14:08:24:799]: Error in rollback skipped. Return: 5
MSI (s) (6C:A8) [14:08:24:809]: Calling SRSetRestorePoint API.
dwRestorePtType: 13, dwEventType: 103, llSequenceNumber: 8, szDescription:
"".
MSI (s) (6C:A8) [14:08:24:879]: The call to SRSetRestorePoint API
succeeded.
Returned status: 0.
MSI (s) (6C:A8) [14:08:24:879]: Unlocking Server
MSI (s) (6C:A8) [14:08:24:879]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 14:08:24: INSTALL. Return value 3.

Third was:
MSI (s) (6C:A8) [14:08:25:240]: MainEngineThread is returning 1603
MSI (s) (6C:88) [14:08:25:280]: Destroying RemoteAPI object.
MSI (s) (6C:B0) [14:08:25:290]: Custom Action Manager thread ending.
MSI (c) (90:54) [14:08:25:320]: Back from server. Return value: 1603
MSI (c) (90:54) [14:08:25:320]: Decrementing counter to disable shutdown.
If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 14:08:25: INSTALL. Return value 3.

Can you suggest what I should do to fix the errors?
Thanks
Bon

You are trying to install MSDE or you are trying to install the SP3 for
MSDE? The name "sql2ksp3" looks like the SP3 to me.

If it's the SP3, then you must also add the name of the instance to
upgrade,
if I remember correctly. Contrary to the more standard versions of
SQL-Server, for MSDE, the SP3 doesn't detect automatically the available
instances on your computer. You can also remove the MSDE and directly
install the latest version of MSDE
(http://www.microsoft.com/downloads/...D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
).

If it's not the SP3, then it is possible that you already have an
installed
default instance of MSDE.

There is also the SP4:
http://www.microsoft.com/downloads/...8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en .

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


When I try to install the MSDE it starts to install and just before the
end,
it appears to uninstall itself!

I run Step up by chosing Run from the Start Menu and type:

C:\sql2ksp3\MSDE\setup.exe SAPWD=somepassword

This is really annoying me.

What can I do to install it please?

Thanks
Bon

 

[Sylvain Lafontaine]

If you are a beginner in the world of Access, then maybe you should put MSDE
aside for some time; as this is quite probably discussed in the book only
for some advanced topics such as a Client/Server configuration over the WAN.

MSDE is old stuff now because it's in the process of being replaced with
SQL-Server 2005 Express Edition. ("Express" is the replacement name of MSDE;
see http://lab.msdn.microsoft.com/express/sql/ ). However, because the June
CTP is beta software and that the officiel market release will be on
November 2005, I suggest that you wait until then before trying it; unless
you really need it at this moment.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Dear Sylvain,
Many thanks for your reply. I bought a book called Microsoft Access 2003
by
John Viescas and he has a CD at the back and some examples. To use some
of
these examples, I need to install MSDE so that is why I started.
You say it is old stuff - so what should I use then?
Thanks
Bon

This MSDE installation seems to be full of bugs. The last time I used
it
was two years ago but excerpt for the missing instance name with the SP3
upgrade, I don't remember any particular trouble.

You should ask you question the microsoft.public.sqlserver.msde with the
maximum of details; for example: what you are trying to do (installing
MSDE
or installing SP3 over a previous installation of MSDE), when installing
MSDE-2000-A, has any previous version been removed; installing as the
default instance or with an instance name; what parameters did you use;
etc., etc., etc.

I hope that you will find some help there because MSDE 2000 is becoming
very
old stuff.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Hi

I downloaded MSDE 2000 Release A and entered the appropriate commands
into
the command prompt. I also created a log file that told me the
installation
operation failed. Instructions said I should search for the string
"Value
3"
and I found the "Value 3" string 3 times. I figured the errors are as
follows:

First was:
InstallSQLAgentSecurity failed (HPPAV,LocalSystem,87).
Action ended 14:08:14: InstallFinalize. Return value 3.

Second was:
MSI (s) (6C:A8) [14:08:24:799]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (6C:A8) [14:08:24:799]: Error in rollback skipped. Return: 5
MSI (s) (6C:A8) [14:08:24:809]: Calling SRSetRestorePoint API.
dwRestorePtType: 13, dwEventType: 103, llSequenceNumber: 8,
szDescription:
"".
MSI (s) (6C:A8) [14:08:24:879]: The call to SRSetRestorePoint API
succeeded.
Returned status: 0.
MSI (s) (6C:A8) [14:08:24:879]: Unlocking Server
MSI (s) (6C:A8) [14:08:24:879]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 14:08:24: INSTALL. Return value 3.

Third was:
MSI (s) (6C:A8) [14:08:25:240]: MainEngineThread is returning 1603
MSI (s) (6C:88) [14:08:25:280]: Destroying RemoteAPI object.
MSI (s) (6C:B0) [14:08:25:290]: Custom Action Manager thread ending.
MSI (c) (90:54) [14:08:25:320]: Back from server. Return value: 1603
MSI (c) (90:54) [14:08:25:320]: Decrementing counter to disable
shutdown.
If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 14:08:25: INSTALL. Return value 3.

Can you suggest what I should do to fix the errors?
Thanks
Bon

:

You are trying to install MSDE or you are trying to install the SP3
for
MSDE? The name "sql2ksp3" looks like the SP3 to me.

If it's the SP3, then you must also add the name of the instance to
upgrade,
if I remember correctly. Contrary to the more standard versions of
SQL-Server, for MSDE, the SP3 doesn't detect automatically the
available
instances on your computer. You can also remove the MSDE and directly
install the latest version of MSDE
(http://www.microsoft.com/downloads/...D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
).

If it's not the SP3, then it is possible that you already have an
installed
default instance of MSDE.

There is also the SP4:
http://www.microsoft.com/downloads/...8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en .

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


When I try to install the MSDE it starts to install and just before
the
end,
it appears to uninstall itself!

I run Step up by chosing Run from the Start Menu and type:

C:\sql2ksp3\MSDE\setup.exe SAPWD=somepassword

This is really annoying me.

What can I do to install it please?

Thanks
Bon

 

[Guest]

Dear Sylvain,
Many thanks. Your comments have been very helpful!
Cheers
Bon

If you are a beginner in the world of Access, then maybe you should put MSDE
aside for some time; as this is quite probably discussed in the book only
for some advanced topics such as a Client/Server configuration over the WAN.

MSDE is old stuff now because it's in the process of being replaced with
SQL-Server 2005 Express Edition. ("Express" is the replacement name of MSDE;
see http://lab.msdn.microsoft.com/express/sql/ ). However, because the June
CTP is beta software and that the officiel market release will be on
November 2005, I suggest that you wait until then before trying it; unless
you really need it at this moment.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Dear Sylvain,
Many thanks for your reply. I bought a book called Microsoft Access 2003
by
John Viescas and he has a CD at the back and some examples. To use some
of
these examples, I need to install MSDE so that is why I started.
You say it is old stuff - so what should I use then?
Thanks
Bon

This MSDE installation seems to be full of bugs. The last time I used
it
was two years ago but excerpt for the missing instance name with the SP3
upgrade, I don't remember any particular trouble.

You should ask you question the microsoft.public.sqlserver.msde with the
maximum of details; for example: what you are trying to do (installing
MSDE
or installing SP3 over a previous installation of MSDE), when installing
MSDE-2000-A, has any previous version been removed; installing as the
default instance or with an instance name; what parameters did you use;
etc., etc., etc.

I hope that you will find some help there because MSDE 2000 is becoming
very
old stuff.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


Hi

I downloaded MSDE 2000 Release A and entered the appropriate commands
into
the command prompt. I also created a log file that told me the
installation
operation failed. Instructions said I should search for the string
"Value
3"
and I found the "Value 3" string 3 times. I figured the errors are as
follows:

First was:
InstallSQLAgentSecurity failed (HPPAV,LocalSystem,87).
Action ended 14:08:14: InstallFinalize. Return value 3.

Second was:
MSI (s) (6C:A8) [14:08:24:799]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (6C:A8) [14:08:24:799]: Error in rollback skipped. Return: 5
MSI (s) (6C:A8) [14:08:24:809]: Calling SRSetRestorePoint API.
dwRestorePtType: 13, dwEventType: 103, llSequenceNumber: 8,
szDescription:
"".
MSI (s) (6C:A8) [14:08:24:879]: The call to SRSetRestorePoint API
succeeded.
Returned status: 0.
MSI (s) (6C:A8) [14:08:24:879]: Unlocking Server
MSI (s) (6C:A8) [14:08:24:879]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 14:08:24: INSTALL. Return value 3.

Third was:
MSI (s) (6C:A8) [14:08:25:240]: MainEngineThread is returning 1603
MSI (s) (6C:88) [14:08:25:280]: Destroying RemoteAPI object.
MSI (s) (6C:B0) [14:08:25:290]: Custom Action Manager thread ending.
MSI (c) (90:54) [14:08:25:320]: Back from server. Return value: 1603
MSI (c) (90:54) [14:08:25:320]: Decrementing counter to disable
shutdown.
If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 14:08:25: INSTALL. Return value 3.

Can you suggest what I should do to fix the errors?
Thanks
Bon

:

You are trying to install MSDE or you are trying to install the SP3
for
MSDE? The name "sql2ksp3" looks like the SP3 to me.

If it's the SP3, then you must also add the name of the instance to
upgrade,
if I remember correctly. Contrary to the more standard versions of
SQL-Server, for MSDE, the SP3 doesn't detect automatically the
available
instances on your computer. You can also remove the MSDE and directly
install the latest version of MSDE
(http://www.microsoft.com/downloads/...D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
).

If it's not the SP3, then it is possible that you already have an
installed
default instance of MSDE.

There is also the SP4:
http://www.microsoft.com/downloads/...8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en .

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


When I try to install the MSDE it starts to install and just before
the
end,
it appears to uninstall itself!

I run Step up by chosing Run from the Start Menu and type:

C:\sql2ksp3\MSDE\setup.exe SAPWD=somepassword

This is really annoying me.

What can I do to install it please?

Thanks
Bon