sql server 2005 client tools

In order for SQL 2005 BPA to run, it requires 2005 "client tools". I have googled for this download but the option brings up endless possible downloads - can anyone point me in the direction of the correct download.
LVL 3
pma111Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pma111Author Commented:
There is this link
http://www.microsoft.com/en-us/download/details.aspx?id=24793

But which of the downloads do you need to install in what order?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you have the SQL Server 2005 DVD you can install the client tools from there.
Or you can try with SQL Server 2008R2 client tools since it's possible to connect to a previous version of SQL Server.
0
pma111Author Commented:
I dont have the CD and the BPA pre requirements for 2005 specifically ask for 2005 client tools.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, because when it was developed didn't exist yet SQL Server 2008.
What about the link you posted. Worked?
0
ste5anSenior DeveloperCommented:
Just for curiosity: What is a BPA and why does it require 10 year old software?
0
pma111Author Commented:
@ste5an - best practices analyser - no idea - just going of the pre-requirements.

@Vitor Montalvão - yes the link works but there are endless downloads listed, which do I need for client tools.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
The first one should be the client tools (sqlncli.msi).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Oh, saw 2 more but depends on what system you have:

sqlncli_ia64.msi ---> Itanium 64 bit
sqlncli_x64.msi ----> 64 bit

So the first one  (sqlncli.msi) should be the version for 32 bit (x86).
0
pma111Author Commented:
Will try that, thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.