Can install sql 2005 tools

Posted on 2007-12-03
Last Modified: 2010-05-18
XP Pro SP2 workstation.
x86 SQL Developer edition
MSDN DVD disk.
Failed the first time (I am trying to install client tools) so I ran it again this time I used "run as" and used the domain admin account.
When it runs through it's prereqs it shows a warning about needing permissions to write to disk. I have this permission and the domain admin certainly does so I took it as a generic warning.
It runs through it's tasks.... first it fails for sql server native client - the summary log says Error String    : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
It also fails for the client tools but there is nothing about this in the log.

As an aside I ran 'sqlncli.msi' manually and it got half way through and then asked me to insert a disk. This is MS's DVD... no multuiple CDs
Any ideas what is going on?
Question by:QPR
  • 3
  • 3
LVL 30

Expert Comment

ID: 20400820
Can you just try creating a text file in the disk, and make you sure you really really do have permissions.
LVL 29

Author Comment

ID: 20405585
in program files - ms sql server 2005?
Yep will do, but it already installed BOL, tutorials and sample apps there, plus the xml stuff
LVL 29

Author Comment

ID: 20405600
yep no problem, it's installed sql mobile 2005 in the prog files group too.
I often install software (my own and 3rd party) on this workstation.
I should add that this machine already has 2000 installed but apparently that is no problem.
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

LVL 30

Accepted Solution

nmcdermaid earned 500 total points
ID: 20407358
You could download FileMon from here:

and monitor the install. FileMon will tell you if any file activities are failing, why they are failing, and what they are running as.

Its a pain and there's a lot of data but it should give you a clue.

LVL 29

Author Comment

ID: 20408256
cheers, I'm a bit snowed under at the moment so may take the easy way out and install (hopefully) using the CDs (pre DVD days) that were in the previous MSDN mail out.
LVL 30

Expert Comment

ID: 20408313
Yep that'll be a lot quicker than messing about with FileMon!

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

705 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

20 Experts available now in Live!

Get 1:1 Help Now