| By Jayaram Krishnaswamy |
Article Rating: |
|
| July 20, 2009 10:15 PM EDT |
Reads: |
4,326 |
As related in my previous post, as I could not add the SQL Management Studio from SQLManagementStudio_x86_ENU I decided to try the next one on line,
SQLEXPRADV_x86_ENU.exe (502.7 MB)
It looks like the Add features to an existing instance of SQL Server 2008 brings up a window where everything is greyed out even in this version.
I decided to install with the other option,
P
erform a new installation of SQL Server 2008
This adds a new named instance of SQL Server Express which you will configure in the the SQL Server2008 Setup screens.
I have a default instance installed when I installed VS2010 and the new named instance (which I called VistaExpress) of SQL Express. Now both these can be accessed by the SQL Server Management Studio.
Bottom line:
If you already have a SQL Express installed by VS2010 then you can install SQL Server Managment Studio only if you install another instance.
Perhaps even SQLManagementStudio_x86_ENU can add in SQL Server Management Studio if you were to choose the first option (Perform a new installation of SQL Server 2008)
Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK.
His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham.
Most recently his book, "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc.
He writes articles on several topics to many sites.
Subscribe to Linux Email News Alerts
Subscribe via RSS
