Tuesday, April 23, 2013

How to add SQL Profiler to an existing SQL 2008 R2 install

Went lookup for some help to solve this problem.  We had a VM which had did not include the SQL profiler tool!  Did not know it until I went to fire up this tool and it was not there under the tools menu. 

This thread put me onto the solution.

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/4808224c-1adb-4e43-8ae8-c45aba48abb1

Here is the short solution to the problem.

Open cmd.exe.  On some machines due to local policies you may need to run this session as administrator.

setup.exe /FEATURES=Tools /Q /INDICATEPROGRESS /ACTION=Install /INSTANCENAME=
YOURMACHINENAME\YOURINSTANCE /BROWSERSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /IACCEPTSQLSERVERLICENSETERMS

This takes a bit of time to run but don't fret just let it run.  It will finish.

No comments:

Post a Comment