WSUS 3.0 SP2 problems, not resolved with re-install, localized in sqlcomm

Discussion in 'Update Services' started by Topper BG, May 12, 2011.

  1. Topper BG

    Topper BG Guest

    Hello pals,

    Suddnely my WSUS reported me, that there is "no connected computers from 30 days" no my 2008 R2 server.

    Strange but in WSUS admin console all groups by OS was empty, even unsotred PC's

    After few checks and advices from forum, decide to reinstall.

    So far, so good, but the situation is the same - no client computers ever connected to WSUS.

    This is what i can see like debug:

    Item 1:

    C:\Program Files\Update Services\Tools>WsusDebugTool.exe /Tool:GetConfiguration

    Running... GetConfiguration

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup

    :

    Version:3

    InstallLanguage:ENU

    ProxyPassword:

    SmtpUserPassword:

    VersionString:3.2.7600.226

    ConfigurationSource:0

    ServicePackLevel:2

    TargetDir:C:\Program Files\Update Services\

    InstallType:1

    EnableRemoting:1

    WsusAdministratorsSid:S-1-5-21-673598038-153398211-3370771635-1240

    WSUSReportersSid:S-1-5-21-673598038-153398211-3370771635-1239

    SqlServerName:AD\MICROSOFT##SSEE

    SqlAuthenticationMode:WindowsAuthentication

    SqlDatabaseName:SUSDB

    SqlUserName:

    SqlEncryptedPassword:

    SqlInstanceIsRemote:0

    wYukonInstalled:1

    ContentDir:D:\WSUS

    PortNumber:80

    IISTargetWebSiteIndex:1

    IISTargetWebSiteCreated:False

    IISUninstallConfigFilePath:C:\Program Files\Update Services\setup\Uninst

    allSettings.xml

    IISPreviousInstallRevision:

    IISInstallRevision:3.2.7600.226

    IIsDynamicCompression:-1

    EncryptionParam:System.Byte[]

    EncryptionKey:System.Byte[]

    UsingSSL:0

    HostHeader:

    After this line begans errors:



    Error processing node: GetConfiguration

    System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection

    owningObject)

    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

    at System.Data.SqlClient.SqlConnection.Open()

    at Microsoft.SoftwareDistribution.Tools.SqlHandler.HandleQuery(TextWriter dataWriter, String baseDirectory, ArrayList sqlQueryList)

    at Microsoft.SoftwareDistribution.Tools.InstallConfiguration.DumpData(StringbaseDirectory, String nodeName, XmlNode infoXml)

    at Microsoft.SoftwareDistribution.Tools.SusServerTool.ProcessDumpNode(XmlNode dumpNode)





    Item 2: Acording this advice http://technet.microsoft.com/en-us/library/dd939833(WS.10).aspx I've checked:



    C:\Program Files\Update Services\Tools>Reg query "HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup" /v SqlServerName

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup

    SqlServerName REG_EXPAND_SZ %computername%\MICROSOFT##SSEE

    C:\Program Files\Update Services\Tools> sqlcmd -S %computername%\MICROSOFT##SSEE -E -d SUSDB

    1>



    Item 3: http://localhost/selfupdate/

    <fieldset><legend>Error Summary</legend>
    HTTP Error 403.14 - Forbidden
    The Web server is configured to not list the contents of this directory.
    </fieldset>
    <fieldset><legend>Detailed Error Information</legend></fieldset>
    Module DirectoryListingModule
    Notification ExecuteRequestHandler
    Handler StaticFile
    Error Code 0x00000000
    Requested URL http://localhost:80/selfupdate/
    Physical Path C:\Program Files\Update Services\Selfupdate\
    Logon Method Anonymous
    Logon User Anonymous


    And that's all?

    WSUS service is started, no problems on admin console

    MSSQL service is tarted, no problems

    Ther is WSUS administrator and WSUS reporter groups



    Any other ideas ?!?
     
    Topper BG, May 12, 2011
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sancheezia

    Plan3d.exe Problems Not Resolved

    Sancheezia, Aug 27, 2007, in forum: Windows Vista General Discussion
    Replies:
    13
    Views:
    466
    philpat01
    Jan 17, 2009
  2. Gerry

    Date/Time not localized for WMP11 in Vista RTM x64

    Gerry, Dec 10, 2006, in forum: Windows Vista Music, Pictures and Video
    Replies:
    0
    Views:
    156
    Gerry
    Dec 10, 2006
  3. Sébastien Mouren
    Replies:
    0
    Views:
    187
    Sébastien Mouren
    Feb 2, 2006
  4. chace zhang
    Replies:
    0
    Views:
    1,132
    chace zhang
    Nov 14, 2006
  5. Ondrej Sevecek

    RESOLVED: WSUS does not start automatically after reboot

    Ondrej Sevecek, Nov 25, 2005, in forum: Update Services
    Replies:
    2
    Views:
    181
    Ondrej Sevecek
    Nov 28, 2005
Loading...

Share This Page