Install rolls back

Hi NG,
I have a installation problem on MSDE and install to window 2000
MSI (s) (34:FC): MainEngineThread is returning 1603
MSI (c) (54:58): Back from server. Return value: 1603
MSI (c) (54:58): Decrementing counter to disable shutdown. If counter >= 0,
shutdown will be denied. Counter after decrement: -1
Aktion beendet um 10:57:35: INSTALL. Rckgabewert 3.
MSI (c) (54:58): Note: 1: 2262 2: Control 3: -2147287038
then rolling back.
Does anyone experienced the same problem?
Thank you very much for any suggestion.
Regards
Roland
Hi
Try running the install with verbose logging switched on:
setup.exe /L*v <Setup Log File Path>
You may get a better error that describes the problem.
Regard
sMike
"Roland Skottke" wrote:

> Hi NG,
> I have a installation problem on MSDE and install to window 2000
> MSI (s) (34:FC): MainEngineThread is returning 1603
> MSI (c) (54:58): Back from server. Return value: 1603
> MSI (c) (54:58): Decrementing counter to disable shutdown. If counter >= 0,
> shutdown will be denied. Counter after decrement: -1
> Aktion beendet um 10:57:35: INSTALL. Rückgabewert 3.
> MSI (c) (54:58): Note: 1: 2262 2: Control 3: -2147287038
> then rolling back.
> Does anyone experienced the same problem?
> Thank you very much for any suggestion.
> Regards
> Roland
>
>
|||hi Roland Skottke
I have the same experienced before! I fixed this problem with error code of
1603 by start up the "server" service and re-install MSDE !
hope this can help you!
"Roland Skottke" <spam_roland.skottke@.arrisa.com>
??:cvhu96$ov2$01$1@.news.t-online.com...
> Hi NG,
> I have a installation problem on MSDE and install to window 2000
> MSI (s) (34:FC): MainEngineThread is returning 1603
> MSI (c) (54:58): Back from server. Return value: 1603
> MSI (c) (54:58): Decrementing counter to disable shutdown. If counter >=
0,
> shutdown will be denied. Counter after decrement: -1
> Aktion beendet um 10:57:35: INSTALL. Rckgabewert 3.
> MSI (c) (54:58): Note: 1: 2262 2: Control 3: -2147287038
> then rolling back.
> Does anyone experienced the same problem?
> Thank you very much for any suggestion.
> Regards
> Roland
>
|||Hi sMike,
this errors are a part of the log. The log have a lot of text, but i can't
find the error.
regards
Roland
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> schrieb im Newsbeitrag
news:ABD89029-6E6F-4E7B-97D3-4EA1EF90F98B@.microsoft.com...[vbcol=seagreen]
> Hi
> Try running the install with verbose logging switched on:
> setup.exe /L*v <Setup Log File Path>
> You may get a better error that describes the problem.
> Regard
> sMike
> "Roland Skottke" wrote:
0,[vbcol=seagreen]
|||Hi Angus,
where can i find the "server" service?
I can't count the numbers of re-install on this machine.
regards
Roland
"ANGUS" <angusgod@.theworld.com> schrieb im Newsbeitrag
news:O9q2LNcGFHA.2136@.TK2MSFTNGP14.phx.gbl...
> hi Roland Skottke
> I have the same experienced before! I fixed this problem with error code
of
> 1603 by start up the "server" service and re-install MSDE !
> hope this can help you!
>
> "Roland Skottke" <spam_roland.skottke@.arrisa.com>
> ??:cvhu96$ov2$01$1@.news.t-online.com...
> 0,
>

Install roll back

