December 5, 2008 at 11:25 am
Hi everyone. I'm attempting to install SSMS onto an instance that did not have SSMS installed when it was created. When I attempt to install the management component that contains SSMS it tells me it can't install the component 'cause it already exists in the instance, even after it's deleted in add remove programs. How can I install SSMS? Thanks to everyone for being there to help.
SQL 2005 Standard SP2
December 5, 2008 at 12:53 pm
You cannot run the install again to 'Add' components to a SQL Server instance. You need to go into Add/Remove and select Change. Once that starts, you will be able to modify your instance and add the components you want.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 5, 2008 at 1:09 pm
are you sure you uninstalled common componenets also of sql server 2005 instances.
can you check log files to see any unusual error under C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
December 5, 2008 at 1:51 pm
Thanks Jeffrey. Using the change option yeilds the same results... indication is the client is install but SSMS is not available.
December 5, 2008 at 1:57 pm
Just to verify - go to Start | Run and type in SqlWb.exe. If the client tools are on that system, then that should work.
If not, then you need to complete the uninstall - I believe there is a tool available from Micorosoft to completely remove this, but I am not sure nor do I have a link.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 5, 2008 at 2:04 pm
Thanks Joseph. What are the common components?
December 5, 2008 at 2:14 pm
Thanks Jeffrey! You nailed it. The sqlwb.exe launches SSMS. It doesn't show as a selection on the drop down menu. Would you know why?
December 5, 2008 at 2:22 pm
A selection in what drop-down?
You should be able to find the link in Start | Programs | SQL Server 2005. What you are looking for is SQL Server Management Studio.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 5, 2008 at 2:26 pm
Exactly... it's not there.
December 5, 2008 at 2:29 pm
I am not sure why the install did not place the shortcuts. Could the install have run under a different user account? And, that user account does have the shortcuts?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 5, 2008 at 2:45 pm
All services run under identical service accounts
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply