error on sp3a URGENT HELP !

After past MDAC it fails running 1st script with error sp3_serv_uni.SQL(1) PLEASE HELPDid you expand the service pack into the default directory, or some directory you created? Also, what's the error?|||Are you sure nobody snuck up on you and attempted to log on to the server while you were busy running the upgrade?

This script performs quite a bit of modifications to the system tables including dropping and recreating of sysprocesses table.

Error on installing SP3a - Analysis Services components

I did some more looking around and found the Knowledge
Base had an article - 814462 - that addresses this issue.
It recommends fixing a registry key value under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OL
AP
Server\Uninstall Info.
I do not have this entry in my registry.
What's up?

quote:

---

>--Original Message--
>While trying to complete the installation of
>sql2kasp3.exe, my system gives me the follwoing error -
>An error occurred during the move data process - 145
>Window header is Severe.
>Any ideas?
>TIA
>.
>

---

Well, like it says to create the registry key value if it doesn't exist, you
can also create the Uninstall Info key itself...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rich Bergstedt" <split_hare@.sbcglobal.net> wrote in message
news:3d4d01c3e300$9ec8f0e0$a501280a@.phx.gbl...[QUOTE]
> I did some more looking around and found the Knowledge
> Base had an article - 814462 - that addresses this issue.
> It recommends fixing a registry key value under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OL
AP
> Server\Uninstall Info.
> I do not have this entry in my registry.
> What's up?
>|||Stupid me.
I never installed Analysis Services when I installed the
eval package.
Now, I am working fine thanks.

quote:

---

>--Original Message--
>Well, like it says to create the registry key value if

---

it doesn't exist, you

quote:

---

>can also create the Uninstall Info key itself...
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>"Rich Bergstedt" <split_hare@.sbcglobal.net> wrote in

---

message

quote:

---

>news:3d4d01c3e300$9ec8f0e0$a501280a@.phx.gbl...
issue.[QUOTE]
error -[QUOTE]
>
>.
>

---

Error on installing SP3a - Analysis Services components

While trying to complete the installation of
sql2kasp3.exe, my system gives me the follwoing error -
An error occurred during the move data process - 145
Window header is Severe.
Any ideas?
TIAI did some more looking around and found the Knowledge
Base had an article - 814462 - that addresses this issue.
It recommends fixing a registry key value under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
Server\Uninstall Info.
I do not have this entry in my registry.
What's up?
>--Original Message--
>While trying to complete the installation of
>sql2kasp3.exe, my system gives me the follwoing error -
>An error occurred during the move data process - 145
>Window header is Severe.
>Any ideas?
>TIA
>.
>|||Well, like it says to create the registry key value if it doesn't exist, you
can also create the Uninstall Info key itself...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rich Bergstedt" <split_hare@.sbcglobal.net> wrote in message
news:3d4d01c3e300$9ec8f0e0$a501280a@.phx.gbl...
> I did some more looking around and found the Knowledge
> Base had an article - 814462 - that addresses this issue.
> It recommends fixing a registry key value under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
> Server\Uninstall Info.
> I do not have this entry in my registry.
> What's up?
> >--Original Message--
> >While trying to complete the installation of
> >sql2kasp3.exe, my system gives me the follwoing error -
> >An error occurred during the move data process - 145
> >Window header is Severe.
> >
> >Any ideas?
> >
> >TIA
> >.
> >|||Stupid me.
I never installed Analysis Services when I installed the
eval package.
Now, I am working fine thanks.
>--Original Message--
>Well, like it says to create the registry key value if
it doesn't exist, you
>can also create the Uninstall Info key itself...
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>"Rich Bergstedt" <split_hare@.sbcglobal.net> wrote in
message
>news:3d4d01c3e300$9ec8f0e0$a501280a@.phx.gbl...
>> I did some more looking around and found the Knowledge
>> Base had an article - 814462 - that addresses this
issue.
>> It recommends fixing a registry key value under
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
>> Server\Uninstall Info.
>> I do not have this entry in my registry.
>> What's up?
>> >--Original Message--
>> >While trying to complete the installation of
>> >sql2kasp3.exe, my system gives me the follwoing
error -
>> >An error occurred during the move data process - 145
>> >Window header is Severe.
>> >
>> >Any ideas?
>> >
>> >TIA
>> >.
>> >
>
>.
>

Error on disk move while trying to add SP3a