Hi Guys,
During install of msde2000a, at the last few second of
install on a 2000 server box, installation failed and
rollback. Could anyone can help to solve the problem,
below copied from msde log file.
Thanks,
Ted
Action 14:58:50:
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 14:58:50: WriteEnvironmentStrings. Updating
environment strings
WriteEnvironmentStrings: Name: PATH, Value: C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\, Action
1610612738
Action 14:58:50: RegisterTypeLibraries. Registering type
libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
00AA004A34D5}
Action 14:58:51: InstallServices. Installing new services
Action 14:58:51:
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 14:58:52: InstallFinalize. Return value 3.
Action 14:58:52: Rollback. Rolling back action:
If more of the log will help let me know.
Hi Ted,
Is your 2000 server part of a domain or standalone?
bigp
"Ted" <anonymous@.discussions.microsoft.com> wrote in message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> Hi Guys,
> During install of msde2000a, at the last few second of
> install on a 2000 server box, installation failed and
> rollback. Could anyone can help to solve the problem,
> below copied from msde log file.
> Thanks,
> Ted
>
> Action 14:58:50:
> DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action DisableNetAccess()
> Ending custom action DisableNetAccess()
> Action 14:58:50: WriteEnvironmentStrings. Updating
> environment strings
> WriteEnvironmentStrings: Name: PATH, Value: C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\, Action
> 1610612738
> Action 14:58:50: RegisterTypeLibraries. Registering type
> libraries
> RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
> 00AA004A34D5}
> Action 14:58:51: InstallServices. Installing new services
> Action 14:58:51:
> InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> PerfmonLoad routine returned error code 6
> Action ended 14:58:52: InstallFinalize. Return value 3.
> Action 14:58:52: Rollback. Rolling back action:
> If more of the log will help let me know.
|||I'm having the same problem he describes. It is a standalone server. I have found several web pages that detail this problem, but have yet to find a solution to it for Windows 2000 professional.
This page outlines the specific problem I'm having:
http://www.crescentbloom.com/III/D/11.htm
But in it's workaround, step 4 is something that my computer doesn't have (a 'Server' item on my services list)
I have also found instructions from Microsoft's site on how to fix this in Win 2003, but they also do not work for Win 2000 Pro. Can anybody be of help? Thank you!
-Greg
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum...erver-msde/681
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...a630a1edd2a9d2
*****************************************
|||The Server is part of a large domain, I have installed
MSDE on other servers on the same domain and they worked
fine.

