SQL Server 2005 installation

  • After installation, when I go program files and sql 2005 the options I get are Documentation Tutorials and Configuration Tools.

    Under configuration tools the options are :

    SQL Server Configuration Manager

    Error Usage Reporting

    Surface Area Configuration

    Notification Services Command Prompt

    Reporting Services Configuration

    How do I get to the interface like Enterprice Manager or Query Anylyzer? I know that window is called SQL Server Management Studio. How do I get there?

  • Are you by chance running SQL Server Express Edition? If so you may need to download SSMSEE (SQL Server Management Suite for Express Edition) separately.

    You can find that here:

    http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en%5B/url%5D

    Note - that download will NOT work against any other version of SQL Server 2005. If you're not dealing with Express - try reinstalling the client tools components.

    If all else fails - do a search for SQLWB.exe. It may just not have created an icon for it.....

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • I'm running the Enterprise edition at work.

    I did not find the file SQLWB.exe on my HD.

  • There are options when you install SQL Server for installing server components and/or client components. The assumption with Enterprise and Standard is that you will install those on different computers.

    Run the install disk again, and make sure to select "Client Components".

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • I have reinstalled the Client components and still does not show the SQL Management Studio. When I rebooted the computer I got an error msg when windows was loading up. the error msg was:

    Your SQL Server installation is either corrupt or has been tempered with(Error getting instance ID from name). Please uninstall then re-run setup to correct this problem. 🙁

    After My last installation, when you go to programs and sql 2005, I got 2 options: Configuration manager and a tutorial. the tutorial did not appear this time. Very frustrating.

  • Not sure what to do about that one. I haven't had an installation go bad on me in that way.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Thank for all the feedback I received. I have to uninstall SQL Server 2k5 using the microsoft uninstall utility program. Then delete anything left over in the Registry -> Current User -> Software ->Microsoft -> Micosoft SQL Server AND

    Registry -> Local User -> Software -> Micorsoft -> All SQL Server entries (Including the Native Client).

    After reinstallation, I got all the components including Management Studio and for the first time the BI ie SSIS 😀

  • Excellent. Glad it worked out for you.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 8 posts - 1 through 7 (of 7 total)

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