I have uninstalled the SQL Server Express Edition that I have installed from the CDs that were given to me during a Chicago Conference when READY TO LAUNCH Visual Studio 2005, SQL SERVER 2005, and Biz Talk 2005.
Then I went to microsoft website: http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx and downloaded and installed the so called Microsoft SQL Server 2005 Express Edition and I got the messages Error that you read below. Then I Uninstalled Microsoft SQL Server 2005 Express Edition and went again to msdn website and downloaded Microsoft SQL Server 2005 Express Edition Advanced Services SP1 and installed it. I got again the same message as below.
MESSAGE:
1. First comes a window with the title: “setup.exe – Unable to Locate Component”
And it displays a message:
This application has failed to start because MSTDCPRX.dll was not found.
Re-installing the application may fix this problem.
2. After I click the OK button of this window it comes another window with the title: “Microsoft SQL Server 2005 Server Setup”
And it displays a message: Failed to load SqlSpars.dll
Does anybody can tell what is going on with the 3 times I tried to installed different SQL Server 2005 Express Edition and I get the same message?
Thanks for your help and support when you have time to respond.
Sincerely,
TonyC
MORE INFORMATION ON THE:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
1. C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_B3-XP_Core.txt
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 87
Aborting queue processing as nested installer has completed
Message pump returning: 87
2. C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_B3-XP_Core(Local).txt Running: InvokeSqlSetupDllAction at: 2007/1/20 1:22:8
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Unable to load setup helper module : 87
Message displayed to user
Failed to load SqlSpars.dll
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_B3-XP_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/1/20 1:22:17
Message pump returning: 87
3. C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_B3-XP_Datastore.xml
<
<S,<Scope Type="SetupStateScope" Id="">
<Property Id="machineName">B3-XP</Property>
<Property Id="logDirectory">C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\</Property>
<Property Id="logSummaryFilename">C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt</Property>
<Property Id="logSequenceNumber">1</Property>
<Property Id="primaryLogFiles">{ ["C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_B3-XP_.NET Framework 2.0.log"], ["C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_B3-XP_Support.log"], ["C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_B3-XP_Core.log"], ["C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt"], ["C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_B3-XP_Core(Local).log"] }</Property>
<Property Id="watsonFailedAction">InvokeSqlSetupDllAction</Property>
<Property Id="watsonFailedActionErrorCode">87</Property>
<Property Id="watsonFailedFunction">sqls::InvokeSqlSetupDllAction::perform</Property>
<Property Id="watsonFailedFunctionErrorCode">87</Property>
<Property Id="watsonSourceFileAndLineNo">setup\sqlsetupactions.cpp@.1709</Property>
<Property Id="watsonModuleAndVersion">setup.exe@.2005.90.3042.0</Property>
<Property Id="watsonMsi">None</Property>
<Property Id="watsonMsiAndVersion">None</Property>
<Property Id="watsonSourceFile">setup\sqlsetupactions.cpp</Property>
</<Scope>
This application has failed to start because MSTDCPRX.dll was not found.
It seems that DTS is corrupted on your computer. Would you reinstall DTC (Distributed Transaction Coordinator) and try setup.exe again?
|||Can you be more specific because I am not familiar with what you just said.
1. Can you tell me where to find the DTC or where I can download it so I can reinstal or instal?
Does anybody else also has a different suggestion.
Thanks again
I need more help with the SQL Server Express or more other responses, please.
Is anymore people out there who can tell me what to do?
I am still waiting to here from anybody, I check this forum almost twice a day and I see no answers.
I really would appreciate any of your advice if you look through my LOG files?
If you need me to look for some more code in the Log files like the one named something like log_support.txt which is a very long file I will do that as long as you tell me for what specific line or value or string to look.
Please help and thanks for your time if you try to help me.
Sincerely,
TonyCorrona
|||
Hello there,
PLEASE DELETE THIS THREAD.
Thanks and Regards,
TonyC
|||
Thanks to everybody's time reading my thread and trying to help me maybe.
Anyways, I have fixed the problem on my own without having to reinstall Microsoft Distributed Transaction Coordinator and do all the steps that Microsoft People say in their document they provide in msdn.microsoft site.
My problem above I have fixed using some logics of my head and fixed in less then 10 seconds and then tried to install SQL Server Express and it did install it without problem and generated successfull message without any errors and is working fine so far.
Now you can Delete this thread the Microsoft Admin People.
P.S. I like this TechNet forum site but the only lack of this site is that it does not allow us users to delete our own threads.
Maybe I might be misaken but I don't see anywhere a delete button besides the three or sometimes four buttons which
are: Mark as Answer, Reply, Quote and Edit.
Sincerely,
T C
Tony, can you please supply your solution so that it may help others in the future? Congrats on getting it solved. :)
Sam
|||I am replying to this only on behalf of the users which are struggling with SQL 2005.
If it would be to helping the Programmers or Administrator of MSFT, I would never reply to this blog because they got the job and should try to help people because they get paid for it.
I don't get paid for this to help Microsoft Employee to resolve thier issues.
Myself I am unemployed since last year when I got laid off from a company. Today nobody is helping me with anything, nor to get a job or any interview just because I have only 2 years of work experience.
Anyways let get to the job helping you kindly users.
Since MSFT personnnel could not help me I thought would try to resolve the issue on my own without thier help.
After instaling SQL SERVER 2005, I was missing the MSTDCPRX.dll in the computer that I was installed the SQL 2005 and one thing that I remeber I have done was this.
So I went in another computer that I had Windows XP and searched for the DLL file MSTDCPRX.dll and copy the file and then pasted to the computer that I was missing the file. For those people who do not know where to paste the file, it should be in the directory C:\WINDOWS\system32.
After I copied this file and pasted I did not have any problems anymore with SQL Spars.DLL or any other issues instaling the SQL SERVER 2005.
Hope this will help to all of you who is having problems with SQL SERVER 2005.
Wish you a good day.
Sincerely,
T
No comments:
Post a Comment