none
Setup failed - no package <sqlncli.msi>

    Question

  • I tried to install a sql 2005 desktop engine. This fails with the error:Tongue Tied

    An installaton 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 used a fresh, new download SQLEXPR.EXE.

    What shall I do?

     

    Thursday, November 10, 2005 7:56 PM

Answers

  • IdeaI have the solution. If someone is interested:

     

    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”Big Smile)  and installed (this time successful) sql-express.

    Thursday, November 10, 2005 8:49 PM

All replies

  • IdeaI have the solution. If someone is interested:

     

    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”Big Smile)  and installed (this time successful) sql-express.

    Thursday, November 10, 2005 8:49 PM
  • I had the same error
    But your solution worked :-)
    so Danke schoen

    regards

    • Proposed as answer by DBAbyDefault1 Wednesday, June 22, 2011 4:44 PM
    Thursday, December 01, 2005 12:55 PM
  • i encoutered the same problem too, and luckily i found ur post, and it worked. thanx mate.

    however i would be more happy if someone can provide what is the reason to cause the error? i m using XP SP2 by the way.

    Monday, December 05, 2005 1:39 PM
  • Thanks for the point in the right direction!  I had SQL Server 2005 Express on a Windows 2003 Server and installed SQL Server 2005 Standard over it from a folder on the hard drive.  I downloaded the two CD download from Microsoft Volume License Services and extracted them into the same folder.  The install went correctly and it upgraded the existing Express database, but I had no way of creating a new instance in SQL Server Config Manager.  I ran the setup from the folder again but there were no options to install a new instance (I finally figured out it was only running the setup executable from disk 2, which was extracted after disk 1).

    I then tried to install off of a folder with just CD 1 in it, and kept hitting the "no package" error with the SQLServer2005_BC.msi file.  It never prompted me for the MSI location, but the setup just cacncelled out and eventually gave a fault.  After reading this post I went to Add/Remove Programs and uninstalled SQL Server 2005 and all related programs.  I then tried running setup from the folder with just CD 1 and the error didn't appear.

    I poured over the SQL 2005 BOL in the process and couldn't find anything about installing SQL from a single folder/administrative share (like can be done with Office).  Does anyone have any info on this or do you need the full DVD version to do this?

    Gary Thorne Jr.
    HAL Systems
    Tuesday, December 06, 2005 4:18 PM
  • I had the same problem and this solution was very helpfull, Thank you. Israel
    Monday, December 12, 2005 3:19 AM
  • Hi,

    I tried a different approach and it worked:

    run sqlncli.msi
    choose repair (no restart)
    run SQL Express setup again

    Thanks for the ideaIdea! Smile
    • Proposed as answer by Rick Martinez Thursday, July 16, 2009 3:58 AM
    Tuesday, December 13, 2005 5:40 PM
  • Oh yeah see me do a jig, see me dance up and down, see me put on a happy face.

     

    (That's short for THANKS!)

     

    ---

    pgpkeys

     

    Sunday, January 08, 2006 1:34 AM
  • Great Job,

    I was getting this same error installing MS SQL Server 2005 - Enterprise Edition and was able to:

    • Uninstall the SQL Natural Client by running <CD>:\setup\sqlncli.msi
    • Rebooted
    • Installed the SQL Natural Client through the AutoRun selection
    • Installed SQL 2005 normally

    Thanks, 

    Mark

    Saturday, January 21, 2006 9:15 PM
  • I had a similar problem installing SQL Server 2005 Standard Edition (not the beta) on Win 2000 SP4. It refused to install properly, leaving me without a SQL Server Management Studio. It didn't like the sqlncli.msi file. My solution was similar to that suggested above. Uninstall SQL Client from Control Panel. Then reinstall it from the CD by double clicking directly on the sqlncli.msi file. Then it allowed me to reinstall SQL Server 2005.

    Thanks 

    Thursday, February 02, 2006 2:34 PM
  • Hi.

    i tried to installing cluster SQL Enterprise 2005 and got this problem.

    I did:

    1. By Control Panel, remove all SQL components on both nodes.
    2. From SQL CD run sqlncli.msi on both cluster nodes.
    3. Autorun SQL installation.

     

    Thanks!

    • Proposed as answer by Thiagogvdasa Wednesday, February 09, 2011 7:05 PM
    Wednesday, March 01, 2006 2:20 AM
  • Thank you very much for posting this. 

    I actually just uninstalled ncli from "Add/Remove Programs" before running SQLEXPR.EXE in Win 2000.

     

    Sunday, March 19, 2006 5:46 PM
  • Yes,I run "sqlncli.msi" and clicked "uninstall",Then installed sqlexpr.exe successfully,no need to rebooted the computer.

    Thanks very much!:)

    Wednesday, March 22, 2006 3:32 AM
  • my friend i tried to deleated  sqlncli.msi,  then i install the sqlexpr.exe, but again i get the messge "failed to setup sql express edition.

    I hve used the disk to save the visual web and visul basic.net 2005 express edition. however when it comes to sql express its keep giving me setup failed message.

    and when i downloaed the sql 2005 express edition, after the successfully downloading the file, when i click on the .exe file I receive a messge " sqlexpr.exe is not a valid win32 application" I couldnt work the sql server in anyway.  Help me if you can or anyone. I am new to this forum as well so i dont know if i have to request you here or everyone else. :) thanks.

     

    Friday, May 26, 2006 8:21 AM
  • Thanks for your post, it saved me bunches of time.

    I removed the SQL items using control panel, then ran CD:\wcu\sse\sqlexpre.exe from the VS2005 media.  I'm good to go.  Thx again.

     

    Monday, June 05, 2006 5:45 AM
  • This worked for me too.  Thanks a mil!
    Monday, June 05, 2006 4:40 PM
  • You are a god! 

    You solved my problem and I thank you.

    Friday, June 09, 2006 6:06 PM
  • Worked for me too!

    Thank you Otto

    Tuesday, June 20, 2006 12:02 AM
  • Your solution worked. Thanks Otto!
    Thursday, June 22, 2006 3:27 AM
  • I actually read the readme file.  It addresses this issue.  It says to uninstall the native client before installing SQL Server 2005.  What do you know... it worked!
    Friday, June 30, 2006 5:15 PM
  • Very good!!! This worked great for me... Sometimes I wonder about install packages...
    Monday, July 03, 2006 9:51 PM
  • per Bastian,

    I had the same error
    But your solution worked :-)
    so Danke schoen


    Michael Irwin


    Friday, August 18, 2006 4:40 AM
  • This did it for me and is unquestionably the easiest of all solutions outlined in this topic.  Thanks!
    Friday, August 18, 2006 8:22 PM
  • THANK YOU! 
    Saturday, September 16, 2006 5:31 AM
  • Hey Otto...

    Thanks for the post dude...it worked perfectly...this is obviously a common problem and thanks to people like you we are able to overcome issues like this in the field by using these forums.  Keep up the good work!!

    Shannon

    Thursday, October 26, 2006 11:26 PM
  • rf7_15: You rock!  Your suggestion worked for me.  Thank you so much for your help!!!  Reference:

    run sqlncli.msi
    choose repair (no restart)
    run SQL Express setup again

    Wednesday, March 14, 2007 9:50 PM
  • Add another thank you for this answer!! 

     

    Stephen

    Saturday, April 28, 2007 5:00 PM
  • I had the same issue with SQL 2005 Dev Ed, but instead of reinstalling, I took the advice of repairing the client.  Under the Setup folder, I ran sqlncli.msi and chose to repair and finished out.  Once complete, I ran the setup.exe again and it ran flawlessly.

     

    Thanks Much.

     

    DT

    Monday, May 07, 2007 7:36 PM
  • THANK YOU EVERYONE!!!! the solution works great!
    Thursday, May 31, 2007 12:46 AM
  • Thanks a bunch!!!. The solution worked. First uninstalled sqlncli.msi and all other SQL Server 2005 related files through the Add/Remove programs, then did a fresh CD install of SQL Server 2005. Worked well. No hang ups.
    Thursday, May 31, 2007 7:37 PM
  • fantastic fix,  thanks  worked for me also.


    thank again


    Friday, June 01, 2007 2:07 PM
  • Yeah thanks! Simple solution, but efficient! Thanks again!
    Friday, June 29, 2007 1:36 PM
  • Thanks it worked me as well

    B

    Wednesday, July 11, 2007 5:16 AM
  • Just had the same problem and was most grateful for the solution(s) on this thread. Thanks!!
    Monday, September 10, 2007 12:19 PM
  • Your solution worked like a charm.  Thanks a lot.

     

    - snt

    Thursday, December 06, 2007 8:57 AM
  • What a idea, Great...

    I am very happy, it is done.

    thanks a lot

    akshay
    Tuesday, December 25, 2007 4:26 AM
  •  

    Hi,

    It's worked. Really helpful.

     

    Thanks

    Furqan Ahmad

    Friday, January 04, 2008 7:12 AM
  • I had the same problem, and my answer was two-part. First, I created a text document called "fixwmi.cmd" with the following text inside:

    Code Snippet

    @echo on
    cd /d c:\temp
    if not exist %windir%\system32\wbem goto TryInstall
    cd /d %windir%\system32\wbem
    net stop winmgmt
    winmgmt /kill
    if exist Rep_bak rd Rep_bak /s /q
    rename Repository Rep_bak
    for %%i in (*.dll) do RegSvr32 -s %%i
    for %%i in (*.exe) do call :FixSrv %%i
    for %%i in (*.mof,*.mfl) do Mofcomp %%i
    net start winmgmt
    goto End

    :FixSrv
    if /I (%1) == (wbemcntl.exe) goto SkipSrv
    if /I (%1) == (wbemtest.exe) goto SkipSrv
    if /I (%1) == (mofcomp.exe) goto SkipSrv
    %1 /RegServer

    :SkipSrv
    goto End

    :TryInstall
    if not exist wmicore.exe goto End
    wmicore /s
    net start winmgmt
    :End



    I went to run and typed in "c:\fixwmi.cmd" where I had stored the file. I rebooted.

    Next, I downloaded the sqlncli.msi file from the following site:

    I went to "Add or Remove Programs" and uninstalled the "Microsoft SQL Native Client." Then, I ran the sqlncli.msi file. Installation of the client was successful. Lastly, I reinstalled the Express program. Everthing installed fine.
    Saturday, April 12, 2008 3:36 PM
  • Sounds good.

     

    Thanks

    Sunday, April 13, 2008 9:57 AM
  •  

    Brilliant!
    Tuesday, May 06, 2008 7:27 PM
  • Thanks

    Saturday, June 07, 2008 11:33 AM
  •  couldn't get ACT! 2008 to install after an older install. It kept getting stuck. It looked like it was tangled up with the SQL install. I downloaed the EXE above and ran it. I got some errors. I went to add/remove and uninstalled all the sql files. then I tried the exe again. Worked very smoothly.

    Thursday, June 19, 2008 2:33 PM
  • Many thanks. This really help me today. I would only like to say the command should be SQLEXPR.exe /x c:\sqlexprtmp

     

    Cheers

    JK

     

     Otto Fischer wrote:

     

    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.

    Thursday, June 26, 2008 4:32 AM
  • You Help me out thank you

     

    Sunday, July 27, 2008 7:44 AM
  • You Helped me

    Sunday, July 27, 2008 7:44 AM
  • Thank you very much!
    Wednesday, August 13, 2008 8:59 AM
  • where or what site can i find that download at?
    Thursday, August 28, 2008 10:52 AM
  • where can i get sqlexpr.exe ?
    Thursday, August 28, 2008 10:58 AM
  • tnx man, saved me lots of time with this one!
    Monday, September 15, 2008 8:32 AM
  • and once again:
    danke ! (but without reboot-tut-gut !)

    Andy


    Tuesday, September 30, 2008 2:28 PM
  • Thanks for posting this.

    In my case the missing package was sqlncli_x64.msi (64bit server)

    Ran the msi manually, selected Remove, then re-ran the SQLEXPR.exe

    Worked a treat!

     

     

    Thursday, October 02, 2008 10:01 AM
  • Hi guys,

     

    I got lazy. I did not uninstall all the SQL stuff. I just re-ran the install and it started all over again and finished the install this time.

     

    Thanks for the excellent tip. I would have been stuck without it.

     

    Regards,

     

    Tuesday, October 28, 2008 9:35 PM
  • Sweet. Worked fine w/o the reboot. Thanks.

    Wednesday, October 29, 2008 5:02 PM
  • Thank you very much Otto - can't say you entirely saved me a lot of swearing because I got that out of my system before I found your solution, but it probably did save me a lot more!
    Saturday, February 21, 2009 5:52 PM
  • We did an Enterprise 2000 to 2005 [32 and 64 bit] and had same error, which surprised us in other types of upgraded.

    Took the above advice but did so with only the REPAIR option, then reboot and all was fine.

    Thursday, April 30, 2009 5:18 PM
  • Thank you rf7_15 that approach worked for me running the sqlncli.msi again with repair. I was installing SQL Server 2005 Standard Edition.
    Thursday, July 16, 2009 3:59 AM
  • Thank you very much dear.

    Your solution also worked for me.

    Best wishes,
    Zia
    Sunday, September 27, 2009 7:59 PM
  • Just click on sqlncli.msi ane chose option remove, thane continoue with instalation.

    Friday, October 09, 2009 7:43 AM
  • Same problem on Windows 7 Ultimate x64.

    Slightly different solution.

    Tried as above for 32  64 bit versions but as it wasn't already installed it failed.

    It only worked after installing sqlncli_x64.exe first then restarted SQL Server Express install again, which worked fine!

    PS. It moaned about not having the ASP.NET 32bit (requiored for registering Reporting Servbices) ignore that warning!.


    Monday, November 16, 2009 11:33 AM
  • Your solution worked for me, Thanks a million!
    Monday, November 30, 2009 7:41 PM
  • "Setup might fail and roll back with the following error message: "An installation package for the product Microsoft SQL Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'." To work around this problem, uninstall SQL Native Client by using Add or Remove Programs. On a cluster, uninstall SQL Native Client from all nodes. Then, run SQL Server Setup again."

    http://download.microsoft.com/download/f/1/0/f10c4f60-630e-4153-bd53-c3010e4c513b/ReadmeSQLEXP2005.htm
    • Proposed as answer by Sun - AKL, NZ Friday, September 03, 2010 3:00 AM
    Tuesday, December 01, 2009 2:15 PM
  • 10x, you saved me..

    lazydba247.
    Tuesday, January 05, 2010 6:12 AM
  • Otto, thanks for your post. It helps me today.
    Wednesday, January 13, 2010 8:00 PM
  • Duh i had this problem too but when i install it Fully my Windowxp Just shut down Fully and never wake up again untill i run it on DOS and Remove SQL File but the problem is just everytime i restart comp and i get on desktopp it give me BLUE Screen
    Saturday, January 30, 2010 4:01 AM
  • I can't believe this....never thought of that--- So sqlexpr.exe is really a self extracting zip file? I had the same problem and just right clicked and clicked Extract here in windows xp to extract it.

    Furthermore, I have had missing msi file problems on all my visual studio express products. What Microsoft, in its infinite wisdom,  (LOL) evidently does is extract the files to a temporary folder and then deletes the folder. Later, when you try to repair it from add/remove programs, it screams for "installation media" that has the proper .msi file.

    Thanks Otto. I'm not installing ANYTHING downloaded from MS anymore without first trying to extract it to a permanent folder
    Friday, March 12, 2010 6:55 PM
  • Thank you!!!!!
    Thursday, April 22, 2010 10:56 PM
  • Hi,

    Great trick, I had the same problem and it worked!!

    Many thanks!

    Thursday, April 29, 2010 2:50 PM
  • Thanks Otto,

    I did it just as you said and the installation was sucessfully

    Good going

    Wednesday, June 02, 2010 10:27 PM
  • Idea I have the solution. If someone is interested:

     

    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”Big Smile )   and installed (this time successful) sql-express.

    Thx it works !
    Sunday, July 04, 2010 9:58 PM
  • Wednesday, September 29, 2010 7:52 PM
  • Very Nice...thank you...worked like a charm
    Friday, November 12, 2010 1:52 PM
  • Idea I have the solution. If someone is interested:

     

    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”Big Smile )   and installed (this time successful) sql-express.

    It worked like a charm. Thanks a lot.
    Wednesday, January 12, 2011 8:16 AM
  • Hey Otto, thanks man! Your solution is helping us since November,2005! LOL
    Thursday, April 14, 2011 1:29 AM
  • Hi,

    I tried a different approach and it worked:

    run sqlncli.msi
    choose repair (no restart)
    run SQL Express setup again

    Thanks for the ideaIdea! Smile

    This method worked for me, too.  No reboot necessary!  Thanks for sharing.
    Monday, July 11, 2011 3:02 PM
  • Similar solution worked - Copied the CD locally to a hard disk, I uninstalled all related SQL Server 2005 programes from Add/Remove and then simply restarted the installation process. Worked great.
    Friday, July 15, 2011 1:14 PM
  • that works for me too , ty
    If this post answers your question, please click "Mark As Answer". If this post is helpful please click "Mark as Helpful".
    Thursday, August 11, 2011 10:20 PM
  • Thanks for your magic solution
    Wednesday, September 21, 2011 1:55 PM
  • it work perfectly. Tansk...... tankss.........

    Friday, October 07, 2011 1:11 AM
  • Hi, I tried a different approach and it worked: run sqlncli.msi choose repair (no restart) run SQL Express setup again Thanks for the ideaIdea! Smile Proposed As Answer byRick MartinezThursday, July 16, 2009 3:58 AM Yes this worked best. I also used 7-zip to extract the files and run repair on sqlncli.msi
    • Edited by meridius10 Tuesday, December 27, 2011 1:07 PM
    Tuesday, December 27, 2011 1:00 PM
  • Worked like a champ!

    Thank you!!!

    Monday, April 09, 2012 1:19 AM
  • Thanks from Chile!!!!
    Friday, June 15, 2012 6:22 AM
  • THANKS Otto Fischer!!! this worked fantastically. Kudos to you!

    Welligton Vambe MCITP

    Thursday, July 19, 2012 10:08 AM
  • The answer may be 7 years old but it still works like charm!

    Thanks!!

    Chris

    Tuesday, October 30, 2012 3:03 PM