November 25, 2008 at 1:27 am
Hi,
I installed SQL Server 2005 Express Edition (SERVER\SQLEXPRESS) + Management Studio Express some time ago, but later on, installed SQL Enterprise Edition with another instance called SERVER\SQL2005
But problem is when i start Management Studio, it is the old EXPRESS version and do not have advanced options which are supported by SQL Enterprise edition.
Can someone help me upgrade Management Studio because i can't find a standalone version for this.
Thanks.
Waseem
November 26, 2008 at 5:36 am
You should be able to uninstall SQL Server Client Tools and then install them from the SQL Server Enterprise installation CD. See the help files from the install CD or check BOL.
November 26, 2008 at 6:25 am
or if you have another machine with the enterprise version of the tools copy this reg key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\Checksum
make sure you back up your existing one in case there are problems.
November 27, 2008 at 6:29 am
For SQL Server 2005, the server components and the client tools are on separate CDs. Try installing the tools using the Tools CD.
If you are installing from a DVD, look for the \Tools folder and install from there.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply