?
Solved

Can install sql 2005 tools

Posted on 2007-12-03
6
Medium Priority
?
597 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 30

Accepted Solution

by:
nmcdermaid earned 1500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

765 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