Solved

Adding Analysis Services to existing SQL Server 2005 Installation

Posted on 2008-06-26
2
1,024 Views
Last Modified: 2010-04-21
I have an existing SQL Server 2005 Installation with Service Pack 2 installed and it's running on Windows Server 2003. For this program that I'm trying to run, it's asking me to add Analysis Services to SQL Server 2005. How do I go about doing that without accidentally uninstalling SQL Server 2005? All I know is that I go to Start > Control Panel > Add/Remove Programs > SQL Server 2005 > Change. Then from here I suppose I go to "Install a new component", find the setup file, then press next.. then I get lost when I get to the Components to Install page. If I just click on "Analysis Services" and continue, will it just add analysis services or will it uninstall all the unchecked components as well?
0
Comment
Question by:akgarcia
2 Comments
 
LVL 13

Accepted Solution

by:
rickchild earned 125 total points
ID: 21881805
The Add New Component method will be fine, but you could also just run the DVD/Setup again and add only Analysis Services.
0
 

Author Closing Comment

by:akgarcia
ID: 31471093
I think I got it. Thanks.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now