Showing posts with label following. Show all posts
Showing posts with label following. Show all posts

Wednesday, March 28, 2012

install problems

My logs give the following:

Microsoft SQL Server 2005 Setup beginning at Sat Apr 07 19:09:17 2007
Process ID : 5896
g:\0c5b65e1ae1dee88a7a4639902\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2007/3/7 19:9:17
Complete: LoadResourcesAction at: 2007/3/7 19:9:17, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/7 19:9:17
Loaded DLL:g:\0c5b65e1ae1dee88a7a4639902\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/7 19:9:17, returned true
Running: ValidateWinNTAction at: 2007/3/7 19:9:17
Complete: ValidateWinNTAction at: 2007/3/7 19:9:17, returned true
Running: ValidateMinOSAction at: 2007/3/7 19:9:17
Complete: ValidateMinOSAction at: 2007/3/7 19:9:17, returned true
Running: PerformSCCAction at: 2007/3/7 19:9:17
Complete: PerformSCCAction at: 2007/3/7 19:9:17, returned true
Running: ActivateLoggingAction at: 2007/3/7 19:9:17
Complete: ActivateLoggingAction at: 2007/3/7 19:9:17, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5896" returned false.
Running: PerformSCCAction2 at: 2007/3/7 19:9:17
Loaded DLL:J:\WINDOWS\system32\msi.dll Version:3.1.4000.3959
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Notification Services CTP"
Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP"
Loaded DLL:J:\WINDOWS\system32\msi.dll Version:3.1.4000.3959
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

That is the core log;

When I type from the command line msiexec /x {E0A41F96-7231-4AE8-A654-EEB34F935462}

I get: am xmlrl error, fail to load xmlrl.dll, which I do not have in windows\system32

Please tell me how I can fix this problem?

Thank you

Dee

r u sure that there is no beta version of SQL SErver, visaul studio or .net framework on your machine. If exists , remove that and then install sql server

Madhu

|||

I removed all .net programs, sql, and even went through the registry. I even went through tin windows\installer and did some deletes.

I still keep getting the same message.

Dee

|||

Perhaps one of these articles will provide the clue you need. (You may wish to try the 'Clean Up Tool' first.)

Remove -Error message when you install SQL Server 2005: "Beta components detected"
http://support.microsoft.com/?kbid=919394

Remove -How do I remove previous versions of SQL Server 2005 / Whidbey?
http://www.aspfaq.com/sql2005/show.asp?id=15

Remove -How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/?kbid=290991

Remove -How to uninstall an instance of SQL Server 2005 manually
http://support.microsoft.com/?kbid=909967

Remove -How to Uninstall MSDE
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991

Remove -How to Uninstall SQL Server 2005 Beta
http://go.microsoft.com/?linkid=1396133

Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953

Remove -How to use the Add or Remove Programs item in Control Panel to add
or remove components for stand-alone installations and clustered
installations of SQL Server 2005 (KB: 922670)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;922670

Remove -How to: Uninstall SQL Server Express
http://msdn2.microsoft.com/en-us/library/ms143505.aspx

Remove -The error is: Fatal error during installation"
http://support.microsoft.com/?kbid=919945

Remove -Uninstall Applications NOT in Install/Remove Programs List
http://blogs.msdn.com/astebner/archive/2005/10/30/487096.aspx

Remove –Windows Installer Clean-Up Tool
http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe

|||

The log indicates that you have several pre-release products installed, specifically:

Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Notification Services CTP"
Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP"

These will all need to be removed prior to installing any RTM or post-RTM bits. Check for the Microsoft SQL Server 2005 entry in Add/Remove programs and remove it from there. If that does not exist, try removing the components manually using:

msiexec /x {product code}

Let us know how this turns out.

Mike

|||

As stated above I tried msiexec /x productcode as well as msiexec /uninstall and the name of the product. I keep getting an error regarding xmlrl.dll missing.

Dee

|||

I am still waiting for some help with this problem.

Thank you

Dee

|||

There are a few different solutions for removing SQL in this KB article, http://support.microsoft.com/default.aspx/kb/909967. See if this helps. Also, could you provide the exact text of the error you are getting when you attempt to run the msiexe /x command?

Mike

Addendum: I talked this over with the support team and they indicate that the KB article should solve you're problem, specifically the section about needing to install the setup support files that reads as below. One point to be warry of, you need to install SqlSupport.msi from the package that you originally installed the pre-release product from, hopefully you saved that.

?

Reinstall the Microsoft SQL Server Setup Support Files component (SqlSupport.msi) before you uninstall each component in the instance.

?

Temporarily refcount the SqlSupport.msi file to itself. To do this, follow these steps:

1.

Obtain the GUID for the Microsoft SQL Server Setup Support Files component. To obtain the GUID, follow steps 1 and 2 from the "If you experience problems" section.

2.

Use Registry Editor to create or to modify the following registry key with these values:

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Bootstrap\MSIRefCount
Value: Uninstall
Type: REG_SZ
Data: {11111111-1111-1111-1111-111111111111},{GUID}

Note GUID is a placeholder for the GUID of the SQL Server support files. For example, the GUID of the English x86 SQL Server support files is as follows:

Data: {11111111-1111-1111-1111-111111111111},{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}

|||

I did not keep the original software that I did the install with. I used the SQL Server 2005 CTP. I am trying to use something called ttools.exe and getting no where with it eithers.

So far I have removed everthing but

Microsoft SQL Server 2005 Setup beginning at Wed Apr 11 14:36:59 2007
Process ID : 5796
g:\1b28209325f0716aec0cbbe1\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/11 14:36:59
Complete: LoadResourcesAction at: 2007/3/11 14:36:59, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/11 14:36:59
Loaded DLL:g:\1b28209325f0716aec0cbbe1\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/11 14:36:59, returned true
Running: ValidateWinNTAction at: 2007/3/11 14:36:59
Complete: ValidateWinNTAction at: 2007/3/11 14:36:59, returned true
Running: ValidateMinOSAction at: 2007/3/11 14:36:59
Complete: ValidateMinOSAction at: 2007/3/11 14:36:59, returned true
Running: PerformSCCAction at: 2007/3/11 14:36:59
Complete: PerformSCCAction at: 2007/3/11 14:36:59, returned true
Running: ActivateLoggingAction at: 2007/3/11 14:36:59
Complete: ActivateLoggingAction at: 2007/3/11 14:36:59, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5796" returned false.
Running: PerformSCCAction2 at: 2007/3/11 14:36:59
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

I get the following when I try to use msiexec /x

This action is only valid for products currently installed.

Dee

|||

Is there any one out there who can help with this problem. I do not want to re-install Windows 2003 server and I need to take my courses.

Dee

|||

You may be in one of those situations where the effort to wipe the disk and start over is less than the cummulative time and effort required to solve the problem.

It's like a go/no go decision point upon application rollout. There has to be a point where management makes the rollback decision EVEN though the developers keep saying it will be just a couple more minutes. And then a couple more, etc.

|||

Don't want to re-install have too many programs and web sites on the system.

Dee

|||

I suggest then, that you review the list of resources I (and Michael) previously posted, and be extremely meticulous removal of all vestiges of the previous SQL Server 2005 and Visual Studio 2005 (including beta and CTP) products. Something is being missed...

And I agree, it 'should not' be so darn difficult. But in your situation, it seems that is the case, you have are chosing to live with it.

|||

I went through Michaels entire post most of the tools I have already, the rest I tried. Neither worked. But now I am getting:

Microsoft SQL Server 2005 Setup beginning at Thu Apr 12 11:22:16 2007
Process ID : 5976
g:\583d966eff02c53f4a\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/12 11:22:16
Complete: LoadResourcesAction at: 2007/3/12 11:22:16, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/12 11:22:16
Loaded DLL:g:\583d966eff02c53f4a\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/12 11:22:16, returned true
Running: ValidateWinNTAction at: 2007/3/12 11:22:16
Complete: ValidateWinNTAction at: 2007/3/12 11:22:16, returned true
Running: ValidateMinOSAction at: 2007/3/12 11:22:16
Complete: ValidateMinOSAction at: 2007/3/12 11:22:16, returned true
Running: PerformSCCAction at: 2007/3/12 11:22:16
Complete: PerformSCCAction at: 2007/3/12 11:22:16, returned true
Running: ActivateLoggingAction at: 2007/3/12 11:22:16
Complete: ActivateLoggingAction at: 2007/3/12 11:22:16, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5976" returned false.
Running: PerformSCCAction2 at: 2007/3/12 11:22:16
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

Dee

|||

Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"

You STILL have a beta/CTP product installed. It must be removed in order to reinstall SQL Server.

install problems

My logs give the following:

Microsoft SQL Server 2005 Setup beginning at Sat Apr 07 19:09:17 2007
Process ID : 5896
g:\0c5b65e1ae1dee88a7a4639902\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2007/3/7 19:9:17
Complete: LoadResourcesAction at: 2007/3/7 19:9:17, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/7 19:9:17
Loaded DLL:g:\0c5b65e1ae1dee88a7a4639902\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/7 19:9:17, returned true
Running: ValidateWinNTAction at: 2007/3/7 19:9:17
Complete: ValidateWinNTAction at: 2007/3/7 19:9:17, returned true
Running: ValidateMinOSAction at: 2007/3/7 19:9:17
Complete: ValidateMinOSAction at: 2007/3/7 19:9:17, returned true
Running: PerformSCCAction at: 2007/3/7 19:9:17
Complete: PerformSCCAction at: 2007/3/7 19:9:17, returned true
Running: ActivateLoggingAction at: 2007/3/7 19:9:17
Complete: ActivateLoggingAction at: 2007/3/7 19:9:17, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5896" returned false.
Running: PerformSCCAction2 at: 2007/3/7 19:9:17
Loaded DLL:J:\WINDOWS\system32\msi.dll Version:3.1.4000.3959
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Notification Services CTP"
Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP"
Loaded DLL:J:\WINDOWS\system32\msi.dll Version:3.1.4000.3959
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

That is the core log;

When I type from the command line msiexec /x {E0A41F96-7231-4AE8-A654-EEB34F935462}

I get: am xmlrl error, fail to load xmlrl.dll, which I do not have in windows\system32

Please tell me how I can fix this problem?

Thank you

Dee

r u sure that there is no beta version of SQL SErver, visaul studio or .net framework on your machine. If exists , remove that and then install sql server

Madhu

|||

I removed all .net programs, sql, and even went through the registry. I even went through tin windows\installer and did some deletes.

I still keep getting the same message.

Dee

|||

Perhaps one of these articles will provide the clue you need. (You may wish to try the 'Clean Up Tool' first.)

Remove -Error message when you install SQL Server 2005: "Beta components detected"
http://support.microsoft.com/?kbid=919394

Remove -How do I remove previous versions of SQL Server 2005 / Whidbey?
http://www.aspfaq.com/sql2005/show.asp?id=15

Remove -How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/?kbid=290991

Remove -How to uninstall an instance of SQL Server 2005 manually
http://support.microsoft.com/?kbid=909967

Remove -How to Uninstall MSDE
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991

Remove -How to Uninstall SQL Server 2005 Beta
http://go.microsoft.com/?linkid=1396133

Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953

Remove -How to use the Add or Remove Programs item in Control Panel to add
or remove components for stand-alone installations and clustered
installations of SQL Server 2005 (KB: 922670)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;922670

Remove -How to: Uninstall SQL Server Express
http://msdn2.microsoft.com/en-us/library/ms143505.aspx

Remove -The error is: Fatal error during installation"
http://support.microsoft.com/?kbid=919945

Remove -Uninstall Applications NOT in Install/Remove Programs List
http://blogs.msdn.com/astebner/archive/2005/10/30/487096.aspx

Remove –Windows Installer Clean-Up Tool
http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe

|||

The log indicates that you have several pre-release products installed, specifically:

Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Notification Services CTP"
Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP"

These will all need to be removed prior to installing any RTM or post-RTM bits. Check for the Microsoft SQL Server 2005 entry in Add/Remove programs and remove it from there. If that does not exist, try removing the components manually using:

msiexec /x {product code}

Let us know how this turns out.

Mike

|||

As stated above I tried msiexec /x productcode as well as msiexec /uninstall and the name of the product. I keep getting an error regarding xmlrl.dll missing.

Dee

|||

I am still waiting for some help with this problem.

Thank you

Dee

|||

There are a few different solutions for removing SQL in this KB article, http://support.microsoft.com/default.aspx/kb/909967. See if this helps. Also, could you provide the exact text of the error you are getting when you attempt to run the msiexe /x command?

Mike

Addendum: I talked this over with the support team and they indicate that the KB article should solve you're problem, specifically the section about needing to install the setup support files that reads as below. One point to be warry of, you need to install SqlSupport.msi from the package that you originally installed the pre-release product from, hopefully you saved that.

?

Reinstall the Microsoft SQL Server Setup Support Files component (SqlSupport.msi) before you uninstall each component in the instance.

?

Temporarily refcount the SqlSupport.msi file to itself. To do this, follow these steps:

1.

Obtain the GUID for the Microsoft SQL Server Setup Support Files component. To obtain the GUID, follow steps 1 and 2 from the "If you experience problems" section.

2.

