I cant install the server components

  • I installed sql server 2005, but unfortunately although i loaded sql server components, it did not get installed.

    All i got was start-programs-sqlserver2005- configuration tools----

    Now further i have already installed visual studio 2005.

    I want to remove and install again the sql server

    I have in my control panel

    Microsoft sql server 2005 630 mb

    Microsoft sql server 2005 backward compatibility 26.6 mb

    Microsoft sql server 2005 mobile [ENU] developer tools 67.89 mb

    Microsoft sql server native client 4.25

    Microsoft sql server setup support files(english) 21.03

    Microsoft sql server 2005 vss writer 0.69

    SQLXML4 2.72 mb

    Should I uninstall all the above and reinstall again

    Kindly help pls

    regards

    cmrhema

  • What operating system?

    What edition of SQL were you installing?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • My OS--Windows xp professional

    Installling --Sql server 2005 Enterprise Edition

  • You can't install the server components of Enterprise edition on a non-server OS. Basically, to install the server components of SQL Enterprise edition, you need Windows Server 2003 or Windows Server 2008.

    If you're working on a dev machine (non-server OS), install developer edition. The server components of developer edition can be installed on any OS. Alss, bear in mind that if you install Enterprise, it has to be licensed and it's not cheap. Developer however is.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks Gila .Can I have a free download of Developer Edition.

    And in case I have to install Developer, do I need to uninstall those mentioned in my first post

  • cmrhema (4/12/2009)


    Thanks Gila .Can I have a free download of Developer Edition.

    No. It's $50. Buy it from Amazon if you don't have an MSDN subscription

    And in case I have to install Developer, do I need to uninstall those mentioned in my first post

    Probably a good idea.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hi,

    I installed the SQL Server Management Studio Express from

    http://www.microsoft.com/express/sql/previous/default.aspx

    I have installed that successfully.

    But when I start the, I have that dialog box that asks for the Server Name from the drop down box, I gave local, and gave . and also tried giving my computer name.

    But to no avail.

    What could be my problem

    Regards

    cmrhema

  • Management Studio Express is, as the name implies, just Management Studio, ie the client components. If you want SQL Server Express Edition, it's a separate download.

    It's on the same page that you downloaded management studio from, it's the link right above the one for management Studio Express

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks for the prompt reply

    But one question(sorry if its too silly),

    should i install

    SQL Server 2005 Express Edition,

    or

    SQL Server Management Studio Express,

  • cmrhema (4/13/2009)


    Thanks for the prompt reply

    But one question(sorry if its too silly),

    should i install

    SQL Server 2005 Express Edition,

    or

    SQL Server Management Studio Express,

    SQL Server 2005 Express Edition is just the Express database engine with no client tools

    SQL Server Management Studio Express is just the client tools, no database engine.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks

    After installing the problem has been solved

    Many many thanks

  • cmrhema (4/12/2009)


    I installed sql server 2005, but unfortunately although i loaded sql server components, it did not get installed.

    All i got was start-programs-sqlserver2005- configuration tools----

    Now further i have already installed visual studio 2005.

    I want to remove and install again the sql server

    I have in my control panel

    Microsoft sql server 2005 630 mb

    Microsoft sql server 2005 backward compatibility 26.6 mb

    Microsoft sql server 2005 mobile [ENU] developer tools 67.89 mb

    Microsoft sql server native client 4.25

    Microsoft sql server setup support files(english) 21.03

    Microsoft sql server 2005 vss writer 0.69

    SQLXML4 2.72 mb

    Should I uninstall all the above and reinstall again

    Kindly help pls

    regards

    cmrhema

Viewing 12 posts - 1 through 12 (of 12 total)

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