Prev: why cant i get windows update
Next: Error details: Code 80072EFE
From: chrismanchester on 17 Dec 2007 03:57
Hi Chris,

Thanks for your suggestion, however it did not seem to solve the problem for
me.

The unexpected error is still occuring whenever I try to browse computers
within the WSUS Admin console. I can browse any other node within the admin
console but whenever I try to list "All Computers" the error appears and
Event 7053 is logged in the event log.

Any ideas/suggestions anyone?

Cheers,

Chris

"Chris Wonson" wrote:

> I had the same problem, using a Windows Internal Database and had to do the following to resolve it:
>
> 1 - download and install MS SQL Server Native Client
> (http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlncli.msi)
>
> 2 - download and install MS SQL Server 2005 Command Line Query Utility
>
> (http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/SQLServer2005_SQLCMD.msi)
>
> [above links are for x86 versions. See link below for other versions and MSSQL related software
> http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en)
>
> 3 - Connect to the database with the following command:
>
> sqlcmd -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query -E -d SUSDB
>
> 4 - Enter the following SQL commands:
>
> UPDATE tbPreComputedLocalizedProperty
> set Title = REPLACE(Title, '"','')
> WHERE Title LIKE '%"Nitrogen"%'
> GO
> QUIT
>
> This removes the double-quotes that are causing the error. Other posts have suggested that the same needs to be done for tbPrecomputedCategoryLocalizedProperty, but this was not required in my case.
>
>
> I hope this helps you as it did me.
>
> Regards,
> Chris Wonson
>
> EggHeadCafe - .NET Developer Portal of Choice
> http://www.eggheadcafe.com
>
 | 
Pages: 1
Prev: why cant i get windows update
Next: Error details: Code 80072EFE