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?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
The first one should be the client tools (sqlncli.msi).
0
 
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
pma111Author Commented:
I dont have the CD and the BPA pre requirements for 2005 specifically ask for 2005 client tools.
0
 
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:
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
All Courses

From novice to tech pro — start learning today.