How to instal sql server 2005(RTM) on windows server 2008 r2(64bit)?? error occured

  • Hi guys,

    i just installed win server 2008 r2 enterprise and then trying to install sql sevrer 2005 devloper

    im trying to instal sql sever 2005 developer edition on 2008 r2 ...

    im able to process upto

    setup progress ( the selected components are being configured screen) running

    after some time got error like

    ""There was an unexpected failure during the setup wizard.you may review the setup logs and/or clcick othe help button for more information""" PFA for pic

    but by clciking on the help also nothing is coming the whole setup is closing..

    and in control panel some of the sevices are installled like (scm) and analysis services and integration servises and im unabl;t to open ssms..

    im trying on test machine..

    pls reply im trying this from past 1 week on internet but couldn't figure out

    Thanks

    Satish

  • So did you check the setup log ??


    Sujeet Singh

  • no ...

    can u tell me where it will be????

    im new here...

  • satishm94 (2/23/2012)


    no ...

    can u tell me where it will be????

    im new here...

    You can find it under the directory path:

    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log


    Sujeet Singh

  • thnx,

    got this one

    WIN2008 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.

    WIN2008 : 64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

    can u tell me how to instal this one..

    because the first one is pre installe done..

    how can i change it??

  • thanx for reply..

    need to go.. shift over..

    will try tomorrow and let u people know..

    meanwhile.. any other links/ suggestions appreciable..

    thanx again guys

  • hi guys...

    could nt get succeed..

    same error....

    any other suggestions......

  • Hi..

    this time i tried to install without selecting analysis services. so no need to worry about reporting services..

    and

    everything gone smoothly got successfully finished without any error..

    but when i type sqlwb in command line couldnt get any..

    in programs also not there

    is analysis services is mandatory to instal and run ssms??? PFA fro pic

    thanks

  • satishm94 (2/23/2012)


    Hi..

    this time i tried to install without selecting analysis services. so no need to worry about reporting services..

    and

    everything gone smoothly got successfully finished without any error..

    but when i type sqlwb in command line couldnt get any..

    in programs also not there

    is analysis services is mandatory to instal and run ssms??? PFA fro pic

    thanks

    You do not need Analysis Services OR Reporting Services to get SSMS. You just need to select "Workstation Components And Book Online" option (along with other services that you are installing) when you are choosing the components to install during the installation. SSMS will be installed.


    Sujeet Singh

  • did you only want SSMS?

    Have you installed any of these features

    DB Engine

    Analysis Services

    Reporting Services

    Integration Services

    If you have what media did you use to install them?

    SQL Developer Edition

    MSDN Downloaded Media

    SQL Standard

    SQL Enterprise

    If any of the features have been installed by any of the last two do you have a licence to install SQL?

    If its only SSMS, then as DF said, you only need to install the workstation components

  • no iwant all other features...

    but im unable to process becuse of asp .net 64 bit version fro reports...

    so

    i tried to install without analysis services and workstation components...

    but now i selected the workstation components but im unable to install

    same error im getting......

    thanks

  • as its sql 2005 i take it you have configured IIS correctly first and followed to link provided.

    are you trying to install SQL 32bit or 64bit and is your server 32 or 64 bit?

  • i think the installation stopping after integration services..

    may be this one also need to unchecked

    this time i tried by selecting only sql server datbase services and workstation components& books online

    pch... ;( no luck this time also

    can any one plz tell me the solution for this

    im trying sql server 2005 devloper edition on win server 2008 r2 enterprise

    thanks

  • satishm94 (2/24/2012)


    i think the installation stopping after integration services..

    may this one also need to unchecked

    I would suggest to uninstall current configuration & start a fresh installation.

    In fresh installation, choose only these two components:

    1. Database Engine

    2. Workstation Components & Books Online

    It should install successfully & you should be able to login to SQL Server.

    Once above gets installed successfully, you can run the setup again to add more components (SSIS,SSAS,SSRS etc.) as per your requirement.


    Sujeet Singh

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply