Tuesday, February 14, 2012

Can't install SQL Express

It fails because it can't find sqlncli.msi. I looked in the temp directory and it was there

Log excerpt:
User policy value 'SearchOrder' is 'nmu'
MSI (s) (B4:A4) [20:53:04:843]: User policy value 'DisableMedia' is 0
MSI (s) (B4:A4) [20:53:04:843]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (B4:A4) [20:53:04:843]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Looking for sourcelist for product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Adding {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Now checking product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Media is enabled for product.
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Trying source c:\3a0fb7a85678459f3572f2\setup\.
MSI (s) (B4:A4) [20:53:04:859]: Note: 1: 2203 2: c:\3a0fb7a85678459f3572f2\setup\sqlncli.msi 3: -2147287037
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (B4:A4) [20:53:04:859]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Processing net source list.
MSI (s) (B4:A4) [20:53:04:859]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Processing media source list.
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Trying media source E:\.
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 2203 2: E:\sqlncli.msi 3: -2147287038
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Processing URL source list.
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1706 2: 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Failed to resolve source
MSI (s) (B4:A4) [20:54:31:734]: 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'.I found an old post that led me to the solution. The proposed solution was to extract the files from SQLEXPR and install SQLNativeClient by hand and then un-install it. When I ran the .msi file, it found an apparent stealth installed SQLNativeClient (Add/Remove did not show it).

Installation completed

Rusty

No comments:

Post a Comment