Tomas Jansson

Now I’ve had this issue one or two times but this is the first time I actually managed to solve it. The scenario is that I had SQL Server 2008 R2 Express install, which is missing the profiler tools. So I thought I’ll just upgrade to standard since we have licenses at my company. That is easier said than done, when upgrading to standard the tools is not updated only the server, so now you have an updated server but basic tools. To update the tools you need to uninstall the tools first, but the trick is to how. So here is how you uninstall the tools:

1. Open the control panel and then Program and Features
2. Find “Microsoft SQL Server 2008 R2 (xx bit)”
3. Right click and choose “Uninstall/Change”
4. Choose “Remove”
5. Follow the wizard until you get to “Select Instance”
6. In the drop down choose “<<Remove shared features only>>” and click “Next >”
7. Select “Management Tools – Basic” and then continue and finish the wizard to uninstall it

Now when you have uninstalled the basic tools it is time to install the complete tools, so insert the DVD or mount the iso-file and run Start Setup.exe.

1. Click in “Installation” and choose “New installation or add features to an existing installation”
2. Click “OK” in the “Setup Support Rules” screen
3. Click “Install” in the “Setup Support Files” screen to install the support files
4. Click “Next >” in the second “Setup Support Rules” screen
5. Select “New installation or add features” and click “Next >”
6. Choose license and click “Next >”
7. Accept license and click “Next >”
8. Choose “SQL Server Feature Installation” and click “Next >”
9. Check the “Management Tools – Complete” and finish the wizard to install the complete tools

If you follow the steps above you should now have installed the complete tool set to SQL Server including SQL Profiler.