Post reply

SQL 2005 Management Studio doesn't show up on new install

  • August 8, 2011 at 10:28 am

    #242729

    We just installed SQL 2005 on the server with the Mgt Studio tools installed. However, it does not show up under Start, Pgrm, Microsoft SQL Server 2005. When we attempt to do a new install to install the client tools it tells us there is nothing to install so it must think it is installed.

    I cannot seem to find the path to the executable for it. Has anyone seen this issue or know what the path for Mgt Studio 2005 is OR what the executable is called?

    sqlwb.exe and ssms.exe I cannot seem to find either.

  • August 8, 2011 at 10:31 am

    #1365350

    Just type sqlwb on Start->Run and see if Management Studio comes up?

    M&M

  • August 8, 2011 at 10:34 am

    #1365353

    It says Windows cannot find 'sqlwb'

    Is sqlwb for SQL 2005 or 2008? We are running 2005.

  • August 8, 2011 at 10:34 am

    #1365354

    Unfortunately I have this install outside the default path on my 2005 box. However this is the filename : SqlWb.exe

    For 2008 R2 express : C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

  • August 8, 2011 at 10:34 am

    #1365355

    Mohammed's suggestion is good. I assume you searched the all hard drives for sswb.exe?

    If you look under Program Files/Microsoft SQL Server/90/Binn (or the similar path) are the tools not there?

    Perhaps you had a broken installation of some sort on the client tools. I haven't seen this, or seen it reported, but it's possible.

    What OS?

  • August 8, 2011 at 10:38 am

    #1365358

    Win2003R2 32 bit and SQL 2005 32 bit

    C:\Program Files\Microsoft SQL Server\90\Tools\Binn

    This path is there but no sqlwb.exe

    It appears I am in a catch 22... it isn't there but when I go to try and install the tools now and check the Mgt tools it says there is nothing to install.. thinking they are already installed.... crap.

  • August 8, 2011 at 10:44 am

    #1365365

    If this is new, can you uninstall completely?

    If not, you might be able to clean out the registry and folders, but that would make me nervous. Or run setup and try to "repair", or remove the tools? Sorry, don't have a spare VM w/ 2005 handy to test uninstalls.

  • August 8, 2011 at 1:22 pm

    #1365484

    Thanks everyone for your input. I guess a reinstall will be the way I go.

  • August 9, 2011 at 10:39 am

    #1366060

    I found a workaround and it worked. Much better than a total re-install.

    To install the Mgt Studio just run "SqlRun_Tools.msi" from your setup disk.

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

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