Menu
I have SQL Server 2008 R2 Express installed on my workstation. I’m in the process of learning Entity Framework, and wanted to use the Management Studio Profiler to help understand the SQL commands generated by EF.
Since the Express version does not include the Profiler, I installed SQL Server 2008-R2 Developer side-by-side with Express. The installation went perfectly and I had no problem adding my databases to the full Server installation.
The problem is that Management Studio – Complete was not installed with the full SQL Server so I still don’t have access to the profiler. I re-ran the installer so I could install the Complete version, but it is greyed out and I cannot select it for installation.
Can someone help me get Management Studio – Complete installed?
If I have to uninstall the Express version, will that hurt anything (I have VS2010 Ultimate installed as well)?
Thanks!
930
Launch the SQL Server Setup program (setup.exe) from SQL Server installation media. After prerequisites and system verification, the Setup program will display the SQL Server Installation Center page. Click Maintenance in the left-hand navigation area, and then click Repair to start the repair operation.
Make sure the machine is of the required spec to run the version of SQL you are installing. I.e. if it is SQL EE then make sure you have NT EE. For SQL 7 you need a 100% PENTIUM compatible chip or an Alpha - older Cyrix/IBM chips that do not support the full pentium instruction set will not work.
Steps. Locate the Microsoft SQL Server 2008 Management Studio Express download page. Click on "Download" and in the window that comes up, select "SQLManagementStudio_x86_ENU.exe" and then click "Next." Once the download finishes, run the installer.
After SQL Server Express and Management Studio Basic were uninstalled, I started the SQL Server 2008 R2 installer; this time I was able to select Management Studio Complete for installation. The installation process executed normally; when it finished the Complete version of Management Studio was available and I was able to execute the Profiler.
However, the Management Tools feature does not seem to be selectable. The screen-shot below shows which Features are available for me to select: I have made sure that the SQL Server 2008 R2 Management Objects was installed!
After that I was able to do the install of the complete tools. Run the installer -> Maintenance -> Edition Upgrade -> follow the wizard. Then -> Run the installer -> Installation -> New SQL Server stand-alone ... -> ... "Add features to existing install" -> Management Tools - Complete.
To solve the problem I uninstalled SQL express and the Basic version of Server Management Studio. Uninstalling SQL Express is not intuitive as it does not appear as a separate item in the “Programs and Features” window. To uninstall it, I right-clicked on “Microsoft SQL Server 2008 R2 (64-bit)” and selected Uninstall/Change”.
I ran into this and had the hardest time getting the Management Tools - Complete to install. I finally got it working by running the upgrade. Even though it was already Enterprise edition with nothing obvious to upgrade I went through the update wizard. After that I was able to do the install of the complete tools.
Steps:
Run the installer -> Maintenance -> Edition Upgrade -> follow the wizard.
Then -> Run the installer -> Installation -> New SQL Server stand-alone ... -> ... "Add features to existing install" -> Management Tools - Complete.
170
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
