We help IT Professionals succeed at work.

SQL Install

I'm trying to install SQL 2008 R2 on a Windows 7 32 or 64 bit but I'm getting the error Error
Only on two systems I get this error. When I'm using the same DVD on other systems it work like a charm.
Comment
Watch Question

Commented:

Are you trying to install with administrative rights?  Is there another version of SQL which might be running while this install is happening?

If you can post a detailed log file, someone here could certainly take a closer look.
Distinguished Expert 2019
Commented:
copy the dvd to a network share, browse to the network share, right click on setup.exe and run as administrator.
I have never seen a DVD on S drive - is it a custom drive letter for the CD or are you mapped to it over the network?

If you are mapped over the network - then when windows elevates an exe that is stored on the network it changes the EXE to unc execution because your network mapped drives are not available while elevated.  If, however, the EXE uses the "working directory" to locate other setup files, it loses the path to these as there is no working directory via UNC execution.

You can either:

Elevate a command prompt and re-map the S: drive and execute.

Or

Set the following registry key and all network mapped drives will be available even after elevation so that you don't have to map each time: http://support.microsoft.com/kb/937624

Commented:
Do NOT attempt to install over the network, instead use the physical install media.
Stelian StanIT Services Manager

Author

Commented:
CSI-Windows:
The S drive is a mounted drive. I use Daemon Tools for that. All other media is working fine if I'm mounting on that drive.

ve3ofa:
Sorry I didn't see your post last night and I spend my time testing it but you are right the solution was to copy the DVD to a network drive and run it from that location.

I will split the points between ve3ofa: and CSI-Windows: even though I saw the solution after I solved the problem. Running from the DVD or from a virtual media is still not working yet and I think the problem is with IE security. If I will have time I will try to fix that too and I will post the solution.
I am not sure how Daemon Tools is implemented (I use Virtual CloneDrive http://www.slysoft.com/en/virtual-clonedrive.html), but it may appear as a network drive at the Windows API level when it enumerates.

Try elevating a command prompt and see if you can see the S: drive.

If not, then it is likely to be UAC as I mentioned, however, only the EnableLinkedConnections registry key could fix it via the KB article I referenced above.
Stelian StanIT Services Manager

Author

Commented:
I'm getting the same result even if I'm using the DVD drive itself.
Hmmmm...  If you still need a solution here, I would pull out procmon (http://live.sysinternals.com/procmon.exe) at this point and find out what files it is referring to.
Stelian StanIT Services Manager

Author

Commented:
That's my next step but right now I don't have time to do that. Thank's so much for all your help.

Commented:
is this original Microsoft media or media you made using a downloaded iso? Are you using high quality media e.g. verbatim etc.? Are the DVD drives on the machines failing the install up to date on their firmware? Can you install a different MS program on any of the 2 machines from CD or DVD e.g. Office for testing?
Stelian StanIT Services Manager

Author

Commented:
This a media I made myself using the Microsoft ISO file. I tested this media on another 4 computers on my network and is working just fine.
I have no problem installing other Microsoft software.
I have the same message even if I'm using the mounted ISO.
Time for process monitor so that you can see what files it is talking about.

Please upload the procmon log if you're having trouble isolating the problem.