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




Answer this question

Cannot complete Install of Express

  • rkimble

    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)

     



  • Jitendra.net

    See http://support.microsoft.com/ kbid=910229

    Existing SQL Native Client Installation May Cause Setup to Fail



  • dinh xuan dung

    From another post in the forum (by Otto Fischer), see if this helps:

    First I extracted the files in a separate directory:< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

    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.

     

     



  • Jarda Kroupa

    This seemed to fix the problem. Thanks Jeff.
  • OrlanduMike

    >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.


  • Gustavo Echeverry

    thank you very much! it is working now.
  • Mariano_60

    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. :((
  • Weston Hutchins - MSFT

    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.


  • def0

    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


  • MBann

    === 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 ===

  • RB123

    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.



  • Miguel de Melo

    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.
  • Jake Montgomery

    Worked like a charm! Thanks much!

  • Cannot complete Install of Express