I am trying to add sp3a to my Sql Server 2000 install.
I have already added sql2ksp3.exe and it installed fine. I get an error
trying to add sql2kasp3.exe. After unpacking and running setup.exe, I
get the error:
"An error occurred during the move process: -145"
There is plenty of room on my disk (about 300 MB).
I get the same error when I run it on different disks. The sql2ksp3.exe
is a much larger release and I had no problem with that one.
I looked on google for this error and I can pleny of docs with the same
error message (except for the -145).
Anyone know what the problem is?
Thanks,
Tom.
Why are you installing SP3a when you already have SP3? Did you read the
release notes?
Why are you installing sql2kasp3.exe? Do you actually have Analysis
Services installed and running? Or did you just grab every single
SP3-related file?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408F2721.4090004@.deltanet.com...
>I am trying to add sp3a to my Sql Server 2000 install.
> I have already added sql2ksp3.exe and it installed fine. I get an error
> trying to add sql2kasp3.exe. After unpacking and running setup.exe, I get
> the error:
> "An error occurred during the move process: -145"
> There is plenty of room on my disk (about 300 MB).
> I get the same error when I run it on different disks. The sql2ksp3.exe
> is a much larger release and I had no problem with that one.
> I looked on google for this error and I can pleny of docs with the same
> error message (except for the -145).
> Anyone know what the problem is?
> Thanks,
> Tom.
>
|||Aaron Bertrand [MVP] wrote:

> Why are you installing SP3a when you already have SP3? Did you read the
> release notes?
I didn't have SP3. I had just loaded 2000 on my machine and was just
loading SP3 to bring it up to the correct level.

> Why are you installing sql2kasp3.exe? Do you actually have Analysis
> Services installed and running? Or did you just grab every single
> SP3-related file?
No. I didn't load all the SPs. I didn't load the desktop one. I
loaded the other because the instructions say to use both. I assume I
have the analysis services on my machine as I loaded the full system.
Is this not the case? How do I tell?
Here is the instructions on the MS download page:
************************************************** *********************
Instructions
To install SP3a, follow the installation instructions below. Not all
steps are required, depending on which of the following SQL Server 2000
components or configurations to which the service pack is being applied.
Important: You must upgrade computers running Microsoft Windows XP
to Windows XP Service Pack 1 before applying SQL Server 2000 Service
Pack 3a.
Back up your SQL Server databases.
Back up your Analysis Services databases.
Make sure that the system databases have enough free space.
Minimum of 64 MB of RAM (128 MB or more recommended)
Install Database Components SP3a (SQL2KSP3.exe).
Install Analysis Services Components SP3a (SQL2KASP3.exe).
Restart services and applications.
More detailed instructions can be found at the Product Support Services
Readme .
************************************************** *********************

>
|||Analysis Services is separate. Hopefully, you would know if you installed
Analysis Services. It shouldn't be installed if you're not using it, never
mind if you don't know what it is...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408FFA85.2010208@.deltanet.com...
> Aaron Bertrand [MVP] wrote:
>
> I didn't have SP3. I had just loaded 2000 on my machine and was just
> loading SP3 to bring it up to the correct level.
>
> No. I didn't load all the SPs. I didn't load the desktop one. I
> loaded the other because the instructions say to use both. I assume I
> have the analysis services on my machine as I loaded the full system.
> Is this not the case? How do I tell?
> Here is the instructions on the MS download page:
> ************************************************** *********************
> Instructions
> To install SP3a, follow the installation instructions below. Not all
> steps are required, depending on which of the following SQL Server 2000
> components or configurations to which the service pack is being applied.
>
> Important: You must upgrade computers running Microsoft Windows XP
> to Windows XP Service Pack 1 before applying SQL Server 2000 Service
> Pack 3a.
>
> Back up your SQL Server databases.
> Back up your Analysis Services databases.
> Make sure that the system databases have enough free space.
> Minimum of 64 MB of RAM (128 MB or more recommended)
> Install Database Components SP3a (SQL2KSP3.exe).
> Install Analysis Services Components SP3a (SQL2KASP3.exe).
> Restart services and applications.
> More detailed instructions can be found at the Product Support Services
> Readme .
> ************************************************** *********************
>

Error on disk move while trying to add SP3a

