Solved

Can install sql 2005 tools

Posted on 2007-12-03
6
591 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
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: …

728 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