Cannot Load SQLSpars.dll

Jon500

Hello,

I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one:

Setup Failed: Could not load SQLSpars.dll

Why would this happen I see this message after beginning the SQL Server 2005 Standard setup and making my installation selections and beginning the install. The process stops after about 30 seconds, and displays the above message.

My machine is running Windows XP SP2.

Any ideas

Thank you,

Jon500

Paul Nicholson - MSFT

A few customers have reported this issue but we haven't tracked down the bug or a workaround yet. If you can post a link to your Setup log files, I'll try to convince a developer to look at them and offer advice.

Paul

Jon500

Excellent. I definitely want to cooperate because I am certain (as you suggested) that other people are experiencing this.

Do you know the name and/or location of the setup log

Thank you,
Jon

Paul Nicholson - MSFT

SQL Server Setup log files are located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG

Jon500

There are at least 4 log-related files in the Files folder. This is from my file called:
SQLSetup0008_DSLPTP05_Core(Local).log
I copied and pasted the top of the file to the point at which it logged the failure.

Does this help (it sure didn't help me when I looked at it)

Thank you,
-- Jon500

Microsoft SQL Server 2005 Setup beginning at Mon May 29 16:04:39 2006
Process ID : 2464
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/4/29 16:4:39
Complete: LoadResourcesAction at: 2006/4/29 16:4:39, returned true
Running: ParseBootstrapOptionsAction at: 2006/4/29 16:4:39
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/4/29 16:4:39, returned true
Running: ValidateWinNTAction at: 2006/4/29 16:4:39
Complete: ValidateWinNTAction at: 2006/4/29 16:4:39, returned true
Running: ValidateMinOSAction at: 2006/4/29 16:4:39
Complete: ValidateMinOSAction at: 2006/4/29 16:4:39, returned true
Running: PerformSCCAction at: 2006/4/29 16:4:39
Complete: PerformSCCAction at: 2006/4/29 16:4:39, returned true
Running: ActivateLoggingAction at: 2006/4/29 16:4:39
Complete: ActivateLoggingAction at: 2006/4/29 16:4:39, returned true
Running: DetectPatchedBootstrapAction at: 2006/4/29 16:4:39
Complete: DetectPatchedBootstrapAction at: 2006/4/29 16:4:39, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2464" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2006/4/29 16:4:39
Complete: PerformDotNetCheck2 at: 2006/4/29 16:4:39, returned true
Running: InvokeSqlSetupDllAction at: 2006/4/29 16:4:39
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Unable to load setup helper module : 87
Message displayed to user
Failed to load SqlSpars.dll

Paul Nicholson - MSFT

We'll likely need to see all the log files plus summary.txt, which is in their parent directory. The files are big enought that you shouldn't try to post them here. Instead, please provide a link.

Paul

Jon500

My files are here:

http://sp.dialogsw.com/temp/Files/Forms/AllItems.aspx

I will keep them there only for a few days. Kindly acknowledge when you have received/download them.

Thank you.

Paul Nicholson - MSFT

Sorry, this thread got lost in the noise for a few days. I've retrieved the files and asked for help from a Dev to investigate.

Paul

Jon500

Thank you very much. I still have no resolution and I am using only the CTP edition of SSMS as a result.

Satya SKJ

Will it get any importance if this is posted in Microsoft connet

Jamie Thomson

Hello,

Did this ever get resolved I am now having the same problem with katmai CTP3.

-Jamie

Jamie Thomson

If you are reading this thread and think you can help me, please reply and let me know.

-Jamie

Jon500

I'm sorry but this issue was NEVER resolved. Would you believe that I had paid $99 to open an incident with Microsoft After spending about three weeks with them, sending megabytes of log files, etc., they gave up and said that they could only recommend that I re-baseline my Windows XP Pro SP2 installation in order to install Sql Server 2005.

I was so disgusted that I asked for a refund of the $99 (which they provided without hesitation).

It is a sad day when the author of the software can't get it to install on a state-of-the-art hardware platform and latest software service packs and mainstream operating system.

If I could use Oracle, I would, but sadly I have to use Sql Server 2005. I am going to see if Microsoft today has any additional information on this issue because I am still not running on my main development machine. I had to install a database instance on another machine on my network and use TCP/IP to access the database instance on it.

I was able to get the Community Technology Preview installation of Sql Server 2005 installed on my development machine, however. This at least gives me the ability to access a Sql Server 2005 database from my development machine. But I still cannot get the native client installed on that machine.

I hope this helps.

Jamie Thomson

Jon,

As you can see from above I had the same problem with katmai CTP3.

The root cause of the problem (in my case) was that DTC wasn't installed on the server. Try as I might I couldn't get it installed either (the reason escapes me right now) so I just scrapped the whole OS (which I think was Win2k3) and installed (using the same installer package) on Win XP. Worked like a dream. It was only on VPCs anyway so I didn't lose too much.

If you want to know if DTC is installed or not go to a command window and type "msdtc". If it returns without barfing at you then you know its installed.

hope that helps.

-Jamie

Jon500

Sorry for the delay in writing...

DTC is installed and is running successfully on the computer in question. So, on my WinXPSP2 system, DTC is not the issue...