I am trying to add sp3a to my Sql Server 2000 install.
I have already added sql2ksp3.exe and it installed fine. I get an error
trying to add sql2kasp3.exe. After unpacking and running setup.exe, I
get the error:
"An error occurred during the move process: -145"
There is plenty of room on my disk (about 300 MB).
I get the same error when I run it on different disks. The sql2ksp3.exe
is a much larger release and I had no problem with that one.
I looked on google for this error and I can pleny of docs with the same
error message (except for the -145).
Anyone know what the problem is?
Thanks,
Tom.Why are you installing SP3a when you already have SP3? Did you read the
release notes?
Why are you installing sql2kasp3.exe? Do you actually have Analysis
Services installed and running? Or did you just grab every single
SP3-related file?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408F2721.4090004@.deltanet.com...
>I am trying to add sp3a to my Sql Server 2000 install.
> I have already added sql2ksp3.exe and it installed fine. I get an error
> trying to add sql2kasp3.exe. After unpacking and running setup.exe, I get
> the error:
> "An error occurred during the move process: -145"
> There is plenty of room on my disk (about 300 MB).
> I get the same error when I run it on different disks. The sql2ksp3.exe
> is a much larger release and I had no problem with that one.
> I looked on google for this error and I can pleny of docs with the same
> error message (except for the -145).
> Anyone know what the problem is?
> Thanks,
> Tom.
>|||Aaron Bertrand [MVP] wrote:
> Why are you installing SP3a when you already have SP3? Did you read the
> release notes?
I didn't have SP3. I had just loaded 2000 on my machine and was just
loading SP3 to bring it up to the correct level.
> Why are you installing sql2kasp3.exe? Do you actually have Analysis
> Services installed and running? Or did you just grab every single
> SP3-related file?
No. I didn't load all the SPs. I didn't load the desktop one. I
loaded the other because the instructions say to use both. I assume I
have the analysis services on my machine as I loaded the full system.
Is this not the case? How do I tell?
Here is the instructions on the MS download page:
***********************************************************************
Instructions
To install SP3a, follow the installation instructions below. Not all
steps are required, depending on which of the following SQL Server 2000
components or configurations to which the service pack is being applied.
Important: You must upgrade computers running Microsoft® Windows® XP
to Windows XP Service Pack 1 before applying SQL Server 2000 Service
Pack 3a.
Back up your SQL Server databases.
Back up your Analysis Services databases.
Make sure that the system databases have enough free space.
Minimum of 64 MB of RAM (128 MB or more recommended)
Install Database Components SP3a (SQL2KSP3.exe).
Install Analysis Services Components SP3a (SQL2KASP3.exe).
Restart services and applications.
More detailed instructions can be found at the Product Support Services
Readme .
***********************************************************************
>|||Analysis Services is separate. Hopefully, you would know if you installed
Analysis Services. It shouldn't be installed if you're not using it, never
mind if you don't know what it is...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408FFA85.2010208@.deltanet.com...
> Aaron Bertrand [MVP] wrote:
> > Why are you installing SP3a when you already have SP3? Did you read the
> > release notes?
>
> I didn't have SP3. I had just loaded 2000 on my machine and was just
> loading SP3 to bring it up to the correct level.
> >
> > Why are you installing sql2kasp3.exe? Do you actually have Analysis
> > Services installed and running? Or did you just grab every single
> > SP3-related file?
>
> No. I didn't load all the SPs. I didn't load the desktop one. I
> loaded the other because the instructions say to use both. I assume I
> have the analysis services on my machine as I loaded the full system.
> Is this not the case? How do I tell?
> Here is the instructions on the MS download page:
> ***********************************************************************
> Instructions
> To install SP3a, follow the installation instructions below. Not all
> steps are required, depending on which of the following SQL Server 2000
> components or configurations to which the service pack is being applied.
>
> Important: You must upgrade computers running Microsoft® Windows® XP
> to Windows XP Service Pack 1 before applying SQL Server 2000 Service
> Pack 3a.
>
> Back up your SQL Server databases.
> Back up your Analysis Services databases.
> Make sure that the system databases have enough free space.
> Minimum of 64 MB of RAM (128 MB or more recommended)
> Install Database Components SP3a (SQL2KSP3.exe).
> Install Analysis Services Components SP3a (SQL2KASP3.exe).
> Restart services and applications.
> More detailed instructions can be found at the Product Support Services
> Readme .
> ***********************************************************************
> >
> >
>

Error on disk move while trying to add SP3a

I am trying to add sp3a to my Sql Server 2000 install.
I have already added sql2ksp3.exe and it installed fine. I get an error
trying to add sql2kasp3.exe. After unpacking and running setup.exe, I
get the error:
"An error occurred during the move process: -145"
There is plenty of room on my disk (about 300 MB).
I get the same error when I run it on different disks. The sql2ksp3.exe
is a much larger release and I had no problem with that one.
I looked on google for this error and I can pleny of docs with the same
error message (except for the -145).
Anyone know what the problem is?
Thanks,
Tom.Why are you installing SP3a when you already have SP3? Did you read the
release notes?
Why are you installing sql2kasp3.exe? Do you actually have Analysis
Services installed and running? Or did you just grab every single
SP3-related file?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408F2721.4090004@.deltanet.com...
>I am trying to add sp3a to my Sql Server 2000 install.
> I have already added sql2ksp3.exe and it installed fine. I get an error
> trying to add sql2kasp3.exe. After unpacking and running setup.exe, I get
> the error:
> "An error occurred during the move process: -145"
> There is plenty of room on my disk (about 300 MB).
> I get the same error when I run it on different disks. The sql2ksp3.exe
> is a much larger release and I had no problem with that one.
> I looked on google for this error and I can pleny of docs with the same
> error message (except for the -145).
> Anyone know what the problem is?
> Thanks,
> Tom.
>|||Aaron Bertrand [MVP] wrote:

> Why are you installing SP3a when you already have SP3? Did you read the
> release notes?
I didn't have SP3. I had just loaded 2000 on my machine and was just
loading SP3 to bring it up to the correct level.

> Why are you installing sql2kasp3.exe? Do you actually have Analysis
> Services installed and running? Or did you just grab every single
> SP3-related file?
No. I didn't load all the SPs. I didn't load the desktop one. I
loaded the other because the instructions say to use both. I assume I
have the analysis services on my machine as I loaded the full system.
Is this not the case? How do I tell?
Here is the instructions on the MS download page:
****************************************
*******************************
Instructions
To install SP3a, follow the installation instructions below. Not all
steps are required, depending on which of the following SQL Server 2000
components or configurations to which the service pack is being applied.
Important: You must upgrade computers running Microsoft Windows XP
to Windows XP Service Pack 1 before applying SQL Server 2000 Service
Pack 3a.
Back up your SQL Server databases.
Back up your Analysis Services databases.
Make sure that the system databases have enough free space.
Minimum of 64 MB of RAM (128 MB or more recommended)
Install Database Components SP3a (SQL2KSP3.exe).
Install Analysis Services Components SP3a (SQL2KASP3.exe).
Restart services and applications.
More detailed instructions can be found at the Product Support Services
Readme .
****************************************
*******************************

>|||Analysis Services is separate. Hopefully, you would know if you installed
Analysis Services. It shouldn't be installed if you're not using it, never
mind if you don't know what it is...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408FFA85.2010208@.deltanet.com...
> Aaron Bertrand [MVP] wrote:
>
>
> I didn't have SP3. I had just loaded 2000 on my machine and was just
> loading SP3 to bring it up to the correct level.
>
>
> No. I didn't load all the SPs. I didn't load the desktop one. I
> loaded the other because the instructions say to use both. I assume I
> have the analysis services on my machine as I loaded the full system.
> Is this not the case? How do I tell?
> Here is the instructions on the MS download page:
> ****************************************
*******************************
> Instructions
> To install SP3a, follow the installation instructions below. Not all
> steps are required, depending on which of the following SQL Server 2000
> components or configurations to which the service pack is being applied.
>
> Important: You must upgrade computers running Microsoft Windows XP
> to Windows XP Service Pack 1 before applying SQL Server 2000 Service
> Pack 3a.
>
> Back up your SQL Server databases.
> Back up your Analysis Services databases.
> Make sure that the system databases have enough free space.
> Minimum of 64 MB of RAM (128 MB or more recommended)
> Install Database Components SP3a (SQL2KSP3.exe).
> Install Analysis Services Components SP3a (SQL2KASP3.exe).
> Restart services and applications.
> More detailed instructions can be found at the Product Support Services
> Readme .
> ****************************************
*******************************
>
>

Error message after SQL SP3a.

Hi there;
I was trying to apply SQL SP3a on my windows 2000 server
(SP4), but the installation failed and when I rebooted my
server the SQL agent failed to start and I get the
following error:
SQLAGENT.exe - Entry Point Not Found
the procedure entry point SFMapi0GetProfiles could not be
located in the dynamic link library SEMMAP.dll
Now, I tried replying SQLSP3a, but that keeps on failing
and I keep getting this error message.
Any Idea .. Please help me.
Thank you.What's the error you get when upgrading to SP3a?
--
Michiel Wories, SQL Server PM
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"HUBCO" <anonymous@.discussions.microsoft.com> wrote in message
news:021601c395bd$4e33efd0$a101280a@.phx.gbl...
> Hi there;
> I was trying to apply SQL SP3a on my windows 2000 server
> (SP4), but the installation failed and when I rebooted my
> server the SQL agent failed to start and I get the
> following error:
> SQLAGENT.exe - Entry Point Not Found
> the procedure entry point SFMapi0GetProfiles could not be
> located in the dynamic link library SEMMAP.dll
> Now, I tried replying SQLSP3a, but that keeps on failing
> and I keep getting this error message.
> Any Idea .. Please help me.
> Thank you.