Wednesday, February 1, 2012

Workstation components installed but only the Configuration Tab shows. Why?

I have come across this situation many times where someone is trying to install SQL Server 2005 and even after successful installation SQL Server Management Studio is missing even if workstation components was selected in setup screen.
Reason: If you have installed Visual studio, it installs SQLEXPRESS (free edition of SQL Server 2005).
  • Go to Control Panel > add/remove program.
  • Choose Microsoft SQL Server 2005 and click Uninstall (don’t worry we are not removing SQL Server)
  • Uncheck “Remove SQL Server 2005 instance components”
  • Check ONLY “Workstation Components” under “Remove SQL Server 2005 common components”.
Refer below screen
clip_image001
  • Click Next
  • Click Finish.
Now you are good to install Workstation components again.

No comments:

Post a Comment