Use Registry Editor to create or to modify the following registry key with these values:

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Bootstrap\MSIRefCount
Value: Uninstall
Type: REG_SZ
Data: {11111111-1111-1111-1111-111111111111},{GUID}

Note GUID is a placeholder for the GUID of the SQL Server support files. For example, the GUID of the English x86 SQL Server support files is as follows:

Data: {11111111-1111-1111-1111-111111111111},{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}

|||

I did not keep the original software that I did the install with. I used the SQL Server 2005 CTP. I am trying to use something called ttools.exe and getting no where with it eithers.

So far I have removed everthing but

Microsoft SQL Server 2005 Setup beginning at Wed Apr 11 14:36:59 2007
Process ID : 5796
g:\1b28209325f0716aec0cbbe1\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/11 14:36:59
Complete: LoadResourcesAction at: 2007/3/11 14:36:59, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/11 14:36:59
Loaded DLL:g:\1b28209325f0716aec0cbbe1\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/11 14:36:59, returned true
Running: ValidateWinNTAction at: 2007/3/11 14:36:59
Complete: ValidateWinNTAction at: 2007/3/11 14:36:59, returned true
Running: ValidateMinOSAction at: 2007/3/11 14:36:59
Complete: ValidateMinOSAction at: 2007/3/11 14:36:59, returned true
Running: PerformSCCAction at: 2007/3/11 14:36:59
Complete: PerformSCCAction at: 2007/3/11 14:36:59, returned true
Running: ActivateLoggingAction at: 2007/3/11 14:36:59
Complete: ActivateLoggingAction at: 2007/3/11 14:36:59, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5796" returned false.
Running: PerformSCCAction2 at: 2007/3/11 14:36:59
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

I get the following when I try to use msiexec /x

This action is only valid for products currently installed.

Dee

|||

Is there any one out there who can help with this problem. I do not want to re-install Windows 2003 server and I need to take my courses.

Dee

|||

You may be in one of those situations where the effort to wipe the disk and start over is less than the cummulative time and effort required to solve the problem.

It's like a go/no go decision point upon application rollout. There has to be a point where management makes the rollback decision EVEN though the developers keep saying it will be just a couple more minutes. And then a couple more, etc.

|||

Don't want to re-install have too many programs and web sites on the system.

Dee

|||

I suggest then, that you review the list of resources I (and Michael) previously posted, and be extremely meticulous removal of all vestiges of the previous SQL Server 2005 and Visual Studio 2005 (including beta and CTP) products. Something is being missed...

And I agree, it 'should not' be so darn difficult. But in your situation, it seems that is the case, you have are chosing to live with it.

|||

I went through Michaels entire post most of the tools I have already, the rest I tried. Neither worked. But now I am getting:

Microsoft SQL Server 2005 Setup beginning at Thu Apr 12 11:22:16 2007
Process ID : 5976
g:\583d966eff02c53f4a\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/12 11:22:16
Complete: LoadResourcesAction at: 2007/3/12 11:22:16, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/12 11:22:16
Loaded DLL:g:\583d966eff02c53f4a\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/12 11:22:16, returned true
Running: ValidateWinNTAction at: 2007/3/12 11:22:16
Complete: ValidateWinNTAction at: 2007/3/12 11:22:16, returned true
Running: ValidateMinOSAction at: 2007/3/12 11:22:16
Complete: ValidateMinOSAction at: 2007/3/12 11:22:16, returned true
Running: PerformSCCAction at: 2007/3/12 11:22:16
Complete: PerformSCCAction at: 2007/3/12 11:22:16, returned true
Running: ActivateLoggingAction at: 2007/3/12 11:22:16
Complete: ActivateLoggingAction at: 2007/3/12 11:22:16, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5976" returned false.
Running: PerformSCCAction2 at: 2007/3/12 11:22:16
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

Dee

|||

Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"

You STILL have a beta/CTP product installed. It must be removed in order to reinstall SQL Server.

sql

Monday, March 26, 2012

Install issue with Express w/ Advanced Services - AGTACCOUNT

I'm just running the install directly from the executable thats downloaded from the microsoft site and get the following warning which then causes the install to exit (gracefully).

Is this something that needs to be set before installing? I can't find any documentation on it.

Regards

Richard

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=28006&EvtType=sqlca%5csqlguica.cpp%40SetUnattendedSvcAccountProp%40SetUnattendedSvcAccountProp%40x6d66


BUTTONS:

OK

I'm going to move this to the Setup forum.

- Mike

|||

Hallo,

I got the same error yesterday, then i removed the old version of .net framework(i installed two version), after that the setup works again.

check if you also have beta or pre-release version of sql server, visual studio, or .net framwork installed on your machine.

anyway, this is quit a strange error message for me.

Good luck

|||

I just got the same error and i have not installed any beta version of any software I was trying to get new installation for my development server.

What do you recommend I uninstall what components of SQL or .NET framework?

Install issue with Express w/ Advanced Services - AGTACCOUNT

I'm just running the install directly from the executable thats downloaded from the microsoft site and get the following warning which then causes the install to exit (gracefully).

Is this something that needs to be set before installing? I can't find any documentation on it.

Regards

Richard

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=28006&EvtType=sqlca%5csqlguica.cpp%40SetUnattendedSvcAccountProp%40SetUnattendedSvcAccountProp%40x6d66


BUTTONS:

OK

I'm going to move this to the Setup forum.

- Mike

|||

Hallo,

I got the same error yesterday, then i removed the old version of .net framework(i installed two version), after that the setup works again.

check if you also have beta or pre-release version of sql server, visual studio, or .net framwork installed on your machine.

anyway, this is quit a strange error message for me.

Good luck

|||

I just got the same error and i have not installed any beta version of any software I was trying to get new installation for my development server.

What do you recommend I uninstall what components of SQL or .NET framework?

Install issue with Express w/ Advanced Services - AGTACCOUNT

I'm just running the install directly from the executable thats downloaded from the microsoft site and get the following warning which then causes the install to exit (gracefully).

Is this something that needs to be set before installing? I can't find any documentation on it.

Regards

Richard

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=28006&EvtType=sqlca%5csqlguica.cpp%40SetUnattendedSvcAccountProp%40SetUnattendedSvcAccountProp%40x6d66


BUTTONS:

OK

I'm going to move this to the Setup forum.

- Mike

|||

Hallo,

I got the same error yesterday, then i removed the old version of .net framework(i installed two version), after that the setup works again.

check if you also have beta or pre-release version of sql server, visual studio, or .net framwork installed on your machine.

anyway, this is quit a strange error message for me.

Good luck

|||

I just got the same error and i have not installed any beta version of any software I was trying to get new installation for my development server.

What do you recommend I uninstall what components of SQL or .NET framework?

Friday, March 23, 2012

Install issue with Express w/ Advanced Services - AGTACCOUNT

I'm just running the install directly from the executable thats downloaded from the microsoft site and get the following warning which then causes the install to exit (gracefully).

Is this something that needs to be set before installing? I can't find any documentation on it.

Regards

Richard

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=28006&EvtType=sqlca%5csqlguica.cpp%40SetUnattendedSvcAccountProp%40SetUnattendedSvcAccountProp%40x6d66


BUTTONS:

OK

I'm going to move this to the Setup forum.

- Mike

|||

Hallo,

I got the same error yesterday, then i removed the old version of .net framework(i installed two version), after that the setup works again.

check if you also have beta or pre-release version of sql server, visual studio, or .net framwork installed on your machine.

anyway, this is quit a strange error message for me.

Good luck

|||

I just got the same error and i have not installed any beta version of any software I was trying to get new installation for my development server.

What do you recommend I uninstall what components of SQL or .NET framework?

|||Hi

Im posting this here as its seems to be a common problem that knowbody is answering.

When installing SQL Server Express 2005 from the downloaded file NOT from the command line an error reguarding the agtaccount appears.

This usually happens if the install directories exist on the hard disk from other versions of SQL server.

i.e. The install directories have been copied to the hard disk from the cd/dvd rather than installing off the cd.

also any temp directories created by other SQL installation usually off root a long string of chars and numbers.

i.e. c:\f654e6a76ed87b6df65s

anything like the above must be deleted before the Express edition is installed.

Somehow the Express installation is getting mixed up with install files from other versions.

Hope this helps

William Humphreys

quickcode@.technical-solutions.co.uksql

Install errror in SQLServer 2005 SP1

I have a error instaling SP1 for SQLServer 2005 Standard Edition Spanish.

The log is the following:

.....

Doing Action: SetInstanceProperty
PerfTime Start: SetInstanceProperty : Wed Apr 26 16:02:31 2006
<Func Name='SetInstanceProperty'>
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlOriginalMachineName property. Its value is 'WS03'.
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlLegacyRegPath property. Its value is 'MSSQLServer'.
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding PreviousInstId property. Its value is 'MSSQL.1'.
Using instanced id: MSSQL.1
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding InstId property. Its value is 'MSSQL.1'.
Previous instance id: MSSQL.1
Using instance name: MSSQLSERVER
MSI (s) (48!D0) [16:02:31:890]: PROPERTY CHANGE: Adding PrevRegRootPath property. Its value is 'Software\Microsoft\Microsoft SQL Server\MSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding Sql2KSxS property. Its value is '1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceName.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'MSSQLSERVER'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixRS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005ReportServerUser$WS03$'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixSSIS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005DTSUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'SQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'RIEDER\SQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceRegKey.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'Microsoft SQL Server\MSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding DataInstanceTxt.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'C:\Archivos de programa\Microsoft SQL Server\MSSQL.1\MSSQL'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceNameSQL.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'MSSQLSERVER'.
Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No se ha efectuado ninguna asignación entre los nombres de cuenta y los identificadores de seguridad.
Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Mon Feb 27 02:04:14 2006
Function Name: SetInstanceProperty
Source Line Number: 1223

MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 1332
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Producto: Microsoft SQL Server 2005 -- Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.

Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.
<Failure Type='Fatal' Error='1332'>
<EndFunc Name='LaunchFunction' Return='1332' GetLastError='0'>
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
La acción terminó a las 16:02:31: SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Valor devuelto: 3.
La acción terminó a las 16:02:31: INSTALL. Valor devuelto: 3.
Property(S): ProductCode = {FD515EB7-E1C3-4278-9EC2-047672A8B718}
Property(S): ProductLanguage = 3082
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 9.1.2047.00
Property(S): MEDIAPACKAGEPATH = \Setup\
Property(S): ALLUSERS = 1
Property(S): NULLGUID = {00000000-0000-0000-0000-000000000000}
Property(S): ASPNetVersion = 2.0.50727
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52152
Property(S): ARPPRODUCTICON = ARPIcon.ico
Property(S): ARPNOREPAIR = 1
Property(S): ARPSYSTEMCOMPONENT = 1
Property(S): MsiHiddenProperties = SQLPASSWORD;AGTPASSWORD;ASPASSWORD;RSPASSWORD;SQLBROWSERPASSWORD;RSSQLPASSWORD;RSSQLPassword;RSSQLPasswordQuoted;RSSETUPPASSWORD;RSSetupPassword;SAPWD;saPWD;UPGRADEPWD;SqlUpgradePwd;SQLPassword;ServicePassword;ADMINPASSWORD;PIDKEY;FTEPassword.68C6D15C_77E0_11D5_8528_00C04F68155C;checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C;checksum.;DigitalProductID;DPID;Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2;Rollback_SqlConnection.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_XmlSingleNode.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_RSSetting.D20239D7_E87C_40C9_9837_E70B8D4882C2;PID;ProductID;RSUPGRADEPASSWORD;Do_RSSetSharePointExclusionPath.D20239D7_E87C_40C9_9837_E70B8D4882C2
Property(S): SecureCustomProperties = SQL_SHOWLIC;UPGRADESQL90
Property(S): SqlServerBuild = 1
Property(S): SqlCluster = 0
Property(S): INSTALLLEVEL = 90
Property(S): FXAssemblyVersion = 2.0.0.0
Property(S): VSAssemblyVersion = 8.0.0.0
Property(S): SqlErrorReporting = #0
Property(S): SqlSqmReporting = #0
Property(S): SqlEnableRanu = 0
Property(S): SqlPatchLevel = 9.1.2047
Property(S): ChannelID = 271
Property(S): PIDTemplate = 77656<````=````=````=````=`````>@.@.@.@.@.
Property(S): mpc = 77656
Property(S): OEMRelease = 0
Property(S): PIDKEY = **********
Property(S): ProgramFilesFolder = C:\Archivos de programa\
Property(S): ProductID = **********
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlClusterSec = 0
Property(S): MDACSXS = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): VersionNT = 502
Property(S): LocalSystemAccount = NT AUTHORITY\SYSTEM
Property(S): DefaultBuiltInAccount = LocalSystemAccount

.....

Thks

Emilio, unfortunately this is a known issue. Here is a snippet from a log I posted previously (from an English log).

The log post reads:

Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No mapping between account names and security IDs was done.

We are currently investigating this issue, but my guess is that after RTM, someone deleted the user groups that were created during install. SQL setup creates several user groups that are used during setup. It appears that SP1 is also looking to use these and they no longer exist. The user groups are named in this fashion: SQLServer2005MSSQLUser$<MachineName>$<InstanceName>

We are still looking into it and hope to have a solution soon.

Thanks,
Samuel Lester (MSFT)

|||

Is a solution to this available?

Regards,
Eric Lapham

|||

SQL server uses local group for ACLs. When the server is installed the groups are created and their SIDs are stored in the registry. Somewhere along the way, the SID had to change and the SIDs in the registry were not valid anymore. Try to delete the values for the following values in Setup registry key the instance hive [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup]

The registry values are:

AGTGroup

SQLGroup

FTSGroup

ASGroup

Thanks,
Samuel Lester (MSFT)

|||

i deleted the registry value for AGTGroup, SQLGroupF, TSGroup and ASGroup and the setup ended now correct for all product.

Thanks for the help.

Regards,

Emilio

|||

Thank you; SP1 is installed. I found ASGroup in

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup]

The fours keys appeared to be recreated by the install of SP1. Regards, Eric Lapham

|||Correct, I should have mentioned that as well. These keys will get recreated correctly during the following SP1 install. Glad to hear it works for you!

Samuel Lester (MSFT)|||

Samuel, I am getting ready to install SP1. Would you recommend deleting these values prior to any attempt to install SP1

Regards,
Jon

|||

Nope, no need to do this. This error only occurs if someone has explicitly deleted user groups after installing RTM. We haven't seen much of this happening, but in case it has, this is how to clean it up.

Go ahead and install SP1.

Thanks,
Sam

|||

Hello Samuel,

I experienced the same problem when installing SQL 2005 SP2.

I removed the registry values as you suggested; but I still got the failures.

Here are the partial logs :

Configuring ACL for WMI namespace \\.\root\Microsoft\SqlServer\ComputerManagement
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)
<Func Name='SecureWMINamespace'>
No need to protect the namespace security
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Tue Jun 05 16:38:04 2007
MSI (s) (48:0C) [16:38:04:855]: Executing op: ActionStart(Name=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (48:0C) [16:38:04:855]: Executing op: CustomActionSchedule(Action=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=AddCertificate,CustomActionData=c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\)
MSI (s) (48:CC) [16:38:04:875]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI596.tmp, Entrypoint: AddCertificate
FTECa.DLL: INFO: FTE: AddCertificate(), Entering...
FTECa.DLL: INFO: FTE: AddCertificate: CustomActionData: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\
MSI (s) (48:0C) [16:38:05:416]: Executing op: ActionStart(Name=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: AddCertificate: Succeeded. Added Certificate from c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\msfte.dll
MSI (s) (48:0C) [16:38:05:416]: Executing op: CustomActionSchedule(Action=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=InstallPerfCounters,CustomActionData=c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\Smile
MSI (s) (48Big SmileC) [16:38:05:436]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI597.tmp, Entrypoint: InstallPerfCounters
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Entering...
FTECa.DLL: INFO: InstallPerfCounters: CustomActionData: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\:
FTECa.DLL: INFO: InstallPerfCounters: Instance name obtained:
FTECa.DLL: INFO: InstallPerfCounters: Instance home path: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\
FTECa.DLL: INFO: Setting acls on c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\msfte.dll
FTECa.DLL: Warning: Failed to get BuiltinPerfMonitoringUsersSid win32error 87, this is only expected to work on w2k3+ systems
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\fdcntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ifdcntrs.ini, msftesqlFD -> msftesqlFD, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ftecntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iftcntrs.ini, msftesql -> msftesql, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\idxcntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iindctrs.ini, msftesqlidx -> msftesqlidx, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ifdcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iftcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iindctrs.ini have been installed.
MSI (s) (48:0C) [16:38:06:127]: Executing op: ActionStart(Name=CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Exiting...
MSI (s) (48:0C) [16:38:06:127]: Executing op: CustomActionSchedule(Action=CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1025,Source=BinaryData,Target=RemoveFTEServiceDependency,CustomActionData=msftesql)
MSI (s) (48:34) [16:38:06:147]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI598.tmp, Entrypoint: RemoveFTEServiceDependency
FTECa.DLL: INFO: FTE: Enter RemoveFTEServiceDependency()
FTECa.DLL: INFO: FTE: RemoveFTEServiceDependency: Service name obtained: msftesql
MSI (s) (48:0C) [16:38:07:008]: Executing op: ActionStart(Name=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: Exit RemoveFTEServiceDependency()
MSI (s) (48:0C) [16:38:07:018]: Executing op: CustomActionSchedule(Action=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=SetLaunchPermissions,CustomActionData={68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITY\SYSTEM)
MSI (s) (48:8C) [16:38:07:038]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI599.tmp, Entrypoint: SetLaunchPermissions
MSI (s) (48:0C) [16:38:07:228]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
MSI (s) (48:0C) [16:38:07:238]: Executing op: ProgressTotal(Total=6,Type=1,ByteEquivalent=1300000)
MSI (s) (48:0C) [16:38:07:238]: Executing op: ServiceControl(,Name=SQLWriter,Action=1,Wait=0,)
MSI (s) (48:0C) [16:38:37:277]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:277]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:397]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:498]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:498]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:528]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Product: Microsoft SQL Server 2005 -- Error 1920. Service 'SQLWriter' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.

Error 1920. Service 'SQLWriter' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.
MSI (s) (48:0C) [16:38:37:568]: User policy value 'DisableRollback' is 0
MSI (s) (48:0C) [16:38:37:568]: Machine policy value 'DisableRollback' is 0
Action ended 16:38:37: InstallFinalize. Return value 3.

Any suggestion are much appreciated

Thanks

David Chan

Install errror in SQLServer 2005 SP1

I have a error instaling SP1 for SQLServer 2005 Standard Edition Spanish.

The log is the following:

.....

Doing Action: SetInstanceProperty
PerfTime Start: SetInstanceProperty : Wed Apr 26 16:02:31 2006
<Func Name='SetInstanceProperty'>
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlOriginalMachineName property. Its value is 'WS03'.
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlLegacyRegPath property. Its value is 'MSSQLServer'.
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding PreviousInstId property. Its value is 'MSSQL.1'.
Using instanced id: MSSQL.1
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding InstId property. Its value is 'MSSQL.1'.
Previous instance id: MSSQL.1
Using instance name: MSSQLSERVER
MSI (s) (48!D0) [16:02:31:890]: PROPERTY CHANGE: Adding PrevRegRootPath property. Its value is 'Software\Microsoft\Microsoft SQL Server\MSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding Sql2KSxS property. Its value is '1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceName.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'MSSQLSERVER'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixRS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005ReportServerUser$WS03$'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixSSIS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005DTSUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'SQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'RIEDER\SQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceRegKey.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'Microsoft SQL Server\MSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding DataInstanceTxt.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'C:\Archivos de programa\Microsoft SQL Server\MSSQL.1\MSSQL'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceNameSQL.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'MSSQLSERVER'.
Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No se ha efectuado ninguna asignación entre los nombres de cuenta y los identificadores de seguridad.
Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Mon Feb 27 02:04:14 2006
Function Name: SetInstanceProperty
Source Line Number: 1223

MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 1332
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Producto: Microsoft SQL Server 2005 -- Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.

Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.
<Failure Type='Fatal' Error='1332'>
<EndFunc Name='LaunchFunction' Return='1332' GetLastError='0'>
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
La acción terminó a las 16:02:31: SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Valor devuelto: 3.
La acción terminó a las 16:02:31: INSTALL. Valor devuelto: 3.
Property(S): ProductCode = {FD515EB7-E1C3-4278-9EC2-047672A8B718}
Property(S): ProductLanguage = 3082
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 9.1.2047.00
Property(S): MEDIAPACKAGEPATH = \Setup\
Property(S): ALLUSERS = 1
Property(S): NULLGUID = {00000000-0000-0000-0000-000000000000}
Property(S): ASPNetVersion = 2.0.50727
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52152
Property(S): ARPPRODUCTICON = ARPIcon.ico
Property(S): ARPNOREPAIR = 1
Property(S): ARPSYSTEMCOMPONENT = 1
Property(S): MsiHiddenProperties = SQLPASSWORD;AGTPASSWORD;ASPASSWORD;RSPASSWORD;SQLBROWSERPASSWORD;RSSQLPASSWORD;RSSQLPassword;RSSQLPasswordQuoted;RSSETUPPASSWORD;RSSetupPassword;SAPWD;saPWD;UPGRADEPWD;SqlUpgradePwd;SQLPassword;ServicePassword;ADMINPASSWORD;PIDKEY;FTEPassword.68C6D15C_77E0_11D5_8528_00C04F68155C;checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C;checksum.;DigitalProductID;DPID;Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2;Rollback_SqlConnection.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_XmlSingleNode.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_RSSetting.D20239D7_E87C_40C9_9837_E70B8D4882C2;PID;ProductID;RSUPGRADEPASSWORD;Do_RSSetSharePointExclusionPath.D20239D7_E87C_40C9_9837_E70B8D4882C2
Property(S): SecureCustomProperties = SQL_SHOWLIC;UPGRADESQL90
Property(S): SqlServerBuild = 1
Property(S): SqlCluster = 0
Property(S): INSTALLLEVEL = 90
Property(S): FXAssemblyVersion = 2.0.0.0
Property(S): VSAssemblyVersion = 8.0.0.0
Property(S): SqlErrorReporting = #0
Property(S): SqlSqmReporting = #0
Property(S): SqlEnableRanu = 0
Property(S): SqlPatchLevel = 9.1.2047
Property(S): ChannelID = 271
Property(S): PIDTemplate = 77656<````=````=````=````=`````>@.@.@.@.@.
Property(S): mpc = 77656
Property(S): OEMRelease = 0
Property(S): PIDKEY = **********
Property(S): ProgramFilesFolder = C:\Archivos de programa\
Property(S): ProductID = **********
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlClusterSec = 0
Property(S): MDACSXS = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): VersionNT = 502
Property(S): LocalSystemAccount = NT AUTHORITY\SYSTEM
Property(S): DefaultBuiltInAccount = LocalSystemAccount

.....

Thks

Emilio, unfortunately this is a known issue. Here is a snippet from a log I posted previously (from an English log).

The log post reads:

Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No mapping between account names and security IDs was done.

We are currently investigating this issue, but my guess is that after RTM, someone deleted the user groups that were created during install. SQL setup creates several user groups that are used during setup. It appears that SP1 is also looking to use these and they no longer exist. The user groups are named in this fashion: SQLServer2005MSSQLUser$<MachineName>$<InstanceName>

We are still looking into it and hope to have a solution soon.

Thanks,
Samuel Lester (MSFT)

|||

Is a solution to this available?

Regards,
Eric Lapham

|||

SQL server uses local group for ACLs. When the server is installed the groups are created and their SIDs are stored in the registry. Somewhere along the way, the SID had to change and the SIDs in the registry were not valid anymore. Try to delete the values for the following values in Setup registry key the instance hive [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup]

The registry values are:

AGTGroup

SQLGroup

FTSGroup

ASGroup

Thanks,
Samuel Lester (MSFT)

|||

i deleted the registry value for AGTGroup, SQLGroupF, TSGroup and ASGroup and the setup ended now correct for all product.

Thanks for the help.

Regards,

Emilio

|||

Thank you; SP1 is installed. I found ASGroup in

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup]

The fours keys appeared to be recreated by the install of SP1. Regards, Eric Lapham

|||Correct, I should have mentioned that as well. These keys will get recreated correctly during the following SP1 install. Glad to hear it works for you!

Samuel Lester (MSFT)|||

Samuel, I am getting ready to install SP1. Would you recommend deleting these values prior to any attempt to install SP1

Regards,
Jon

|||

Nope, no need to do this. This error only occurs if someone has explicitly deleted user groups after installing RTM. We haven't seen much of this happening, but in case it has, this is how to clean it up.

Go ahead and install SP1.

Thanks,
Sam

|||

Hello Samuel,

I experienced the same problem when installing SQL 2005 SP2.

I removed the registry values as you suggested; but I still got the failures.

Here are the partial logs :