>--Original Message--
>Hi Ted,
>Is your 2000 server part of a domain or standalone?
>bigp
>"Ted" <anonymous@.discussions.microsoft.com> wrote in
message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
type[vbcol=seagreen]
services[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-
>.
>
|||The server service is runing ok

>--Original Message--
>I'm having the same problem he describes. It is a
standalone server. I have found several web pages that
detail this problem, but have yet to find a solution to
it for Windows 2000 professional.
>This page outlines the specific problem I'm having:
>http://www.crescentbloom.com/III/D/11.htm
>But in it's workaround, step 4 is something that my
computer doesn't have (a 'Server' item on my services
list)
>I have also found instructions from Microsoft's site on
how to fix this in Win 2003, but they also do not work
for Win 2000 Pro. Can anybody be of help? Thank you!
>-Greg
>*****************************************
>* A copy of the whole thread can be found at:
>* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-
msde/681
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse.aspx?
aid=c471d6429e704a1082a630a1edd2a9d2
>*****************************************
>.
>
|||Can your server locate the PDC, the fsmocheck line of dcdiag?
<anonymous@.discussions.microsoft.com> wrote in message news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
> The Server is part of a large domain, I have installed
> MSDE on other servers on the same domain and they worked
> fine.
> message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> {E09B48B5-
> {E09B48B5-
> type
> services
> {E09B48B5-
> {E09B48B5-
|||It is the pdc.
Do you think it my be rights?

>--Original Message--
>Can your server locate the PDC, the fsmocheck line of
dcdiag?
><anonymous@.discussions.microsoft.com> wrote in message
news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
worked[vbcol=seagreen]
$a401280a@.phx.gbl>...[vbcol=seagreen]
of[vbcol=seagreen]
and[vbcol=seagreen]
problem,[vbcol=seagreen]
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
C:\Program[vbcol=seagreen]
AE68-[vbcol=seagreen]
AE6E-[vbcol=seagreen]
AE7B-[vbcol=seagreen]
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
value 3.
>.
>

install on on a NT machine rolling back --PLEASE HELP

The install is rolling back on a NT machine. Does anyone have any ideas why?
thanks
hi,
msatullo wrote:
> The install is rolling back on a NT machine. Does anyone have any
> ideas why?
>
please add the
/L*v "c:\msdelog.txt"
parameter to your other setup.exe parameter collection in order to enable
verbose logging of the installation process..
you can then inspect for
RETURN VALUE 3
entries indicating errors and about 10/15 lines before each entry some
(sometime cryptic) descritpion of the problem will be reported..
Andrea Montanari
http://www.asql.biz/DbaMgr.shtm
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

Installation

I am trying to install msde on server 2003 platform. No matter what I try
when the installation reaches 1 second remaining it then rolls back the
installation process.
hi Ryan,
Ryan wrote:
> I am trying to install msde on server 2003 platform. No matter what I
> try when the installation reaches 1 second remaining it then rolls
> back the installation process.
please add the
/L*v "c:\MsdeLog.txt"
parameter to the setup.exe boostrap installer call, in order to enable
verbose logging of the installation process..
you can later inspect that text file (about 2mb for a complete succesfull
installation) for
RETURN VALUE 3
entries... about 10/15 lines before each entry some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||When i try that i get "error opening installation log file. Verify that the
specified log file location exists and is writable" I have verified
everything concerning the log file and still receive this error.
"Andrea Montanari" wrote:

> hi Ryan,
> Ryan wrote:
> please add the
> /L*v "c:\MsdeLog.txt"
> parameter to the setup.exe boostrap installer call, in order to enable
> verbose logging of the installation process..
> you can later inspect that text file (about 2mb for a complete succesfull
> installation) for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||Ryan,
I had exactly the same problem trying to install MSDE SP3. After hours of
searching I never found a definitive answer for the problem. What finally
worked for me was to completely clean out my failed installation attempts
(including the registry) and install MSDE from scratch using the new SP4
file. This file will allow you to create a new install as well as upgrade
existing MSDE installations. The command that I used for the installation
(which installs a named instance) is:
Setup DISABLENETWORKPROTOCOLS=0 INSTANCENAME="mynamedinstance"
SAPWD="mypassword" /L*v C:\MSDE_setup.log
This approach worked for me on the first try. Hope it helps... RS
"Ryan" wrote:

> I am trying to install msde on server 2003 platform. No matter what I try
> when the installation reaches 1 second remaining it then rolls back the
> installation process.

Install - datadir and targetdir (again)

Hi
I'm having a problem during installation: it stops when it is 5 seconds to
complete, and then rolls back.
However: If I delete the lines with datadir and targetdir from my ini-file,
it works fine. Anyone knows...?
I am using this ini file:
[Options]
Disablenetworkprotocols=0
Sequritymode=SQL
Datadir="C:\MSDE\Data\"
Targetdir="C:\MSDE\exefiler\"
...and I have logged it... doesn't help me... was hoping to find someone
who had experienced this
Frank
Hi
Does you have rights to create files and directories on the C drive?
Regards
Mike
"FTL" wrote:

> Hi
> I'm having a problem during installation: it stops when it is 5 seconds to
> complete, and then rolls back.
> However: If I delete the lines with datadir and targetdir from my ini-file,
> it works fine. Anyone knows...?
> I am using this ini file:
> [Options]
> Disablenetworkprotocols=0
> Sequritymode=SQL
> Datadir="C:\MSDE\Data\"
> Targetdir="C:\MSDE\exefiler\"
> ...and I have logged it... doesn't help me... was hoping to find someone
> who had experienced this
> Frank
>
>

Install - Datadir and Targetdir

Hi
I'm having a problem during installation: it stops when it is 5 seconds to
complete, and then rolls back.
However: If I delete the lines with datadir and targetdir from my ini-file,
it works fine. Anyone knows...?
I am using this ini file:
[Options]
Disablenetworkprotocols=0
Sequritymode=SQL
Datadir="C:\MSDE\Data\"
Targetdir="C:\MSDE\exefiler\"
Frank
hi Frank,
"FTL" <frankgtl@.online.no> ha scritto nel messaggio
news:17zvd.21612$Km6.282707@.news4.e.nsc.no
> Hi
> I'm having a problem during installation: it stops when it is 5
> seconds to complete, and then rolls back.
> However: If I delete the lines with datadir and targetdir from my
> ini-file, it works fine. Anyone knows...?
> I am using this ini file:
> [Options]
> Disablenetworkprotocols=0
> Sequritymode=SQL
> Datadir="C:\MSDE\Data\"
> Targetdir="C:\MSDE\exefiler\"
> Frank
please add the
/L*v "c:\YourLogFile.txt"
command line parameter to your call to the setup.exe boostrapper installer,
in order to enable verbose log for the installation... this will result in
an about 2mb text file you can inspect for
RETURN VALUE 3
entries...
about 10/15 lines before and/or after each entry some (sometime cryptic)
description of encountered problem will be shown
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

Inserting row and scope_identity()

With a query such as,

SET NoCount ON
INSERT INTO ...
VALUES ...
SELECT scope_identity()
SET NoCount OFF

, can I trust that the id I get back is for the row that I just inserted, or
can it be incorrect because of other "simultaneous" inserts? I need it for
an ASP page.

Thanks,
Marcus[posted and mailed, vnligen svara i nys]

Marcus (lumbus@.ludd.luth.se) writes:
> With a query such as,
> SET NoCount ON
> INSERT INTO ...
> VALUES ...
> SELECT scope_identity()
> SET NoCount OFF
> , can I trust that the id I get back is for the row that I just
> inserted, or can it be incorrect because of other "simultaneous"
> inserts? I need it for an ASP page.

800 grader, du kan lita p mej, du kan lita p mej.

Yes, you can trust it. scope_identity is local to your process - in
fact local to the scope (procedure, batch etc) you are in.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Tack s mycket - Thank you. ;)

Marcus

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns94DC29958E0AYazorman@.127.0.0.1...
> [posted and mailed, vnligen svara i nys]
> Marcus (lumbus@.ludd.luth.se) writes:
> > With a query such as,
> > SET NoCount ON
> > INSERT INTO ...
> > VALUES ...
> > SELECT scope_identity()
> > SET NoCount OFF
> > , can I trust that the id I get back is for the row that I just
> > inserted, or can it be incorrect because of other "simultaneous"
> > inserts? I need it for an ASP page.
> 800 grader, du kan lita p mej, du kan lita p mej.
> Yes, you can trust it. scope_identity is local to your process - in
> fact local to the scope (procedure, batch etc) you are in.
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Tack s mycket - Thank you. ;)

Marcus

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns94DC29958E0AYazorman@.127.0.0.1...
> [posted and mailed, vnligen svara i nys]
> Marcus (lumbus@.ludd.luth.se) writes:
> > With a query such as,
> > SET NoCount ON
> > INSERT INTO ...
> > VALUES ...
> > SELECT scope_identity()
> > SET NoCount OFF
> > , can I trust that the id I get back is for the row that I just
> > inserted, or can it be incorrect because of other "simultaneous"
> > inserts? I need it for an ASP page.
> 800 grader, du kan lita p mej, du kan lita p mej.
> Yes, you can trust it. scope_identity is local to your process - in
> fact local to the scope (procedure, batch etc) you are in.
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp

Inserting row and scope_identity()

With a query such as,

SET NoCount ON
INSERT INTO ...
VALUES ...
SELECT scope_identity()
SET NoCount OFF

, can I trust that the id I get back is for the row that I just inserted, or
can it be incorrect because of other "simultaneous" inserts? I need it for
an ASP page.

Thanks,
Marcus[posted and mailed, vnligen svara i nys]

Marcus (lumbus@.ludd.luth.se) writes:
> With a query such as,
> SET NoCount ON
> INSERT INTO ...
> VALUES ...
> SELECT scope_identity()
> SET NoCount OFF
> , can I trust that the id I get back is for the row that I just
> inserted, or can it be incorrect because of other "simultaneous"
> inserts? I need it for an ASP page.

800 grader, du kan lita p mej, du kan lita p mej.

Yes, you can trust it. scope_identity is local to your process - in
fact local to the scope (procedure, batch etc) you are in.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Inserting records back into temp table that don't exist

I have a procedure that I'm trying to produce for a client. They want to see
total order counts each day from the 1st to the end of the month.
The procedure I have now will produce order counts for days that do exist. I
t
is using the order open date to pull orders from the orders table from
between a start and end date.
The client wants to see zero for the days that didn't have any activity.
For example:
Office Day Total
BranchA 1 50
BranchA 2 0
BranchA 3 10
How do I insert a blank record into my temp table that will show 0 for the
days that didn't pull?
Thanks so much in advance.
Message posted via http://www.webservertalk.comA general method is to create a dataset/table/view with all the days you
want to include and use an OUTER JOIN to get the results. If you want
specific query, please read www.aspfaq.com/5006 and post relevant
information to repro your problem.
Anith