Cannot complete Install of Express

Product: Microsoft SQL Server Native Client -- Error 1706. An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.

Logged as MsiInstaller in App Log.

The install fails with this and two other items in the bos that shows successful install items
SQL Server Database Services
Workstation Components, Books Online, Development Tools

Installed 2 necessary programs;
Windows Installer 3.1 and .NET framework 2.0 redistr.

Any Ideas?
Tongue Tied

[677 byte] By [M.Leary] at [2007-12-17]
# 1
=== Verbose logging started: 11/30/2005 19:05:44 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (B8:34) [19:05:44:703]: Resetting cached policy values
MSI (c) (B8:34) [19:05:44:703]: Machine policy value 'Debug' is 0
MSI (c) (B8:34) [19:05:44:703]: ******* RunEngine:
******* Product: {BF251EAF-8697-4E89-BF09-C998F97BBC40}
******* Action:
******* CommandLine: **********
MSI (c) (B8:34) [19:05:44:703]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (B8:34) [19:05:44:703]: Grabbed execution mutex.
MSI (c) (B8:34) [19:05:44:703]: Cloaking enabled.
MSI (c) (B8:34) [19:05:44:703]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (B8:34) [19:05:44:703]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (E8:30) [19:05:44:703]: Grabbed execution mutex.
MSI (s) (E8:9C) [19:05:44:703]: Resetting cached policy values
MSI (s) (E8:9C) [19:05:44:703]: Machine policy value 'Debug' is 0
MSI (s) (E8:9C) [19:05:44:703]: ******* RunEngine:
******* Product: {BF251EAF-8697-4E89-BF09-C998F97BBC40}
******* Action:
******* CommandLine: **********
MSI (s) (E8:9C) [19:05:44:703]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (E8:9C) [19:05:44:703]: Warning: Local cached package 'c:\WINDOWS\Installer\12e22e.msi' is missing.
MSI (s) (E8:9C) [19:05:44:703]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (E8:9C) [19:05:44:703]: User policy value 'DisableMedia' is 0
MSI (s) (E8:9C) [19:05:44:703]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Looking for sourcelist for product {BF251EAF-8697-4E89-BF09-C998F97BBC40}
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Adding {BF251EAF-8697-4E89-BF09-C998F97BBC40}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Now checking product {BF251EAF-8697-4E89-BF09-C998F97BBC40}
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Media is enabled for product.
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Trying source c:\58ccfb60ac52bec0f1\setup\.
MSI (s) (E8:9C) [19:05:44:703]: Note: 1: 2203 2: c:\58ccfb60ac52bec0f1\setup\sqlncli.msi 3: -2147287037
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (E8:9C) [19:05:44:703]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Processing net source list.
MSI (s) (E8:9C) [19:05:44:703]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (E8:9C) [19:05:44:703]: SOURCEMGMT: Processing media source list.
MSI (s) (E8:9C) [19:05:44:718]: SOURCEMGMT: Trying media source D:\.
MSI (s) (E8:9C) [19:05:44:718]: Note: 1: 2203 2: D:\sqlncli.msi 3: -2147287038
MSI (s) (E8:9C) [19:05:44:718]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (E8:9C) [19:05:44:718]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (E8:9C) [19:05:44:718]: SOURCEMGMT: Processing URL source list.
MSI (s) (E8:9C) [19:05:44:718]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (E8:9C) [19:05:44:718]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (E8:9C) [19:05:44:718]: Note: 1: 1706 2: 3: sqlncli.msi
MSI (s) (E8:9C) [19:05:44:718]: SOURCEMGMT: Failed to resolve source
MSI (s) (E8:9C) [19:05:44:718]: MainEngineThread is returning 1612
MSI (c) (B8:34) [19:05:44:718]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (B8:34) [19:05:44:718]: MainEngineThread is returning 1612
=== Verbose logging stopped: 11/30/2005 19:05:44 ===
M.Leary at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 2
I have encountered the very same error that Michael posted. Can somebody please help us? :( I'm in the middle of project development and I'm afraid I might miss my deadline. :((
kendi at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 3

Me Too!

It would be perfect if microsoft can has a small tools to remove all history of SQL server installation (no matter beta or not)

Kennon2005 at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 4

From another post in the forum (by First I extracted the files in a separate directory:

SQLEXPR.EXE" /x:c:\sqlexprtmp

Then I searched and executed “sqlncli.msi”

I clicked on “uninstall”.

After this I rebooted the computer (in German: “reboot tut gut”) and installed (this time successful) sql-express.

JeffPapiez-MSFT at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 5
thank you very much! it is working now.
kendi at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 6

This fixed the problem for me as well. I can tell you what causes the problem (or at least how to reproduce it)

Setup a WindowsXP machine with NO Service Packs.

Try to install SQLEXPR.EXE

It will fail because SP 2 is not insalled.

Install SP2

Try to reinstall SQLEXPR.EXE

It will fail of the SQL Native Client.

Following the workaround in this post and uninstall SQL Native Client

Reboot

Reinstall SQLEXPR.EXE and it works fine.

cowanm at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 7

Excellent. I had the same problem - caused by trying to install it on a machine which didn't originally have a valid SP2 update - and your solution solved the problem.

Malb at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 8

>This fixed the problem for me as well. I can tell you what causes the problem (or at least how to reproduce it)
>Setup a WindowsXP machine with NO Service Packs.
> Try to install SQLEXPR.EXE
>It will fail because SP 2 is not insalled.
>Install SP2
>Try to reinstall SQLEXPR.EXE
>It will fail of the SQL Native Client.

That is exactly the problem. With luck Miscrosoft will now fix it, because it really puzzled me until I read this thread.

Malb at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 9
These threads might provide a solution, but given that Expresss is meant to a response to things like MSQL, would'nt it be nice if a) they got it right first time, b) had sorted out by now.
GrahamC at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 10
This seemed to fix the problem. Thanks Jeff.
NoahNadeau at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 11
See http://support.microsoft.com/?kbid=910229

Existing SQL Native Client Installation May Cause Setup to Fail

Watzinaneihm at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 12

The advice given above worked great for me. I tried to install SQL server 2005 express but during the installation I got the message that SP2 was a requirement.

After I did the SP2 update and tried to continue with the install I got the error. I did go to add/remove programs and removed the "Native Client" and then the installation worked with no errors.

Thanks

LuisGdelC at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 13

Worked like a charm! Thanks much!
Dan3johns at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...

SQL Server

Site Classified