Where Learning is Pleasure

Jayaram Krishnaswamy

Subscribe to Jayaram Krishnaswamy: eMailAlertsEmail Alerts
Get Jayaram Krishnaswamy: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Related Topics: Microsoft Developer

Blog Feed Post

Finally I Installed SQL Server Management Studio on Vista Home Premium

Add features to an existing instance of SQL Server 2008

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)

Read the original blog entry...

More Stories By Jayaram Krishnaswamy

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. 3. "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. 4. "Microsoft Visual Studio LightSwitch Business Application Development [Paperback] "(2011) was published by Packt Publishing Inc. 5. "Learning SQL Server Reporting Services 2012 [Paperback]" (June 2013) was Published by Packt Publishing Inc. Visit his blogs at: http://hodentek.blogspot.com http://hodentekHelp.blogspot.com http://hodnetekMSSS.blogspot.com http://hodnetekMobile.blogspot.com He writes articles on several topics to many sites.