Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Liz Lyons
Starting Member
22 Posts |
 Posted - 2010-04-10 : 12:45:51
|
I installed SQL Server 2008 Evaluation edition in order to test some examples from a study course that I am following. The computer also had SQL Server Express Edition running on a different partition of the disk.I now find that the Performance Tools: Database Tuning Advisor, Profiler etc are missing. Can anyone suggest the best way to solve this, given that I have already installed Adventure Works on the Evaluation Edition and saved some work on it???I wonder whether this happened because the installer file assumed that both editions would share the management tools of the Express edition?  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-04-11 : 01:42:38
|
| Uninstall the Express tools - then run the Evaluation Edition again to install the client tools. You might have to go to Add/Remove and use the change option to add the client tools. |
 |
|
|
Liz Lyons
Starting Member
22 Posts |
Posted - 2010-04-11 : 10:37:21
|
| Thanks Tara, but no.When I go through the installation features process it shows Client Tools as already installed. However, if I run the Installed SQL Server Features Report from the installation centre it shows Client Tools as installed on the SQL Server Express instance, which seems to make Profiler and Database Tuning Adviser unavailable.I see that the installation notes say "however many instances of SQL Server are installed only one instance of Management Studio, Reporting Services, Analysis services is installed".I don't know how to get around this since I believe that Management Services will on install with a full install, not separately!Please do you know anyone who can advise?? |
|
|
|
Liz Lyons
Starting Member
22 Posts |
Posted - 2010-04-11 : 10:45:15
|
| Jeff, thanks very much for your quick reply.It's encouraging to have supportive advice from the other side of the globe!I believe you BUT am also cautious, because worried about rendering both instances non-functional, and then also having licensing problems installing a second instance of Evaluation edition.Are you speaking from practical experience of having re-installed SSMS after deleting a previous instance please? |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-04-11 : 11:55:51
|
| I can't really say practical experience, since I have never installed Express on a production system. I have un-installed/re-installed many components on production servers.The only way (that I know of) to install the client tools now is to change the current installation from Add/Remove. Select the change option and you will be prompted to add components. Run through that process and you will be able to install the client tools. But, you need to uninstall the Express client tools first. |
|
|
|
|
|
|
|
|
Missing Performance Tools