how to install sql server 2005 management studio ?
-
Hi All,
How can I install sql server 2005 developer edition management studio over a vista machine which has the visual studio 2005 prof edition installed in it?
The vista machine has already got sql server 2005 express edition isntalled with the installation of VS 2005 prof edition. Do I have to uninstall the express edition before i can isntall the SSMS from developer edition? I need to use it to manage a test box server we have that sql server 2005 developer edition installed. Please help!
-
You need to run the sql dev setup and install client tools only; if you would want to install the sql dev db engine as well then you have to create a sql named instance.
-
yeah.. i tried to select and install the management tool only but the system gives me a feedback as
----------------------- cut begin -------------------
Existing Components
Components have been found on the machine. Select upgrade options below.
The following components that you chose to install are already installed on the machine. To view a report of avialable options and alternatives click on Details.
[] Workstation components, Books Online and development tools 9.2.3042.00 <--- Grey out
-------------------------- cut end -------------
If i hit detail button i got the following message
------------------------ cut begin -----------------
Name: Microsoft SQL Server 2005 Tools Express Edition
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
------------------------- cut end -----------------
However, the only SQL Server 2005 related thing installed in this machine is the SQL 2005 Express which installed when I installed the Visual Studio 2005 Prof. So, do I have to uninstall SQL 2005 Express before I can install the 2005 developer edition management studio? Or, they can co-exist? I mean the 2005 Express edition database with the 2005 develooper edition management studio. My expreience on 2000 is that i can just install the enterprise manager to any machine and then registered the server which i want to manage.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply