Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Server > Update Services > WSUS 3.0 SP2 problems, not resolved with re-install, localized in sqlcomm

Reply
Thread Tools Display Modes

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

 
 
Topper BG
Guest
Posts: n/a

 
      05-12-2011
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:\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.OnErro r(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(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.Att emptOneLogin(ServerInfoserverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

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

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

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

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

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

at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)

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

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

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

at Microsoft.SoftwareDistribution.Tools.InstallConfig uration.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/l...33(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 ?!?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't save file in localized folder Carl Windows Vista File Management 2 08-06-2007 09:58 PM
Date/Time not localized for WMP11 in Vista RTM x64 Gerry Windows Vista Music, Pictures and Video 0 12-10-2006 06:00 PM
RE: MOVE b:\wsus \MSSQL$WSUS to d:\wsus \MSSQL$WSUS using SBS 2K3-2 (SQL 2005) (move SQL WSUS databse) chace zhang Windows Small Business Server 0 11-14-2006 07:36 AM
IE-7.0.5296.0 setup has difficulties with localized folders on french Windows XP SP2 Sébastien Mouren Internet Explorer 0 02-02-2006 11:06 AM
RESOLVED: WSUS does not start automatically after reboot Ondrej Sevecek Update Services 2 11-28-2005 04:17 PM