Configuring ACL for WMI namespace \\.\root\Microsoft\SqlServer\ComputerManagement
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)
<Func Name='SecureWMINamespace'>
No need to protect the namespace security
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Tue Jun 05 16:38:04 2007
MSI (s) (48:0C) [16:38:04:855]: Executing op: ActionStart(Name=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (48:0C) [16:38:04:855]: Executing op: CustomActionSchedule(Action=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=AddCertificate,CustomActionData=c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\)
MSI (s) (48:CC) [16:38:04:875]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI596.tmp, Entrypoint: AddCertificate
FTECa.DLL: INFO: FTE: AddCertificate(), Entering...
FTECa.DLL: INFO: FTE: AddCertificate: CustomActionData: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\
MSI (s) (48:0C) [16:38:05:416]: Executing op: ActionStart(Name=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: AddCertificate: Succeeded. Added Certificate from c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\msfte.dll
MSI (s) (48:0C) [16:38:05:416]: Executing op: CustomActionSchedule(Action=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=InstallPerfCounters,CustomActionData=c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\Smile
MSI (s) (48Big SmileC) [16:38:05:436]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI597.tmp, Entrypoint: InstallPerfCounters
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Entering...
FTECa.DLL: INFO: InstallPerfCounters: CustomActionData: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\:
FTECa.DLL: INFO: InstallPerfCounters: Instance name obtained:
FTECa.DLL: INFO: InstallPerfCounters: Instance home path: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\
FTECa.DLL: INFO: Setting acls on c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\msfte.dll
FTECa.DLL: Warning: Failed to get BuiltinPerfMonitoringUsersSid win32error 87, this is only expected to work on w2k3+ systems
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\fdcntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ifdcntrs.ini, msftesqlFD -> msftesqlFD, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ftecntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iftcntrs.ini, msftesql -> msftesql, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\idxcntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iindctrs.ini, msftesqlidx -> msftesqlidx, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ifdcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iftcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iindctrs.ini have been installed.
MSI (s) (48:0C) [16:38:06:127]: Executing op: ActionStart(Name=CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Exiting...
MSI (s) (48:0C) [16:38:06:127]: Executing op: CustomActionSchedule(Action=CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1025,Source=BinaryData,Target=RemoveFTEServiceDependency,CustomActionData=msftesql)
MSI (s) (48:34) [16:38:06:147]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI598.tmp, Entrypoint: RemoveFTEServiceDependency
FTECa.DLL: INFO: FTE: Enter RemoveFTEServiceDependency()
FTECa.DLL: INFO: FTE: RemoveFTEServiceDependency: Service name obtained: msftesql
MSI (s) (48:0C) [16:38:07:008]: Executing op: ActionStart(Name=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: Exit RemoveFTEServiceDependency()
MSI (s) (48:0C) [16:38:07:018]: Executing op: CustomActionSchedule(Action=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=SetLaunchPermissions,CustomActionData={68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITY\SYSTEM)
MSI (s) (48:8C) [16:38:07:038]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI599.tmp, Entrypoint: SetLaunchPermissions
MSI (s) (48:0C) [16:38:07:228]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
MSI (s) (48:0C) [16:38:07:238]: Executing op: ProgressTotal(Total=6,Type=1,ByteEquivalent=1300000)
MSI (s) (48:0C) [16:38:07:238]: Executing op: ServiceControl(,Name=SQLWriter,Action=1,Wait=0,)
MSI (s) (48:0C) [16:38:37:277]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:277]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:397]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:498]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:498]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:528]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Product: Microsoft SQL Server 2005 -- Error 1920. Service 'SQLWriter' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.

Error 1920. Service 'SQLWriter' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.
MSI (s) (48:0C) [16:38:37:568]: User policy value 'DisableRollback' is 0
MSI (s) (48:0C) [16:38:37:568]: Machine policy value 'DisableRollback' is 0
Action ended 16:38:37: InstallFinalize. Return value 3.

Any suggestion are much appreciated

Thanks

David Chan

Install errror in SQLServer 2005 SP1

I have a error instaling SP1 for SQLServer 2005 Standard Edition Spanish.

The log is the following:

.....

Doing Action: SetInstanceProperty
PerfTime Start: SetInstanceProperty : Wed Apr 26 16:02:31 2006
<Func Name='SetInstanceProperty'>
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlOriginalMachineName property. Its value is 'WS03'.
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlLegacyRegPath property. Its value is 'MSSQLServer'.
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding PreviousInstId property. Its value is 'MSSQL.1'.
Using instanced id: MSSQL.1
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding InstId property. Its value is 'MSSQL.1'.
Previous instance id: MSSQL.1
Using instance name: MSSQLSERVER
MSI (s) (48!D0) [16:02:31:890]: PROPERTY CHANGE: Adding PrevRegRootPath property. Its value is 'Software\Microsoft\Microsoft SQL Server\MSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding Sql2KSxS property. Its value is '1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceName.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'MSSQLSERVER'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixRS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005ReportServerUser$WS03$'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixSSIS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005DTSUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'SQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'RIEDER\SQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceRegKey.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'Microsoft SQL Server\MSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding DataInstanceTxt.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'C:\Archivos de programa\Microsoft SQL Server\MSSQL.1\MSSQL'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceNameSQL.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'MSSQLSERVER'.
Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No se ha efectuado ninguna asignación entre los nombres de cuenta y los identificadores de seguridad.
Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Mon Feb 27 02:04:14 2006
Function Name: SetInstanceProperty
Source Line Number: 1223

MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 1332
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Producto: Microsoft SQL Server 2005 -- Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.

Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.
<Failure Type='Fatal' Error='1332'>
<EndFunc Name='LaunchFunction' Return='1332' GetLastError='0'>
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
La acción terminó a las 16:02:31: SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Valor devuelto: 3.
La acción terminó a las 16:02:31: INSTALL. Valor devuelto: 3.
Property(S): ProductCode = {FD515EB7-E1C3-4278-9EC2-047672A8B718}
Property(S): ProductLanguage = 3082
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 9.1.2047.00
Property(S): MEDIAPACKAGEPATH = \Setup\
Property(S): ALLUSERS = 1
Property(S): NULLGUID = {00000000-0000-0000-0000-000000000000}
Property(S): ASPNetVersion = 2.0.50727
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52152
Property(S): ARPPRODUCTICON = ARPIcon.ico
Property(S): ARPNOREPAIR = 1
Property(S): ARPSYSTEMCOMPONENT = 1
Property(S): MsiHiddenProperties = SQLPASSWORD;AGTPASSWORD;ASPASSWORD;RSPASSWORD;SQLBROWSERPASSWORD;RSSQLPASSWORD;RSSQLPassword;RSSQLPasswordQuoted;RSSETUPPASSWORD;RSSetupPassword;SAPWD;saPWD;UPGRADEPWD;SqlUpgradePwd;SQLPassword;ServicePassword;ADMINPASSWORD;PIDKEY;FTEPassword.68C6D15C_77E0_11D5_8528_00C04F68155C;checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C;checksum.;DigitalProductID;DPID;Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2;Rollback_SqlConnection.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_XmlSingleNode.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_RSSetting.D20239D7_E87C_40C9_9837_E70B8D4882C2;PID;ProductID;RSUPGRADEPASSWORD;Do_RSSetSharePointExclusionPath.D20239D7_E87C_40C9_9837_E70B8D4882C2
Property(S): SecureCustomProperties = SQL_SHOWLIC;UPGRADESQL90
Property(S): SqlServerBuild = 1
Property(S): SqlCluster = 0
Property(S): INSTALLLEVEL = 90
Property(S): FXAssemblyVersion = 2.0.0.0
Property(S): VSAssemblyVersion = 8.0.0.0
Property(S): SqlErrorReporting = #0
Property(S): SqlSqmReporting = #0
Property(S): SqlEnableRanu = 0
Property(S): SqlPatchLevel = 9.1.2047
Property(S): ChannelID = 271
Property(S): PIDTemplate = 77656<````=````=````=````=`````>@.@.@.@.@.
Property(S): mpc = 77656
Property(S): OEMRelease = 0
Property(S): PIDKEY = **********
Property(S): ProgramFilesFolder = C:\Archivos de programa\
Property(S): ProductID = **********
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlClusterSec = 0
Property(S): MDACSXS = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): VersionNT = 502
Property(S): LocalSystemAccount = NT AUTHORITY\SYSTEM
Property(S): DefaultBuiltInAccount = LocalSystemAccount

.....

Thks

Emilio, unfortunately this is a known issue. Here is a snippet from a log I posted previously (from an English log).

The log post reads:

Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No mapping between account names and security IDs was done.

We are currently investigating this issue, but my guess is that after RTM, someone deleted the user groups that were created during install. SQL setup creates several user groups that are used during setup. It appears that SP1 is also looking to use these and they no longer exist. The user groups are named in this fashion: SQLServer2005MSSQLUser$<MachineName>$<InstanceName>

We are still looking into it and hope to have a solution soon.

Thanks,
Samuel Lester (MSFT)

|||

Is a solution to this available?

Regards,
Eric Lapham

|||

SQL server uses local group for ACLs. When the server is installed the groups are created and their SIDs are stored in the registry. Somewhere along the way, the SID had to change and the SIDs in the registry were not valid anymore. Try to delete the values for the following values in Setup registry key the instance hive [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup]

The registry values are:

AGTGroup

SQLGroup

FTSGroup

ASGroup

Thanks,
Samuel Lester (MSFT)

|||

i deleted the registry value for AGTGroup, SQLGroupF, TSGroup and ASGroup and the setup ended now correct for all product.

Thanks for the help.

Regards,

Emilio

|||

Thank you; SP1 is installed. I found ASGroup in

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup]

The fours keys appeared to be recreated by the install of SP1. Regards, Eric Lapham

|||Correct, I should have mentioned that as well. These keys will get recreated correctly during the following SP1 install. Glad to hear it works for you!

Samuel Lester (MSFT)|||

Samuel, I am getting ready to install SP1. Would you recommend deleting these values prior to any attempt to install SP1

Regards,
Jon

|||

Nope, no need to do this. This error only occurs if someone has explicitly deleted user groups after installing RTM. We haven't seen much of this happening, but in case it has, this is how to clean it up.

Go ahead and install SP1.

Thanks,
Sam

|||

Hello Samuel,

I experienced the same problem when installing SQL 2005 SP2.

I removed the registry values as you suggested; but I still got the failures.

Here are the partial logs :

Configuring ACL for WMI namespace \\.\root\Microsoft\SqlServer\ComputerManagement
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)
<Func Name='SecureWMINamespace'>
No need to protect the namespace security
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Tue Jun 05 16:38:04 2007
MSI (s) (48:0C) [16:38:04:855]: Executing op: ActionStart(Name=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (48:0C) [16:38:04:855]: Executing op: CustomActionSchedule(Action=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=AddCertificate,CustomActionData=c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\)
MSI (s) (48:CC) [16:38:04:875]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI596.tmp, Entrypoint: AddCertificate
FTECa.DLL: INFO: FTE: AddCertificate(), Entering...
FTECa.DLL: INFO: FTE: AddCertificate: CustomActionData: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\
MSI (s) (48:0C) [16:38:05:416]: Executing op: ActionStart(Name=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: AddCertificate: Succeeded. Added Certificate from c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\msfte.dll
MSI (s) (48:0C) [16:38:05:416]: Executing op: CustomActionSchedule(Action=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=InstallPerfCounters,CustomActionData=c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\Smile
MSI (s) (48Big SmileC) [16:38:05:436]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI597.tmp, Entrypoint: InstallPerfCounters
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Entering...
FTECa.DLL: INFO: InstallPerfCounters: CustomActionData: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\:
FTECa.DLL: INFO: InstallPerfCounters: Instance name obtained:
FTECa.DLL: INFO: InstallPerfCounters: Instance home path: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\
FTECa.DLL: INFO: Setting acls on c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\msfte.dll
FTECa.DLL: Warning: Failed to get BuiltinPerfMonitoringUsersSid win32error 87, this is only expected to work on w2k3+ systems
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\fdcntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ifdcntrs.ini, msftesqlFD -> msftesqlFD, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ftecntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iftcntrs.ini, msftesql -> msftesql, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\idxcntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iindctrs.ini, msftesqlidx -> msftesqlidx, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ifdcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iftcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iindctrs.ini have been installed.
MSI (s) (48:0C) [16:38:06:127]: Executing op: ActionStart(Name=CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Exiting...
MSI (s) (48:0C) [16:38:06:127]: Executing op: CustomActionSchedule(Action=CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1025,Source=BinaryData,Target=RemoveFTEServiceDependency,CustomActionData=msftesql)
MSI (s) (48:34) [16:38:06:147]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI598.tmp, Entrypoint: RemoveFTEServiceDependency
FTECa.DLL: INFO: FTE: Enter RemoveFTEServiceDependency()
FTECa.DLL: INFO: FTE: RemoveFTEServiceDependency: Service name obtained: msftesql
MSI (s) (48:0C) [16:38:07:008]: Executing op: ActionStart(Name=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: Exit RemoveFTEServiceDependency()
MSI (s) (48:0C) [16:38:07:018]: Executing op: CustomActionSchedule(Action=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=SetLaunchPermissions,CustomActionData={68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITY\SYSTEM)
MSI (s) (48:8C) [16:38:07:038]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI599.tmp, Entrypoint: SetLaunchPermissions
MSI (s) (48:0C) [16:38:07:228]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
MSI (s) (48:0C) [16:38:07:238]: Executing op: ProgressTotal(Total=6,Type=1,ByteEquivalent=1300000)
MSI (s) (48:0C) [16:38:07:238]: Executing op: ServiceControl(,Name=SQLWriter,Action=1,Wait=0,)
MSI (s) (48:0C) [16:38:37:277]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:277]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:397]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:498]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:498]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:528]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Product: Microsoft SQL Server 2005 -- Error 1920. Service 'SQLWriter' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.

Error 1920. Service 'SQLWriter' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.
MSI (s) (48:0C) [16:38:37:568]: User policy value 'DisableRollback' is 0
MSI (s) (48:0C) [16:38:37:568]: Machine policy value 'DisableRollback' is 0
Action ended 16:38:37: InstallFinalize. Return value 3.

Any suggestion are much appreciated

Thanks

David Chan

sql