Cannot install SQL Server 2005 Standard WinXP Pro SP2

Hello,

I have SQL Server 2000 Developer Edition already installed. Before starting
the SQL Server 2005 Standard setup, I exited the SQL server agent running in
my system tray.

I am logged on as Administrator and no other desktop apps are running. SQL
Server 2005 Setup reports several "Setup failed." error messages after the
install. I am choosing (for now) ONLY the workstation tools and books online
check mark. The installation presents a screen that says that these products
were successfully installed ("Setup finished"):
- MSXML6
- OWC11
- SQL Server Backward-Compatibility Files
However, these items have a red x next to them:
- SQL Server Books Online
- SQL Server Support Files
- SQLXML4
- SQL Native Client
- Workstation Components, Books Online, ...

My Setup log file terminates with a few messages--one of which contains the
words "Configuration failed." (This is the ONLY mention of the word "fail" in
the Setup log--see the excerpt below.)

Any ideas? I'm stuck without SQL Server 2005 running so this is a
productivity killer for me.

More info: Here is what I have done, to no avail:

1) Installed the OWC11 components using a direct download from Microsoft.
That install worked. But when it runs again from the SQL Server 2005 DVD, it
fails.
2) Logged on not as a user with Admin rights, but as ADMINISTRATOR. Same
results--the SQL Server 2005 Standard setup failed.
3) Installed SQL Server 2005 Express successfully. Afterwards, tried again
to install SQL Server 2005 Standard, and that setup failed.
4) Cleared registry values for SQL Server 2005 under HKLM.../Software as
described in KB article. Also deleted the installation folder ...90. Tried
again to install SQL Server 2005 Standard, and that setup failed.
5) Tried the 180-day trial of SQL Server 2005 Enterprise--to no avail. Same
results.

Found error logs but they did not help me pinpoint the root cause for the
failed installation.

Thank you,
-- Jonathan

SQLSetup0004_zzzzz_SQLNCLI_1.log Excerpt:
============================+
MSI (s) (60:90) [12:01:14:390]: Note: 1: 1729
MSI (s) (60:90) [12:01:14:406]: Product: Microsoft SQL Server Native Client
-- Configuration failed.

MSI (s) (60:90) [12:01:14:406]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (60:90) [12:01:14:406]: MainEngineThread is returning 1603
MSI (s) (60:68) [12:01:14:406]: Destroying RemoteAPI object.
MSI (s) (60:9C) [12:01:14:406]: Custom Action Manager thread ending.
=== Logging stopped: 2/8/2007 12:01:14 ===
MSI (c) (8C:4C) [12:01:14:406]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (8C:4C) [12:01:14:406]: MainEngineThread is returning 1603
=== Verbose logging stopped: 2/8/2007 12:01:14 ===

As a first check have you disabled Anti-virus and Anti-firewall before installing?|||

Yes, anti-virus software is OFF and my XP Firewall is OFF.

I re-ran SQL Server 2005 Standard Setup, and here is some more information.

Setup Support files install properly.
Installation Wizard begins.
Status of ALL requirements is "Success".
Windows Installer launches.
I click Next on Serial Number screen after completing the form.
In Components to Install, I select only "Workstation components, Books Online and development tools"
A screen acknowledges that only Client Components will be installed.
I click Install.
A status dialog appears. Setup clearly begins to install files. Then it shows, one-by-one:

1. SQL Setup Support Files FAILED.
2. SQL Native Client FAILED.
3. OWC11 Setup finished.
4. Then I see "Removing backup files"
5. Then Sql Server Books Online failed, along with other failed statuses.

Any ideas?

|||

OK--If anyone cannot help on Microsoft TechNet, can anyone point me in the right direction on how to solve this issue?

1) Are there other web sites that might offer help?

2) Will Microsoft charge an incident fee for this issue since it appears to be a problem with Setup?

3) Does anyone have any suggestions?

This machine has Visual Studio 2003, Visual Studio 6, Macromedia 8, Adobe Photoshop CS2, IE7, and several other high-end products, such as InstallShield 12 Premium. All of those installed and are running without incident.

I can't imagine why SQL Server 2005 setup can't detect what's wrong and provide a successful installation.

Thank you.

|||Install sqlncli.msi before installing mssql2005.|||

Hello:

I ran the sqlncli.msi and received an error that I had a higher version already installed on my machine. I then used Add/Remove programs to remove the SQL Native Client--and then I re-ran sqlncli.msi successfully.

I then re-ran SQL Server 2005 Standard setup and received all the same installation errors already reported.

What now?

|||

I'm contacting Microsoft Support. I thank you for those who tried to help but it is a bit ridiculous to have a support group that can't even troubleshoot getting the product installed!

I will report the root cause here (if Microsoft is able to figure it out).

Thank you,

Jon500