Solved

Can install sql 2005 tools

Posted on 2007-12-03
6
580 Views
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?
0
Comment
Question by:QPR
  • 3
  • 3
6 Comments
 
LVL 30

Expert Comment

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

Author Comment

by:QPR
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
0
 
LVL 29

Author Comment

by:QPR
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.
0
Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

 
LVL 30

Accepted Solution

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

http://www.microsoft.com/technet/sysinternals/utilities/filemon.mspx

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.

0
 
LVL 29

Author Comment

by:QPR
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.
0
 
LVL 30

Expert Comment

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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Divide by zero error encountered. 2 44
Order by but want it in specific order 2 35
Replace Dates in query 14 55
Database maintenance 36 98
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
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.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

685 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