SQL Server 2008 R2 Express with advanced services installation does not have all options

installation sql-server-2008r2-express management-studio-express
pqsk picture pqsk · Mar 1, 2012 · Viewed 19.4k times · Source

I don't know how else to ask this, and I think the title could be changed. I've been downloading different SQL Server Express versions, and I can't seem to find the one that has the Management Studio Express, the fulltext search, and the Reporting Services, replication, bi dev studio, management tools basic, sql client connectivity sdk, ms sync framework. I have found some installations have some of these, but not all of these features. To be honest I would like the full text search, the management studio express, and the bi dev studio, but they are lacking. where can I get these? Any help. I found info here:

 http://www.mssqltips.com/sqlservertip/2024/introduction-to-sql-server-express-2008-r2/
 http://www.sqlmag.com/article/sql-server/sql-server-2008-r2-express-installation-options

I've downloaded and tried:

  • SQLEXPR32_x86_ENU
  • SQLEXPRADV_x86_ENU
  • SQLManagementStudio_x86_ENU
  • SQLEXPRWT_x86_ENU

I installed the bare bones SQL Server 2008 R2 Express and I notice if I go to add shared features it doesn't show some of the other features, but if I add a new instance it gives me some (but not the ones I need). Can someone guide me please? Do I need to uninstall everything and try again?

Answer

pqsk picture pqsk · Mar 7, 2012

My solution was to uninstall the sql express that I originally installed and then reinstall with advanced services and that included everything. I have no idea why it was not letting add anything additionally. Maybe someone has some thoughts on that (or some facts). Anyways it installed completely now. Thank you Dan for your efforts. Greatly appreciated.

Related questions

How can I install pip on Windows?

pip is a replacement for easy_install. But should I install pip using easy_install on Windows? Is there a better way?

Read More
How do I install pip on macOS or OS X?

I spent most of the day yesterday searching for a clear answer for installing pip (package manager for Python). I can't find a good solution. How do I install it?

Read More
How do I install and use curl on Windows?

I am having trouble getting curl to run on Windows. I have downloaded a curl zip file from here, but it seems to contain source code, not an executable. Do I need to compile curl to run it? If yes, …

Read More