Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

installing error

Posted on 2011-09-28
24
Medium Priority
?
496 Views
Last Modified: 2013-11-10
when installing, getting the below
tools.bmp
0
Comment
Question by:25112
  • 13
  • 6
  • 5
24 Comments
 
LVL 5

Author Comment

by:25112
ID: 36719454
this is for BIDS 2005 (tools) machine does not have DB engine for 2005..

but complete install is in there for 2008..

is there a problem if 2008 was installed first?
0
 
LVL 5

Author Comment

by:25112
ID: 36719527
we prefer not to install anything 2005 other than the BIDS, if at all possible..
0
 
LVL 5

Author Comment

by:25112
ID: 36768415
If you have SQL 2008 complete install and no SQL 2005 of any sort, would you be willing to install the SqlRun_Tools.msi file in 2005 CD to only install BIDS?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 14

Accepted Solution

by:
Daniel_PL earned 1200 total points
ID: 36813949
Run main setup, directly from root od DVD/CD drive., choose install Server components, tools, Books online...
At the screen Components to Install click on Advanced button. Next choose BIDS from client components node. Components to Install screen Feature selection - Advanced
0
 
LVL 5

Author Comment

by:25112
ID: 36814571
thanks daniel.
just running the SqlRun_Tools.msi  won't do it?
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 36814689
It may help because it installs support files first.
0
 
LVL 5

Author Comment

by:25112
ID: 36814996
>>It may help because it installs support files first.

are you saying CD install from menu maybe is better than just running SqlRun_Tools.msi?

also, did you run the above on a machine that already had SQL 2005?
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 36815211
>are you saying CD install from menu maybe is better than just running SqlRun_Tools.msi?
Yes, it installs Support Files which probably is the case here because you have already installed 2008 product.

>also, did you run the above on a machine that already had SQL 2005?
Yes
0
 
LVL 5

Author Comment

by:25112
ID: 36815543
I am quiet following the 'support files'.. what are they.. are these the help files? (F1)

are they mandatory or optional?

SQL 2008 would have already the support files. are they the same as SQL 2005 support files or different?

why i am asking is the SqlRun_Tools.msi file gave error.. but you did not get the error.. is it because you already had sql 2005 installed?
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 36815610
Support files for installation process. Just try the installation.
0
 
LVL 21

Assisted Solution

by:Jason Yousef, MS
Jason Yousef, MS earned 800 total points
ID: 36819171
1.       Run the Client tools setup from SQLrun_tools.msi and when the feature selection screen comes, select one Client component at a time and EXCLUDE Management Tools to be installed at the end.

2.       Follow any sequence ( like first select Only BIDS under Client Tools Selection Screen.. Install it .... after that run the Setup again->SQLRun_tools.msi and this time select Legacy components.. and so on... )

3.       After all the other Client Components were installed, INSTALL THE MANAGEMENT TOOLS by running the SQLRun_tools.msi setup.

Client tools setup should succeed now.

4.       Although exact reason is unknown at this time, I guess this could be a timing issue as the required DLL's or resource files are not there for the management tools to complete.
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 36890624
@huslayer
Asker wants to install BIDS only. Widely distributed resolution about installing one component at a time doesn't apply here because there is already one component installed at a time - it is BIDS 2005.

>ID:36719527 Author:25112 Date:28/09/11 09:32 PM
>we prefer not to install anything 2005 other than the BIDS, if at all possible..
0
 
LVL 5

Author Comment

by:25112
ID: 36891700
>>Run the Client tools setup from SQLrun_tools.msi

@huslayer, apparently the support files of 2008 did not help? it needs 2005 support files, and hence SQLrun_tools.msi is failing?

can you try to run SQLrun_tools.msi on a machine that has never had SQL 2005 CD before?
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36891824
the support files and client tools are different from 2008 to 2005.

>>can you try to run SQLrun_tools.msi on a machine that has never had SQL 2005 CD before?

do you mean the machine had never installed 2005 but has 2008 installed, or it doesn't have anything at all installed?
0
 
LVL 5

Author Comment

by:25112
ID: 36891905
>>do you mean the machine had never installed 2005 but has 2008 installed, or it doesn't have anything at all installed?
both.
i tried
a)machien with SQL 2008 - complete installation and not SQL 2005 at all - I then ran the 2005 SQLrun_tools.msi, but the above error message was got (picture in question)
b)tried in machine that had no SQL at all before.. I ran 2005 SQLrun_tools.msi  and i got the below
install-error.bmp
0
 
LVL 5

Author Comment

by:25112
ID: 36891913
in both the above cases, i assume 2005 support files would not be per-existing in the machine
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36891938
I've a VM with 2005 and 2008, but 2005 was installed prior to 2008, am not sure if you can do the opposite, never had to do that scenario.
0
 
LVL 5

Author Comment

by:25112
ID: 36891990
>>I've a VM with 2005 and 2008, but 2005 was installed prior to 2008, am not sure if you can do the opposite, never had to do that scenario.

are you saying that because you already had the regular install already, so if you do BIDS only now from the msi file, you will be OK and no error?
but i did not have the setup files before, and  hence getting the error frmo msi install file?
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36892030
so what do you have installed now? and what you're trying to install?
I am confused now :(

the best way to do what you're trying to do is to download a free virtualization software, such as VMware player or VirtualBOX and have 2 separate environments for testing and for conflict free.
0
 
LVL 5

Author Comment

by:25112
ID: 36892174
@huslayer, i am good now, because i went through the CD menu.. but I was just trying to understand why SQLrun_tools.msi gave me error on both counts
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36892242
But still, listen to my advise if you need more than version of SQL or VS, because you'll use once or twice, maybe for testing, so it doesn't worth the hassle of fighting errors and conflicts.

clean smooth installation is the best.
0
 
LVL 5

Author Comment

by:25112
ID: 36892271
>listen to my advise
yes. thanks.

>>if you need more than version of SQL or VS
i don't get you.. are you asking if it won't be used much

>clean smooth installation is the best.
yes that is what i wanted to understand.. and my understanding right now from you and Daniel is that I have to install from CD, if first time, and then choose BIDS 2005 only. If VS 2005 is already installed, then I don't have to install BIDS 2005. But if Can installed 2005 SQL DB Engine, if I needed to, right?
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 36892350
>@huslayer, i am good now, because i went through the CD menu.. but I was just trying to understand why >SQLrun_tools.msi gave me error on both counts
As I wrote, your problem was in not having Support Files installed.

>yes that is what i wanted to understand.. and my understanding right now from you and Daniel is that I have to >install from CD, if first time, and then choose BIDS 2005 only. If VS 2005 is already installed, then I don't have to >install BIDS 2005. But if Can installed 2005 SQL DB Engine, if I needed to, right?
Yes, indeed you can install additional components later, including the database engine itself ;)
0
 
LVL 5

Author Comment

by:25112
ID: 36892374
thanks for confirming
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

972 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