Hi,

You should check the logs with the exact error: i.e C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB955706_sqlncli.msi.log and so on.

It looks like you have missing or corrupted files in the C:\windows\installer...

Hi,

If you have installed Integration Services on the server, you can connect to the instance and export them and the import them in the other server.

Regards.

Jose Santiago Oyervides.

Hi,

I would just install SQL on the Passive Node (without remove) and install the second instance, with no problems.

I have it that way in my cluster, and I am also...

Hi,

You can't map a group login in any linked server.

Regards.

José Santiago Oyervides.

What is the security configuration on the linked server? May be the user does not have permissions and you have it with the default option and the account can't...

In my case, the update was offered via Microsoft Update, even though I don't use RS in any server.

Before this patch, I had SP3+CU1 installed in all my servers.

I installed...

Hi,

I while back wrote an script in Powershell to that:

Permissions:

http://practicascomunes.blogspot.com/2008/08/mas-scripts-de-smo-sql-2005-y.html

Roles:

http://practicascomunes.blogspot.com/2008/09/scripting-role-members-in-every.html

The first link is in spanish, but you can easily translate it on Google.

Hope that helps you.

Regards.

Jose...

You must apply it, even if you don't have Reporting Services Installed.

Regards.

Jose Santiago Oyervides.

Also, You can run the installer anytime, to see what options are offered and then, at the last step you cancel the update, this way you can see what you...

Hi,

Some time ago, I did an script in Powershell to do that:

http://practicascomunes.blogspot.com/2008/08/utilizando-poweshell-con-sql-2005-smo.html

It's written in spanish, but you can translate in google.

Hope it helps.

Regards.

JSO

Hi,

Today PS SQL published an article which talks regarding the several files you can find in an CU.

Here's the link:

http://blogs.msdn.com/psssql/archive/2009/10/23/should-i-have-a-snac-with-my-cumulative-update.aspx

Regards,

JSO

Typically, you solve this by checking in the log the msp file that the installer is looking for and copying the msp file from the latest patch (uncompressing the .exe)...

Hi Eric,

The patches are cumulative, so after you install the latest security update, you server has now all the fixes, including CU4,CU5 and the latest hotfix.

http://support.microsoft.com/kb/960598

Regards,

Jose Santiago Oyervides.

So,

Did you uninstall CU1 succesfully? After what you did...

Hi,

You should check:

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB959195_sqlrun_tools.msp.log

For more information, it seems you have a corrupted or missing file in c:\windows\installer that the package is looking for, check for more info...