Solved

Can install sql 2005 tools

Posted on 2007-12-03
6
585 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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
CREATE DATABASE ENCRYPTION KEY 1 82
Help Required 2 55
SQL Server - Set Field Values ito Zero Based on Related Table 4 47
Need to find substring in SQL 5 52
In this article I will describe the Backup & Restore 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.
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.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 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