none
Windows PowerShell Failed error while installing SQL Server 2008 Express Advanced

    Question

  • I am attempting to install "SQL Server 2008 Express with Advanced Services". I downloaded this file "SQLEXPRADV_x86_ENU.exe" and consistently get an error in the "System Support Rules" window that indicates that the Windows PowerShell Failed. It doesn't say how it failed or why it failed - it just failed. I previously installed Visual C# Express with no problems.

     

    How do I get past this problem?

     

    Thank you

    • Moved by Papy NormandModerator Saturday, January 10, 2009 10:36 PM thread concerning a failed install of Powershell not SMO/DMO (Moved from SQL Server SMO/DMO to SQL Server Express)
    Monday, November 03, 2008 6:26 AM

Answers

  • The failure you are getting is not a failure of Windows Powershell to install, it is a failure of SQL Express with Advanced Services to install because you do not have PowerShell installed. I would suggest that you navigate to http://www.microsoft.com/express/sql/download and click the Download Now link at the top of the page. This will download and launch the SQL Express Installation Wizard, a tool that will handle downloading and installing everything you need, including prerequisites, to get SQL Express installed and running.

    To the point about Windows Validation, Papy is correct, this step just verifies that your copy of Windows has not been pirated. This is required to download many tools and pieces of software from Microsoft and is part of our effort to reduce illegal copies of Windows out there.

    Regards,
    Mike


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Sunday, January 11, 2009 6:55 AM
    Moderator

All replies

  • Hi Chuck,

    I would request you to move this to SQL Server Setup & Upgrade http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=95&SiteID=1 or SQL Server Express http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=385&SiteID=1 for resolution of your problem.

    Regards,
    Alok Parmesh

    Tuesday, November 04, 2008 8:35 PM
    Answerer
  • I've had a same problem.
    I've posted it here : http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/4a9dea23-277d-4b30-a6ae-d356651e96ea
    Saturday, January 10, 2009 12:49 PM
  • Hello Alok,

    You are true when you ask to move this thread towards the Sql Server Express Forum or Sql Server Setup & Upgrade Forum
    I will move this thread towards Sql Server Express Forum

    Have a nice day
    Please remember to click 'Mark as Answer' on the post that helped you. Unmark if it provides no help
    Saturday, January 10, 2009 10:34 PM
    Moderator
  • Hello,

    I have moved this thread to this forum because your install of Sql Server Express is failing

    Sincerely, it is the 1st time i heard that PowerShell install is failing.

    Anyway, PowerShell is not really required for the install of Sql Server Express 2008 ( except when you want to have Sql Server Management Studio basic 2008 )

    Please, could you explain which version of PowerShell have you tried to install ? ( 1.0 or 2.0 )
    If you have tried the 2.0 version, i don't think it is the good choice , it is only on the level CTP so not an official version
    The good link for installing Powershell 1.0 is :
    http://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx

    You should take care to the fact you have many possible downloads corresponding to your operating system and the type of platform ( X86 for normal OS that's to say 32 bits, X64 for 64 bits OS and Itanium , but i am not sure that Sql Server Express 2008 is working on Itanium ). You must take care of the fact that your OS may be english or localized ( German,Chinese,French...) , you have to use the localized download if your OS is a XP Pro german or swedish

    If you have an OS with several languages installed ( MUI Multilingal User Interface ), you must use a specific download

    You should try to install PowerShell with the correct download.
    If you have a problem, you should notice the errors to be able to correct your problem.
    I disagree always with a silent install as it is often difficult to find errors

    We are waiting for your feedback to try to help you more efficiently

    Have a nice day

    PS : you should have a look on this thread ( thanks _MDS_ )
    http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/4a9dea23-277d-4b30-a6ae-d356651e96ea
    A frequent error is to install Sql Server at the same time as the pre-requisites
    The best way is to begin by the pre-requisites like .Net Framework 2.0 and 3.5, VS 2008 Express SP1 and VS 2008 SP1 ( if you have in a Visual Studio Standard/Pro 2008 ) and so on ( without forgetting to restart windows between each install: it is not always necessary, only clever , Sql Server Express will not be able to be installed if a restart is pending ).
    I prefer to do too many restarts than to forget one and to miss an install
    When all the pre-requisites are OK, you may install your Sql Server Express 2008
    A common error is also to want to install as the same time VS Express 2008 and Sql Server Express 2008 : and the user is facing a problem of pending restart
    Separate all your installs and do some tests between 2 installs and you will avoid many problems ( even if you think that you will loose time )
    Please remember to click 'Mark as Answer' on the post that helped you. Unmark if it provides no help
    Saturday, January 10, 2009 10:59 PM
    Moderator
  • I was wanting to download Windows PowerShell 1.0 English-Language Installation Package for Windows XP (KB926139) from here , unfortunately it needs windows Validation . :(( Why ?
    Saturday, January 10, 2009 11:06 PM
  • Hello,

    PowerShell is a free tool offered by Microsoft , but to download and install it, you must have a genuine operating system ( it is a way to struggle against false versions of XP or Vista )

    Have a nice day

    PS Have a look on this link ( if you have not a genuine version, you can't have any update of Windows )
    http://www.microsoft.com/genuine/downloads/FAQ.aspx?displaylang=en
    Please remember to click 'Mark as Answer' on the post that helped you. Unmark if it provides no help
    Saturday, January 10, 2009 11:17 PM
    Moderator
  • The failure you are getting is not a failure of Windows Powershell to install, it is a failure of SQL Express with Advanced Services to install because you do not have PowerShell installed. I would suggest that you navigate to http://www.microsoft.com/express/sql/download and click the Download Now link at the top of the page. This will download and launch the SQL Express Installation Wizard, a tool that will handle downloading and installing everything you need, including prerequisites, to get SQL Express installed and running.

    To the point about Windows Validation, Papy is correct, this step just verifies that your copy of Windows has not been pirated. This is required to download many tools and pieces of software from Microsoft and is part of our effort to reduce illegal copies of Windows out there.

    Regards,
    Mike


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Sunday, January 11, 2009 6:55 AM
    Moderator
  • Mike,

    I called MS Support and they said the link http://www.microsoft.com/express/sql/download you provided must be outdated since it reverted to http://www.microsoft.com/express/Database/.

    My issue is that when I tried to download SQL Server 2008 R2 Express it ran for about 30 minutes and then gave a Net Framework error stating that "an Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attemp to continue....." Once I clicked Continue and it did continue to run but came back with a setup that showed Powershell failed. Then I tried to download Powershell which seemed to work but still could not install SQL Server 2008 R2 Express without receiving the same Unhandled exception.

    Do you know how I can see if Powershell really did install? Also, do you have another link to the wizard that would take care of installing everything? I'd really appreciate any help you can give me. Thanks allot!

    Tuesday, July 13, 2010 9:27 PM
  • Mike

     

    I too had the same problem during the 'epic' installation of SQL Server 2008 R2 Express.  Annoying isn't it!  I installed the Powershell but now cannot get the SQLSERVER service to start and have looked for:

    compressed folder - no

    insufficient disk space for master/model etc - no

    service login as local system - yes

    Think I'm gonna stick to MS Access!!!

     

    Wednesday, July 14, 2010 12:25 PM