SQL 2005 Management tools

Hi, I installed sql 2005 dev for testing sharepoint, and the management studio was not installed. Now, i am afraid to try to install it because i am thinking it may uninstall or re-install all sql components (and probably erase existing instances and sharepoint data may be lost. I have installed on an other pc the client tools, but i cannot connect to that instance, and i cannot attach the user databases (i get the 5123 error)

Can anyone help me how i can install management services without messing up the sharepoint instance



Answer this question

SQL 2005 Management tools

  • eugenz

    Adding components through setup will not uninstall exsting components or user data. There are likely components in SQL Server Database Services that are needed to support managements tools, hence the reason this needs to be installed. Go ahead with the installation it should be fine.

    Thanks,

    Peter Saddow



  • FatAmos

    Even though i am not selecting database services, it tells me:

    The following components will be installed:

    -SQL server Database Services (database services)
    -Client Components (Connectivity Components)

    Will it re-install it (sorry but i haven't used sql 2005 at all and i'm very cautious about doing anything to it because i don't want to mess anything up)


  • Vjy

    Setup doesn't uninstall existing products when you run it multiple times. You need to run setup and select Workstation Components and you'll get Management Studio without affecting any instance already installed.

  • SQL 2005 Management tools