RE: WSUS 3.0 Errors

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

.

Relevant Pages

  • TO get Out put of command in variable
    ... I am working in sql server 7.0 ... I want to get the out put of the command ... thanx in advance for your suggestion ... Vinod ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to post notification to SQLServerAgent
    ... Narayana Vyas Kondreddi wrote: ... > the system drive or the sql server installation drive is running out ... >> command') ... >> Any suggestion? ...
    (microsoft.public.sqlserver.odbc)
  • Re: Page Cannot Be Displayed
    ... Turn all Computers OFF and Unplug the Router from the Power Cord ... Ping statistics for 192.168.0.1: ... Step1: Then Try this Start The RUN Command and type in the following: ... and look for the DNS Server is there is any thing in front of it like Enable ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Page Cannot Be Displayed
    ... Turn all Computers OFF and Unplug the Router from the Power Cord ... Ping statistics for 192.168.0.1: ... Step1: Then Try this Start The RUN Command and type in the following: ... and look for the DNS Server is there is any thing in front of it like Enable ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Problem with Accessing One Computer on a 4-Computer Home Netwo
    ... I'm just reading this suggestion now. ... MCSA Windows 2003 server ... I'm working on a customer's wireless home network that has 4 computers ...
    (microsoft.public.windowsxp.network_web)