===================
You are trying to install Client tools on a standalone machine and it fails with the following errors:While configuring the Work Station components:
"Microsoft document explorer" "cannot find one or more components. please reinstall the application"Click Ok and then you get
"Microsoft Visual Studio Macros" ""cannot find one or more components. please reinstall the application"
Click OK and then you get
---------------------------Microsoft SQL Server 2005 Setup---------------------------There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. ---------------------------OK ---------------------------
After this the complete Setup Rolls back and it fails going further
SOLUTION
========
Here are the steps we followed to get this resolved
1) Error in the Summary.txt
Sumary.txt shows {under 90/Setupbootstrap}===========================================Machine : E-CONTESTProduct : Workstation Components, Books Online and Development ToolsError : There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. --------------------------------------------------------------------------------Machine : E-CONTEST Product : Microsoft SQL Server 2005 Tools Product Version : 9.00.1399.06 Install : Failed Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0011_E-CONTEST_Tools.log Error Number : 1603 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
Also looked at the Tools log to figure out the actual cause==============================================Set_CommitFlag called successfully.Committed
Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe, command: /setup MSI (s) (2C:A8) [23:52:06:398]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=947502671,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=3)MSI (s) (2C:A8) [23:52:06:398]: Executing op: DialogInfo(Type=0,Argument=1033)
Conclude:-
=======
**************************************************************************************************The Error message is very clear, while firing the Sqlwb.exe /setup the issue occurred
**************************************************************************************************
2) The error kept on coming and based on the Tools log we went ahead and tried to run the .MSI package directly from the Tools Setup
%Tools\Setup\SQLrun_tools.msi and this time also the setup failed and the pop ups were the same, we decided to do the following:
3) Run the setup from SQLrun_tools.msi and when the pop-up mentioned below comes up
Microsoft SQL Server 2005 Setup
---------------------------
There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.
---------------------------OK
***********************DONT CLICK OK***********************
4) Go to CMD prompt and then browse till the IDE folder in the Drive where you are installing {\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE} and tried to manually start Sqlwb.exe /Setup along with a Filemon on the background but it failed with a different value
{Filemon is important here}
0xc0000135
You can download a Filemon from sysinternals Site
5) Then we opened the File mon and saw the following which we collected
=========================================================
304 1:45:44 AM cmd.exe:5716 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe SUCCESS Attributes: A 306 1:45:44 AM cmd.exe:5716 DIRECTORY D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ SUCCESS FileBothDirectoryInformation: SqlWb.exe 308 1:45:44 AM cmd.exe:5716 OPEN D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe SUCCESS Options: Open Access: 001000A1 309 1:45:44 AM cmd.exe:5716 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe SUCCESS Attributes: A 310 1:45:44 AM cmd.exe:5716 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe SUCCESS Length: 819928 311 1:45:44 AM SqlWb.exe:5716 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe BUFFER OVERFLOW FileNameInformation 312 1:45:44 AM SqlWb.exe:5716 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe SUCCESS FileNameInformation 313 1:45:44 AM cmd.exe:5716 OPEN D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Manifest SUCCESS Options: Open Access: 001200A9 314 1:45:44 AM cmd.exe:5716 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Manifest SUCCESS Length: 1076 315 1:45:44 AM cmd.exe:5716 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Manifest SUCCESS Length: 1076 316 1:45:44 AM cmd.exe:5716 OPEN D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Config SUCCESS Options: Open Access: 001200A9 317 1:45:44 AM cmd.exe:5716 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Config SUCCESS Length: 337 318 1:45:44 AM cmd.exe:5716 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Config SUCCESS Length: 337 322 1:45:44 AM csrss.exe:1260 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Manifest SUCCESS Attributes: A 323 1:45:44 AM csrss.exe:1260 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Config SUCCESS Attributes: A 324 1:45:44 AM csrss.exe:1260 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Manifest SUCCESS Attributes: A 436 1:45:44 AM cmd.exe:5716 CLOSE D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Manifest SUCCESS 437 1:45:44 AM cmd.exe:5716 CLOSE D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Config SUCCESS 438 1:45:44 AM cmd.exe:5716 CLOSE D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe SUCCESS 439 1:45:44 AM SqlWb.exe:5452 OPEN D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE SUCCESS Options: Open Directory Access: 00100020 440 1:45:44 AM SqlWb.exe:5452 QUERY INFORMATION D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Local\ NOT FOUND Attributes: Error 441 1:45:44 AM SqlWb.exe:5452 QUERY INFORMATION C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474 SUCCESS Attributes: D 442 1:45:44 AM SqlWb.exe:5452 OPEN C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474 SUCCESS Options: Open Directory Access: 00100020 443 1:45:44 AM SqlWb.exe:5452 OPEN C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474\ATL80.DLL NOT FOUND Options: Open Access: 00100021 444 1:45:44 AM SqlWb.exe:5452 OPEN C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474\ATL80.DLL NOT FOUND Options: Open Access: 00100020 488 1:45:48 AM SqlWb.exe:5452 CLOSE C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474 SUCCESS 489 1:45:48 AM SqlWb.exe:5452 CLOSE D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE SUCCESS
Here is the problem
===================
443 1:45:44
AM SqlWb.exe:5452 OPEN C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474\ATL80.DLL NOT FOUND Options: Open Access: 00100021 444 1:45:44 AM SqlWb.exe:5452 OPEN C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474\ATL80.DLL NOT FOUND
4) The sqlwb needs this dll called ATL80.dll under WinSxS folder, looks like the DLL is not found
5) We Clicked on search and tried to find the DLL at customers end it gave the following location:
C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_6e805841
6)We then checked with the one where its unable to find the DLL
C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474\ATL80.DLL NOT FOUND
Cause
======
Here is the problem, the DLL when searched by sqlwb.exe is been searched at C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474
And when we got to this folder the ATL80.dll is not present
But the DLL is present at the following place: C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_6e805841
But this is not refrenced by SQlwb.exe and if you closely look the version is also different
Folder where the DLL is currently present is:
=============================================
Folder:C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_6e805841 and DLL version: 8.0.50727.42 DLL name ATL80.DLL
Folder looked when SQLwb runs is:
================================
Folder: C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474: and Dll version: 8.0.50727.762 DLL name ATL80.DLL
Checked in the Folder the folder is empty
We then went into another box and searched for the same version of DLL for ATL80.dll that is 8.0.50727.762
We got it from one different working box and we replaced the ATL80.dll from there to this
Problematic box in the following folder:
C:\WINDOWS\WinSxS\x86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_CBB27474
Things started to work after that..........
