WSUS 3.0 SP1 upgrade failed

[HNguy...@gmail.com]

I have WSUS 2.0 SP1 installed and I've tried upgrading to WSUS 3.0 two
times already. Both times have failed. I've had to reinstall WSUS
2.0 and recover the DB. I'm thinking about just uninstalling WSUS 2.0
and install a fresh copy of WSUS 3.0 and start from scratch, if this
doesn't work. Can someone please take a look at the logs and
determine what is causing my problem?

WSUSSetup.log file

-------------------------

2008-04-03 16:10:34 Success MWUSSetup Validating pre-
requisites...
2008-04-03 16:10:34 Error MWUSSetup Failed to determine
if an higher version of WSUS is installed. Assuming it is not...
(Error 0x80070002: The system cannot find the file specified.)
2008-04-03 16:10:55 Success MWUSSetup SQL version is not
Yukon. Yukon version 9.00.2047. SQL instance version 8.00.2039
2008-04-03 16:11:14 Success MWUSSetup Creating database
backup...
2008-04-03 16:16:31 Success MWUSSetup Uninstalling the
selfupate tree...
2008-04-03 16:17:23 Success MWUSSetup Removing Wsus 2.0...
2008-04-03 16:17:36 Success CustomActions.Dll .Net framework path:
C:\WINDOWS\Microsoft.Net\Framework\v1.1.4322
2008-04-03 16:19:12 Success CustomActions.Dll Deleting WSUS
Administrators user group
2008-04-03 16:19:12 Success CustomActions.Dll Successfully delete
WSUS Administrators user group
2008-04-03 16:19:29 Info IISCustomAction Performing Setup
Action, Command /Uninstall
2008-04-03 16:19:31 Info IISCustomAction Command /Uninstall
Succeeded
2008-04-03 16:20:41 Success CustomActions.Dll WSUS website
shortcut is deleted successfully
2008-04-03 16:21:17 Success MWUSSetup Uninstaling Wmsde...
2008-04-03 16:22:28 Success MWUSSetup Installing ASP.Net
2008-04-03 16:23:32 Success MWUSSetup ASP.Net is installed
successfully
2008-04-03 16:23:32 Success MWUSSetup Installing wYukon
using MSI on Win2k3
2008-04-03 16:23:32 Success MWUSSetup Installing wYukon...
2008-04-03 16:26:07 Success MWUSSetup wYukon Installed
Successfully
2008-04-03 16:26:10 Success MWUSSetup Installing WSUS...
2008-04-03 16:26:18 Success CustomActions.Dll Successfully set
propery of WSUS admin groups' full names
2008-04-03 16:26:19 Success CustomActions.Dll .Net framework path:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
2008-04-03 16:26:21 Success CustomActions.Dll Creating user group:
WSUS Reporters with Description: WSUS Administrators who can only run
reports on the Windows Server Update Services server.
2008-04-03 16:26:21 Success CustomActions.Dll Creating WSUS
Reporters user group
2008-04-03 16:26:21 Success CustomActions.Dll WSUS Reporters user
group already exists
2008-04-03 16:26:21 Success CustomActions.Dll Successfully created
WSUS Reporters user group
2008-04-03 16:26:21 Success CustomActions.Dll Creating user group:
WSUS Administrators with Description: WSUS Administrators can
administer the Windows Server Update Services server.
2008-04-03 16:26:21 Success CustomActions.Dll Creating WSUS
Administrators user group
2008-04-03 16:26:21 Success CustomActions.Dll WSUS Administrators
user group already exists
2008-04-03 16:26:21 Success CustomActions.Dll Successfully created
WSUS Administrators user group
2008-04-03 16:26:21 Success CustomActions.Dll Successfully created
WSUS user groups
2008-04-03 16:37:06 Info IISCustomAction Performing Setup
Action, Command /Install
2008-04-03 16:37:29 Info IISCustomAction Command /Install
Succeeded
2008-04-03 17:13:23 Error CustomActions.Dll RemovePsfsip: Failed
to load dll (Error 0x8007007E: The specified module could not be
found.)
2008-04-03 17:13:56 Info IISCustomAction Performing Setup
Action, Command /Rollback
2008-04-03 17:14:23 Info IISCustomAction Command /Rollback
Succeeded
2008-04-03 17:14:44 Error MWUSSetup InstallWsus: MWUS
Installation Failed (Error 0x80070643: Fatal error during
installation.)
2008-04-03 17:14:44 Error MWUSSetup
CUpgradeDriver::PerformSetup: WSUS installation failed (Error
0x80070643: Fatal error during installation.)
2008-04-03 17:14:44 Error MWUSSetup
CSetupDriver::LaunchSetup: Setup failed (Error 0x80070643: Fatal error
during installation.)

=================================
WSUSCa_080403_1610.log
=================================

The uninstall is beginning.
See the contents of the log file for the c:\program files\update
services\service\bin\wsusservice.exe assembly's progress.
The file is located at C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log.
Uninstalling assembly 'c:\program files\update services\service\bin
\wsusservice.exe'.
Affected parameters are:
assemblypath = c:\program files\update services\service\bin
\wsusservice.exe
logfile = C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log
showcallstack =
Removing EventLog source WSUSService.
Service WSUSService is being removed from the system...
Service WSUSService was successfully removed from the system.

The uninstall has completed.

***** 2008-04-03 16:19:46 20:19:46 Executing External Command: C:
\Program Files\Update Services\\tools\osql\osql.exe -S CITYHALL\WSUS
-E -b -n -Q "USE SUSDB EXEC sp_revokedbaccess N'NT AUTHORITY\NETWORK
SERVICE'" *****
User has been dropped from current database.

***** 2008-04-03 16:19:52 20:19:52 External Command Exited, Return
Code: 0 *****

***** 2008-04-03 16:19:52 20:19:52 Executing External Command: C:
\Program Files\Update Services\\tools\osql\osql.exe -S CITYHALL\WSUS
-E -b -n -Q "USE SUSDB EXEC sp_revokedbaccess N'CITYHALL\ASPNET'"
*****
User has been dropped from current database.

***** 2008-04-03 16:19:57 20:19:57 External Command Exited, Return
Code: 0 *****

***** 2008-04-03 16:19:57 20:19:57 Executing External Command: C:
\Program Files\Update Services\\tools\osql\osql.exe -S CITYHALL\WSUS
-E -b -n -Q "USE SUSDB EXEC sp_revokedbaccess N'CITYHALL\WSUS
Administrators'" *****
User has been dropped from current database.

***** 2008-04-03 16:20:00 20:20:00 External Command Exited, Return
Code: 0 *****

***** 2008-04-03 16:20:00 20:20:00 Executing External Command: C:
\Program Files\Update Services\\tools\osql\osql.exe -S CITYHALL\WSUS
-E -b -n -Q "EXEC sp_revokelogin N'CITYHALL\WSUS Administrators'"
*****
Revoked login access from 'CITYHALL\WSUS Administrators'.

***** 2008-04-03 16:20:01 20:20:01 External Command Exited, Return
Code: 0 *****

The uninstall is beginning.
See the contents of the log file for the c:\program files\update
services\setup\bin\microsoft.updateservices.setup.customactions.dll
assembly's progress.
The file is located at C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log.
Uninstalling assembly 'c:\program files\update services\setup\bin
\microsoft.updateservices.setup.customactions.dll'.
Affected parameters are:
wsusinstall =
assemblypath = c:\program files\update services\setup\bin
\microsoft.updateservices.setup.customactions.dll
logfile = C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log
showcallstack =
Removing performance counter category WSUS: Server Web Methods.
Removing performance counter category WSUS: Server Web Service.
Removing performance counter category WSUS: Client Web Service
Methods.
Removing performance counter category WSUS: Client Web Service.
Removing performance counter category WSUS: Reporting Web Service.

The uninstall has completed.
Converting database 'SUSDB' from version 539 to the current version
611.
Database 'SUSDB' running the upgrade step from version 539 to version
551.
Database 'SUSDB' running the upgrade step from version 551 to version
552.
Database 'SUSDB' running the upgrade step from version 552 to version
553.
Database 'SUSDB' running the upgrade step from version 553 to version
554.
Database 'SUSDB' running the upgrade step from version 554 to version
589.
Database 'SUSDB' running the upgrade step from version 589 to version
590.
Database 'SUSDB' running the upgrade step from version 590 to version
593.
Database 'SUSDB' running the upgrade step from version 593 to version
597.
Database 'SUSDB' running the upgrade step from version 597 to version
604.
Database 'SUSDB' running the upgrade step from version 604 to version
605.
Database 'SUSDB' running the upgrade step from version 605 to version
606.
Database 'SUSDB' running the upgrade step from version 606 to version
607.
Database 'SUSDB' running the upgrade step from version 607 to version
608.
Database 'SUSDB' running the upgrade step from version 608 to version
609.
Database 'SUSDB' running the upgrade step from version 609 to version
610.
Database 'SUSDB' running the upgrade step from version 610 to version
611.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Changed database context to 'SUSDB'.
Changed database context to 'SUSDB'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Creating Procedures spDropForeignKeyConstraint
Adding function spDropTableColumnIfExists
Adding function spAddTableColumnIfNotExists
Adding function spDropPrimaryKeyConstraint
Creating table dbo.tbPrerequisiteDependency
Creating table dbo.tbBundleDependency
Creating table tbUpdateStatusPerComputer
Caution: Changing any part of an object name could break scripts and
stored procedures.
Creating table tbUpdateSummaryForAllComputers
Creating table tbComputerSummaryForMicrosoftUpdates
Creating table dbo.tbRequestedTargetGroup
Creating table dbo.tbRequestedTargetGroupsForTarget
Creating table tbDeletedComputer
Creating table dbo.tbComputerTargetDetail
Creating table dbo.tbComputerTarget
Purging computers with duplicate names
upgrading tbComputerTarget, moving columns to tbComputerTargetDetail
Upgrading dbo.tbComputerTarget: copy to dbo.tbComputerTargetDetail
Creating table dbo.tbClientWithRecentNameChange
Creating table dbo.tbDownstreamServerTarget
Creating table dbo.tbDownstreamServerSummaryRollup
Creating table dbo.tbDownstreamServerClientSummaryRollup
Creating table dbo.tbDownstreamServerClientActivityRollup
Creating table dbo.tbTarget
Creating table dbo.tbTargetType
Creating table dbo.tbDeployment
tbDeployment exists, updating it
tbDeployment does not have Priority column, creating it now
tbDeployment does not have TargetGroupTypeID column, creating it now
tbDeployment: update priority column
Creating table dbo.tbDeadDeployment
tbDeadDeployment does not have TargetGroupTypeID column, creating it
now
Creating UpdateID, RevisionNumber, UpdateType columns in
tbDeadDeployment
Creating table dbo.tbRevisionLanguage
Creating table dbo.tbProperty
Creating table dbo.tbRevisionExtendedProperty
Creating table dbo.tbKBArticleForRevision
Creating table dbo.tbMoreInfoURLForRevision
Creating table dbo.tbSecurityBulletinForRevision
Creating table dbo.tbLocalizedPropertyForRevision
Creating table dbo.tbFileForRevision
Creating table dbo.tbRevisionSupersedesUpdate
Creating table dbo.tbInstalledUpdateSufficientForPrerequisite
Creating table dbo.tbBundleAtLeastOne
Creating table dbo.tbBundleAll
Creating table dbo.tbPrerequisite
Creating table dbo.tbDriver
Creating table dbo.tbCompatiblePrinterProvider
Creating table dbo.tbDriverClass
Creating table dbo.tbTargetGroup
Creating table dbo.tbFlattenedTargetGroup
Msg 924, Level 14, State 1, Server \\.\pipe\MSSQL$MICROSOFT##SSEE\sql
\query, Line 4
Database 'SUSDB' is already open and can only have one user at a time.
Retrying failed batch. Attempt 1.
Waiting for exclusive access to database SUSDB from system process
having SPID 10.
Changed database context to 'SUSDB'.
Creating table dbo.tbTargetGroupType
Creating table dbo.tbExpandedTargetInTargetGroup
Creating table dbo.tbTargetInTargetGroup
Inserting into dbo.tbExpandedTargetInTargetGroup during upgrade of
dbo.tbTargetInTargetGroup
Creating table dbo.tbEulaProperty
Creating table dbo.tbEulaAcceptance
Creating table dbo.tbLocalizedProperty
Creating table dbo.tbFile
Creating table dbo.tbXml
Creating table dbo.tbGroupAuthorization
Creating table dbo.tbAuthorization
Creating table dbo.tbFileOnServer
Creating table dbo.tbFileDownloadProgress
Creating table dbo.tbSingletonData
Creating table dbo.tbReference
Creating table dbo.tbFrontEndServersHealth
Creating table dbo.tbConfigurationC
Creating table dbo.tbConfigurationB
Creating table dbo.tbConfigurationA
Creating table dbo.tbConfiguration
Creating table dbo.tbImplicitCategory
Creating table dbo.tbCategoryInSubscription
Creating table dbo.tbLanguageInSubscription
Creating table dbo.tbSchedule
Creating table dbo.tbEmailNotificationRecipient
Creating table dbo.tbRevisionInCategory
Creating table dbo.tbCategory
Creating table dbo.tbRevision
Creating table dbo.tbRevisionExtendedLanguageMask
Creating table dbo.tbUpdate
Creating table dbo.tbUpdateType
Creating table dbo.tbUpdateFlag
Creating table dbo.tbHandler
Creating table dbo.tbLanguage
Creating table dbo.tbCategoryType
Creating table dbo.tbStateMachine
Creating table dbo.tbStateMachineState
Creating table dbo.tbStateMachineEvent
Creating table dbo.tbStateMachineTransition
Creating table dbo.tbStateMachineEventTransitionLog
Adding View vwStateMachineEventTransitionLog
Creating table dbo.tbNotificationEvent
Creating table dbo.tbChangeTracking
Creating table dbo.tbFlattenedRevisionInCategory
Creating table dbo.tbServerSyncResult
Creating table dbo.tbAutoDeploymentRule
Creating table dbo.tbUpdateClassificationInAutoDeploymentRule
Creating table dbo.tbCategoryInAutoDeploymentRule
Creating table dbo.tbTargetGroupInAutoDeploymentRule
Creating table dbo.tbSchemaVersion
Creating table dbo.tbServerHealth
Creating table dbo.tbProgramKeys
Creating table tbComputersThatNeedDetailedRollup
Adding indexed view ivwApiUpdateRevision
Creating Procedure spAddConstraint
executing stored PROCEDURE spAddConstraint
Adding FUNCTION fn_GetGrade
Adding FUNCTION fnGetOnlineSummaryFlags
Adding PROCEDURE spUpdateChangeTrackingNumber
Creating PROCEDURE spUpdateChangeTrackingNumber
Adding Trigger trOnUpdatingConfiguration
Adding Trigger trOnInsertingUpdateStatus
Adding Trigger trOnDeletingUpdateStatus
Adding Trigger trOnUpdatingUpdateStatus
Adding FUNCTION fn_GetBestRevisionForEvaluateDeployment
Adding PROCEDURE spMoveEvaluateDeploymentsAsNeeded
Adding PROCEDURE spDeleteUneededPrerequisiteDeployments
Adding PROCEDURE spDeleteUneededBundleDeployments
Adding PROCEDURE spProcessPrerequisitesForRevision
Adding TRIGGER trOnUpdatingRevision
Adding TRIGGER trOnUpdatingDeployment
Adding TRIGGER trOnAddingDeployment
Adding Trigger trOnDeletingDeployment
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spGetStringFromContextInfo'. The stored procedure will still be
created; however, it cannot be successfully executed until the table
exists.
Adding trigger trAdjustIsLeaf_reduce
Adding trigger trAdjustPrerequisite
Adding triggers trExpandRevisionInCategory
Adding triggers trExpandFlattenedRevisionInCategory
Adding triggers trExpandRevisionLanguage
Adding triggers trAdjustIsLeaf_increase
Adding trigger trOnAddingUpdatingGroupAuthorization
Adding trigger trOnDeletingGroupAuthorization
Adding trigger trOnAddingUpdatingAuthorization
Adding trigger trOnDeletingAuthorization
Adding trigger trOnAddingLanguage
Adding trigger trOnChangingLanguage
Adding trigger trOnDeletingLanguage
Adding trigger trOnAddingDriver
Adding trigger trOnDeletingDriver
Adding trigger tr_insert_ExpandedTargetInTargetGroup
Adding trigger tr_delete_ExpandedTargetInTargetGroup
Adding FUNCTION fn_later_date
Adding PROCEDURE spSaveXmlFragment
Creating Procedure spSaveXmlFragment
Adding PROCEDURE spGetChildCategories
Creating Procedure spGetChildCategories
Adding PROCEDURE spGetUssDeployments
Creating Procedure spGetUssDeployments
Adding PROCEDURE spUpdateSubTimestamp
Creating Procedure spUpdateSubTimestamp
Adding PROCEDURE spPopulateLanguageInSubscription
Creating Procedure spPopulateLanguageInSubscription
Adding PROCEDURE spAddNewLanguage
Creating Procedure spAddNewLanguage
Adding PROCEDURE spCheckRevisionExists
Creating Procedure spCheckRevisionExists
Adding PROCEDURE spCheckUpdateExists
Creating Procedure spCheckUpdateExists
Adding PROCEDURE spGetFilter
Creating procedure spUpdateOnlineSummaryTablesForUpdateVisible
Creating procedure spUpdateOnlineSummaryTablesForUpdateNotVisible
Creating Procedure spImportUpdate
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spPopulateMissingExpandedUpdateContentThrottlingInfo'. The stored
procedure will still be created; however, it cannot be successfully
executed until the table exists.
Creating Procedure spDeploymentAutomation
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spAddReportingEventInternal'. The stored procedure will still be
created; however, it cannot be successfully executed until the table
exists.
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spAddReportingEventInternal'. The stored procedure will still be
created; however, it cannot be successfully executed until the table
exists.
Creating Procedure spSetInitialDeploymentStatus
Creating Procedure spImportUpdateForServerSync
Adding FUNCTION fn_FormatError
Adding FUNCTION fn_FormatLog
Adding FUNCTION fn_BuildDeploymentMessage
Creating Procedure spSelectProcFortbNotificationEvent
Creating Procedure spUpdateProcFortbNotificationEvent
Creating Procedure spSelectProcFortbSubscription
Creating Procedure spUpdateProcFortbSubscription
Creating Procedure spSelectProcFortbRevision
Creating Procedure spUpdateProcFortbRevision
Creating Procedure spSelectProcFortbFileOnServerDesired
Creating Procedure spUpdateProcFortbFileOnServerDesired
Creating Procedure spSelectProcFortbFileOnServerActual
Creating Procedure spUpdateProcFortbFileOnServerActual
Creating Procedure spFireStateMachineEventEx
Creating Procedure spFireStateMachineEvent
Adding PROCEDURE spGetNotificationEventItem
Creating Procedure spGetNotificationEventItem
Adding PROCEDURE spGetNotificationEventNamesToWakeUp
Creating PROCEDURE spGetNotificationEventNamesToWakeUp
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spWakeUpEmailNotificationAgent'. The stored procedure will still
be created; however, it cannot be successfully executed until the
table exists.
Adding PROCEDURE spGetNotificationEventNamesToWakeUpOnStartup
Creating PROCEDURE spGetNotificationEventNamesToWakeUpOnStartup
Adding PROCEDURE spCleanupIntermediateFileStatesOnStartup
Creating PROCEDURE spCleanupIntermediateFileStatesOnStartup
Adding PROCEDURE spStartCatalogSync
Creating Procedure spStartCatalogSync
Adding PROCEDURE spCancelCatalogSync
Creating Procedure spCancelCatalogSync
Adding PROCEDURE spSetHandshakeAnchor
Creating Procedure spSetHandshakeAnchor
Adding PROCEDURE spResetNotificationState
Creating Procedure spResetNotificationState
Adding PROCEDURE spGetLocalIdList
Creating Procedure spGetLocalIdList
Adding PROCEDURE spQueueCatalogSyncRequest
Creating Procedure spQueueCatalogSyncRequest
Adding PROCEDURE spGetSubscriptionProgress
Creating Procedure spGetSubscriptionProgress
Adding PROCEDURE spSetSubscriptionProgress
Creating Procedure spSetSubscriptionProgress
Adding PROCEDURE spSetCatalogSyncFail
Creating Procedure spSetCatalogSyncFail
Adding PROCEDURE spNotifySyncCancel
Creating Procedure spNotifySyncCancel
Adding PROCEDURE spSyncWorkDone
Creating Procedure spSyncWorkDone
Adding PROCEDURE spGetNextQueuedSubscription
Creating Procedure spGetNextQueuedSubscription
Adding PROCEDURE spGetSubscriptionState
Creating Procedure spGetSubscriptionState
Adding PROCEDURE spFixCatalogSyncStates
Creating Procedure spFixCatalogSyncStates
Creating Procedure spCancelFilesAndRelatedRevisions
Creating Procedure
spDeactivateDeploymentsAndNotifyParentRevisionsChildNotReady
Creating Procedure spCheckRevisionsNeedingFile
Creating Procedure spNotifyFileActualStateMUUrlNeeded
Creating Procedure spNotifyFileActualStateDownloadNeeded
Creating Procedure spNotifyFileActualStateImportNeeded
Creating Procedure spNotifyFileActualStateNotNeeded
Creating Procedure spNotifyActualStateAndRevisionsFileCancelled
Creating Procedure spWakeUpContentAgent
Creating Procedure spRemoveFileFromProgress
Creating Procedure spRemoveFileFromProgressAndWakeUpContentAgent
Creating Procedure spNotifyRevisionsFileReady
Creating Procedure spNotifyRevisionsFileFailed
Creating Procedure spCheckFileDesiredState
Creating Procedure spCheckFileDownloadQueue
Creating Procedure spCheckDesiredStateAndNotifyRevisionsFileReady
Creating Procedure
spCheckFileDownloadQueueAndNotifyRevisionsFileFailed
Creating Procedure spCheckDesiredStateAndNotifyRevisionsFileFailed
Creating Procedure spNotifyRevisionsFileNotReadyAndCheckDesiredState
Creating Procedure spCheckFileDownloadQueueAndRemoveFileFromProgress
Creating Procedure spCheckFileDownloadQueueAndDesiredState
Creating Procedure spUpdateQueueEntryTimeAndCheckFileDownloadQueue
Creating Procedure spNotifyContentSyncNotificationEventWorking
Creating Procedure spGetNextContentSyncWorkItem
Creating Procedure spGetNextContentSyncWorkItemOnStartup
Creating PROCEDURE spUpdateFileDownloadProgress
Creating Procedure spSetFileMUUrl
Creating Procedure spGetUpdatesForFile
Creating Procedure spRetrieveFileDigestFromRowID
Creating Procedure spNotifyEulaFilesNeeded
Creating Procedure spCheckRevisionInstallationPossibility
Creating Procedure
spNotifyParentsEulasReadyAndCheckRevisionInstallationPossibility
Creating Procedure
spCheckRevisionNeededAndNotifyParentsChildInstallationPossible
Adding procedure spAddDownstreamServerToTargetGroup
Adding procedure spPreregisterDownstreamServer
Adding PROCEDURE spGetDssTargetGroup
Adding PROCEDURE spUpdateDownstreamServerID
Adding PROCEDURE
spReturnStateMachineTransitionEventLogEntriesFromError
Creating Procedure
spReturnStateMachineTransitionEventLogEntriesFromError
Creating Procedure spCheckFilesAndChildRevisionsReady
Creating Procedure spNotifyFilesAndChildRevisionsNeeded
Creating Procedure
spActivateDeploymentsAndNotifyParentRevisionsChildReady
Creating Procedure spFailParentRevisions
Creating Procedure spCheckEulasAndChildRevisionsReady
Creating Procedure spDeactivateDeploymentsNotifyFilesNotNeeded
Creating Procedure spResetStateMachineAndReEvaluate
Creating Procedures spCancelAllNotReadyRevisions
Creating Procedures spDownloadAllNotNeededRevisions
Creating Procedures spWakeUpResetAgent
Creating Procedures spWakeUpEmailNotificationAgent
Creating Procedures spNotifyResetAgentNotificationEventWorking
Creating Procedures spNotifyResetAgentNotificationEventDone
Creating Procedures spWakeUpRollupAgent
Creating Procedures spNotifyRollupAgentNotificationEventWorking
Creating Procedures spNotifyRollupAgentNotificationEventDone
Creating Procedures
spNotifyEmailNotificationAgentNotificationEventWorking
Creating Procedures
spNotifyEmailNotificationAgentNotificationEventDone
Creating Procedure spSaveUssHostOnMU
Creating Procedure spRetrieveUssHostOnMU
Creating Procedure spGetLastServerSyncCookie
Creating Procedure spSetLastServerSyncCookie
Creating Procedure spResetServer
Creating Procedure spGetLastSyncTime
Creating Procedure spSetLastSyncTime
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spMarkComputerAsNeedingDetailedRollup'. The stored procedure will
still be created; however, it cannot be successfully executed until
the table exists.
Creating Procedure spIsRegistrationRequired
Creating Procedure spGetComputerTargetGroup
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spMarkComputerAsNeedingDetailedRollup'. The stored procedure will
still be created; however, it cannot be successfully executed until
the table exists.
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spMarkComputerAsNeedingDetailedRollup'. The stored procedure will
still be created; however, it cannot be successfully executed until
the table exists.
Creating Procedure spCheckForClientNameChange
Creating Procedure spGetFrontEndServers
Creating Procedure spRemoveFrontEndServer
Creating Procedure spGetClientsWithRecentNameChange
Creating Procedure spGetComputerTargetGroupEx
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spMarkComputerAsNeedingDetailedRollup'. The stored procedure will
still be created; however, it cannot be successfully executed until
the table exists.
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spMarkComputerAsNeedingDetailedRollup'. The stored procedure will
still be created; however, it cannot be successfully executed until
the table exists.
Adding PROCEDURE spRegisterComputer
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spMarkComputerAsNeedingDetailedRollup'. The stored procedure will
still be created; however, it cannot be successfully executed until
the table exists.
Creating Procedure spSetBatchURL
Creating Procedure spUpdateServerHealthStatus
Creating PROCEDURE spGetExportData
Creating Procedure spGetExportUpdateData
Adding PROCEDURE spGetDataForSyncPackage
Creating Procedure spGetDataForSyncPackage
Creating Procedure spGetBundedByDataForSyncPackage
Creating Procedure spGetUpdateDataForSyncPackage
Creating Procedure spGetUpdateTypeByRevisionID
Creating Procedure spEnableReplica
Creating Procedure spGetAllExplicitComputerDeployments
Adding procedure spGetUpdatesForBulkHideInReplicaSync
Adding Procedure spDeleteRevision
Creating Procedure spGetCompressionThesholds
Adding Procedure spGetUpdatesWithPermanantlyInactiveDeployments
Adding Procedure
spDeleteDeploymentsForUpdatesWithPermanantlyInactiveDeployments
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'dbo.spSetStringInContextInfo'. The stored procedure will still be
created; however, it cannot be successfully executed until the table
exists.
Adding Procedure spSetUpdateFlagCatalogSite
Adding Procedure spGetUpdatesWithCatalogSiteFlag
Adding Procedure spMarkComputerAsNeedingDetailedRollup
Adding Procedure spMarkComputerAsDeletedForDss
Adding Procedure spUpdateDownstreamServerTarget
Adding Procedure spUpdateDownstreamServerSummaryRollup
Adding Procedure spUpdateDownstreamServerClientSummaryRollup
Adding Procedure spUpdateDownstreamServerClientActivityRollup
Adding Procedure spGetDownstreamServerClientSummaries
Adding Procedure spClearAllClientActivityCounts
Adding Procedure spGetClientSummaryForAllServers
Adding Procedure spGetClientActivityForAllServers
Adding Procedure spSetLastTimeReportToMU
Adding Procedure spGetLastTimeReportToMU
Adding PROCEDURE spGetTempContentCache
Creating PROCEDURE spGetTempContentCache
Creating PROCEDURE
spPopulateMissingExpandedUpdateContentThrottlingInfo
Creating PROCEDURE spSetStringInContextInfo
Creating PROCEDURE spGetStringFromContextInfo
Creating PROCEDURE spSetOfflineSyncExclusionList
Creating PROCEDURE spGetEncryptedProxyPasswordFromDatabaseForUpgrade
Changed database context to 'SUSDB'.
Adding function fnGetConfigurationValue
Adding view vwConfiguration
Adding PROCEDURE spConfiguration
Creating Procedure spConfiguration
Creating Procedure spGetUpstreamServerInfo
Adding PROCEDURE spGetUpdateXmlFromRevision
Creating Procedure spGetUpdateXmlFromRevision
Adding PROCEDURE spGetChangeTrackingInformation
Creating PROCEDURE spGetChangeTrackingInformation
Adding PROCEDURE spGetChangeTrackingNumber
Creating PROCEDURE spGetChangeTrackingNumber
Adding procedure spGetAllLanguagesWithEnabledState
Adding procedure spCheckConnection
Adding procedure spGetChangeTrackingNumbersForCache
Adding procedure spGetLanguageListForCache
Adding procedure spGetRevisionIdListForCache
Adding Procedure spGetRelatedRevisionsForUpdateID
Adding Procedure spGetAllUpdateIDs
Adding procedure spGetProgramKeys
Changed database context to 'SUSDB'.
Creating Function fnCsvToInt
Creating Function fnCsvToUniqueID
Creating Procedure spGetCoreUpdateXml
Creating Procedure spGetLocalizedUpdateXml
Creating Procedure spGetLocaleNames
Creating Procedure spGetGlobalUpdates
Creating Procedure spGetHardwareDrivers
Creating Procedure spGetMonitorableStatus
Creating Procedure spGetFileLocations
Adding procedure spGetAllTargetGroups
Creating Procedure spGetFrontEndServerInfo
Creating Procedure spSetFrontEndServerInfo
Creating Procedure spSetFileLocationChange
Creating Procedure spGetRevisionInfo
Creating Procedure spGetDeltaRevisionInfo
Changed database context to 'SUSDB'.
Adding procedure spAdduser
Adding procedure spGrantAsp
Adding database version
Changed database context to 'SUSDB'.
Creating table tbEventMessageTemplate
Creating table tbEventInstance
Caution: Changing any part of an object name could break scripts and
stored procedures.
Creating table tbEvent
Creating table tbEventSource
Creating table tbEventNamespace
Alter table tbEvent with foreign key
Alter table tbEventSource with foreign key
Alter table tbEventMessageTemplate with foreign key
Alter table tbEventInstance with foreign keys
Adding procedure spImportEventNamespaceDescriptor
Adding procedure spAutoPurgeReportingEvents
Adding procedure spLoadReportingEventAttributes
Changed database context to 'SUSDB'.
Creating table tbLocaleMap
Creating table tbOSMap
Creating table tbDownstreamServerRollupConfiguration
Creating table tbEventRollupCounters
Adding function fnFindOsID
Adding function fnGetSummarizationState
Adding function fnGetEffectiveDeployment
Adding function fnGetTargetGroupIDForComputer
Adding procedure spAddReportingEventBatch
Adding procedure spProcessActivityEvents
Adding procedure spAddReportingEventInternal
Adding procedure spAddUpdateStatusEventBatch
Adding procedure spHandleClientRebootedEvent
Adding procedure spUpdateLatestRollupEventTime
Adding procedure spGetCurrentSqlServerTime
Adding procedure spGetLatestRollupEventTime
Adding procedure spUpdateCurrentRollupState
Adding procedure spGetCurrentRollupState
Adding procedure spGetRollupCounter
Adding procedure spUpdateRollupCounter
Adding procedure spSetLastRollupInfo
Adding procedure spGetLastRollupInfo
Adding procedure spResetOnlineSummaryTables
Changed database context to 'SUSDB'.
Adding procedure spGetComputersToRollup
Adding procedure spMarkComputersAsNeedingFullComputerRollup
Adding procedure spUpdateComputersAfterRollup
Adding procedure spAddRollupComputers
Adding procedure spGetComputerLastRollupNumbers
Adding procedure spGetOutOfSyncComputers
Adding procedure spMarkComputersAsNeedingFullStatusRollup
Adding procedure spGetComputerStatusToRollup
Adding procedure spUpdateComputerStatusAfterRollup
Adding procedure spAddRollupStatus
Adding procedure spAddRollupStatusNoStatus
Adding procedure spMarkDataForFullRollup
Changed database context to 'SUSDB'.
Adding function fnMapLocalUpdateIDToGlobal
Adding function fnMapGlobalToLocalUpdateID
Adding function fnHasStaleDeployments
Adding function fnHasSupersededUpdates
Adding function fnIsEulaAcceptanceRequired
Adding function fnGetTargetGroupTypeID
Adding function fnGetComputerTargetID
Adding function fnGetLatestRevisionNumber
Adding function fnIsInReplicaMode
Adding view vwUpdatesToReport
Adding view vwUpdateInCategory
Adding view vwApiUpdateType
Adding view vwMinimalUpdate
Adding view vwUpdateLanguage
Adding view vwDefaultLocalizedProperty
Adding view vwUpdateLocalizedProperties
Adding view vwCategoryProperties
Adding view vwEventHistory
Adding function fnTbUpdateTypeNamesToGet
Adding function fnTbComputersInTargetGroup
Adding procedure spFilterUpdatesByScopeInternal
Adding procedure spGetCategories
Adding procedure spGetTopLevelCategories
Adding procedure spGetCategoryPropertiesByID
Adding procedure spGetSubCategoriesByUpdateID
Adding procedure spGetUpdatesUnderACategory
Adding procedure spGetTotalSummary
Adding procedure spGetSummariesPerComputer
Adding procedure spGetSummariesPerUpdate
Adding procedure spGetTotalUpdateSummaryForTargetGroup
Adding procedure spGetUpdateSummariesForTargetGroup
Adding procedure spGetTotalSummaryForComputer
Adding procedure spGetComputerSummariesForTargetGroup
Adding procedure spGetTargetGroupSummariesForUpdate
Adding procedure spGetUpdateSummaryForSingleTargetGroup
Adding procedure spGetTotalSummaryForCategory
Adding procedure spGetUpdateSummariesForCategory
Adding procedure spGetComputerSummariesForCategory
Adding procedure spGetUpdateInstallationInfoForUpdate
Adding procedure spGetUpdateInstallationInfoForComputer
Adding procedure spGetUpdateInstallationInfoForTargetGroup
Adding procedure spDeployRevisionToDss
Adding procedure spGetAutoDeploymentRuleByID
Adding procedure spSaveParsedExtendedProperties
Adding procedure spGetUpdatesAndDeployments
Adding procedure spSetAutoDeploymentRule
Adding procedure spGetAutoDeploymentRuleIDs
Adding procedure spCreateAutoDeploymentRule
Adding procedure spDeleteAutoDeploymentRuleByID
Adding procedure spGetUpdateListToApproveForAutoDeploymentRule
Adding procedure spGetComputersNotContactedSinceCount
Adding procedure spDeclineUpdate
Adding procedure spGetParentCategories
Adding procedure spSearchUpdates
Adding procedure spGetAllUpdates
Adding procedure spGetUpdateCount
Adding procedure spGetRevisions
Adding procedure spGetComputerTargetByName
Adding procedure spSimpleSearchComputers
Adding procedure spSimpleSearchUpdates
Adding procedure spGetEulaFiles
Adding procedure spGetShortLanguage
Adding procedure spGetEulaAcceptances
Adding procedure spAcceptEula
Adding procedure spAcceptEulaForReplicaDSS
Adding procedure spRecurseInsertCategoriesIntoFlatTable
Adding procedure spInsertCategoriesIntoFlatTable
Adding procedure spRepairPrecomputedTables
Adding procedure spGetInstallableItems
Adding PROCEDURE spGetApprovedUpdateMetadata
Creating Procedure spGetApprovedUpdateMetadata
Adding procedure spHasApprovalsChanged
Adding procedure spGetUpdateByID
Adding procedure spGetUpdatesBundledByUpdate
Adding procedure spGetUpdatesThatBundleUpdate
Adding procedure spGetUpdatesSupersededByUpdate
Adding procedure spGetUpdatesThatSupersedeUpdate
Adding procedure spGetUpdatesRequiredByUpdate
Adding procedure spGetUpdatesThatRequireUpdate
Adding procedure spGetLanguagesForUpdate
Adding procedure spGetContentDownloadProgress
Adding procedure spCancelDownload
Adding procedure spCancelAllDownloads
Adding procedure spResumeDownload
Adding procedure spResumeAllDownloads
Adding procedure spSetConfiguration
Adding Procedure spSetRollupConfiguration
Adding procedure spGetResetStateMachineNeededFlag
Adding procedure spDeleteDeployment
Adding procedure spCreateImplicitDeployment
Adding procedure spUndeclineUpdate
Adding procedure spDeployUpdate
Adding procedure spGetDeploymentByID
Adding procedure spGetDeploymentsForAnUpdate
Adding procedure spGetDeployments
Adding procedure spRefreshDeployments
Adding procedure spGetSubscription
Adding procedure spGetSubscriptionCategories
Adding procedure spGetSubscriptionNextSynchronizationTime
Adding procedure spSetSubscription
Adding procedure spSetSubscriptionLastRunTime
Adding procedure spSetScheduleFrequency
Adding procedure spSetSubscriptionDeploymentAnchor
Adding procedure spSetSubscriptionAnchor
Adding procedure spGetTargetGroupByID
Adding procedure spGetTargetGroupForComputer
Adding procedure spGetTargetGroupsForComputer
Adding procedure spGetChildTargetGroups
Adding procedure spGetParentTargetGroup
Adding procedure spCreateTargetGroup
Adding procedure spDeleteTargetGroup
Adding procedure spAddTargetToTargetGroup
Adding procedure spRemoveTargetFromTargetGroup
Adding procedure spGetAllComputers
Adding procedure spSearchComputers
Adding procedure spGetComputerCount
Adding procedure spGetAllDownstreamServers
Adding procedure spGetInventoryItemsForComputer
Adding procedure spGetInventorySummary
Adding procedure spGetComputersHavingInventoryItem
Adding procedure spGetComputersInTargetGroup
Adding procedure spAddComputerToTargetGroup
Adding procedure spAddComputerToTargetGroupAllowMultipleGroups
Adding procedure spRemoveComputerFromTargetGroup
Adding procedure spGetDownstreamServersInTargetGroup
Adding procedure spCreateTargetEntry
Adding procedure spPreregisterComputer
Adding procedure spGetComputerByID
Adding procedure spGetDownstreamServer
Adding procedure spDeleteComputer
Adding procedure spDeleteDownstreamServer
Adding procedure spSearchEventHistory
Adding procedure spPurgeReportingEvents
Adding procedure spGetComponentsWithErrors
Adding procedure spGetUpdateServerStatus
Adding Procedure spGetDownstreamServerRollupSummary
Creating Procedure spGetXmlForUpdate
Creating Procedure spGetPreviousRevision
Adding Procedure spGetLatestRevisionNumberForUpdate
Adding Procedure spGetSdpXmlForUpdate
Adding PROCEDURE spGetEmailNotificationConfiguration
Adding PROCEDURE spSetEmailNotificationConfiguration
Adding procedure spGetEmailNotificationStatus
Adding procedure spSetEmailNotificationStatus
Adding PROCEDURE spScheduleEmailNotification
Adding PROCEDURE spGetEmailsToNotify
Adding PROCEDURE spGetEmailNotificationRecipients
Adding PROCEDURE spAddEmailNotificationRecipient
Adding PROCEDURE spDeclineSupersededUpdates
Adding PROCEDURE spDeclineExpiredUpdates
Adding PROCEDURE spCountObsoleteUpdatesToCleanup
Adding PROCEDURE spGetObsoleteUpdatesToCleanup
Adding PROCEDURE spDeleteUpdate
Adding PROCEDURE spDeleteUpdateByUpdateID
Adding PROCEDURE spCountUpdatesToCompress
Adding PROCEDURE spGetUpdatesToCompress
Adding PROCEDURE spCompressUpdate
Adding PROCEDURE spCleanupObsoleteComputers
Adding PROCEDURE spCleanupUnneededContentFiles
Adding procedure spGetFailedToDownloadUpdatesCount
Changed database context to 'SUSDB'.
Populating the database with basic configuration information
Creating the pre-defined target groups
Populating Auto Deployment Rules
Populating System Subscription
Populating Email Notification Configuration
Populating Email Notification Status
Populating Languages
Populating tbLanguageInSubscription for default subscription
Populating Categories
Populating Driver classes
Populating handlers
Populating driver types
Populating state machine
Changed database context to 'SUSDB'.
Changed database context to 'SUSDB'.
Creating PROCEDURE spUpdateInventoryRulesXml
Creating PROCEDURE spAddDetailedInventoryRules
Creating PROCEDURE spGetInventoryVersion
Creating PROCEDURE spAddInventoryXml
Creating PROCEDURE spAddDetailedInventoryInformation
Changed database context to 'SUSDB'.
Creating PublicViewAccess Database role
Creating view PUBLIC_VIEWS.vUpdate
Creating view PUBLIC_VIEWS.vCategory
Creating view PUBLIC_VIEWS.vClassification
Creating view PUBLIC_VIEWS.vUpdateInCategory
Creating view PUBLIC_VIEWS.vLanguage
Creating view PUBLIC_VIEWS.vUpdateText
Creating view PUBLIC_VIEWS.vUpdateAdditionalInfoUrl
Creating view PUBLIC_VIEWS.vCategoryText
Creating view PUBLIC_VIEWS.vClassificationText
Creating view PUBLIC_VIEWS.vDownstreamServer
Creating view PUBLIC_VIEWS.vComputerTarget
Creating view PUBLIC_VIEWS.vComputerTargetGroup
Creating view PUBLIC_VIEWS.vComputerGroupMembership
Creating view PUBLIC_VIEWS.vUpdateApproval
Creating view PUBLIC_VIEWS.vUpdateInstallationInfoBasic
Creating view PUBLIC_VIEWS.vUpdateInstallationInfo
Creating view PUBLIC_VIEWS.vUpdateEffectiveApprovalPerComputer
Creating view PUBLIC_VIEWS.vSupportedInventory
Creating view PUBLIC_VIEWS.vComputerInventory
Creating TVF PUBLIC_VIEWS.fnUpdateInstallationStateMap
Changed database context to 'SUSDB'.
Executing string: CREATE CERTIFICATE
[MS_SchemaSigningCertificate7B0D0655F517A6AB2E4CD4BC564FAAF9966B5A88]
FROM FILE = 'C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\SchemaSig
\wsussigndb.cer'
Executing string: ALTER CERTIFICATE
[MS_SchemaSigningCertificate7B0D0655F517A6AB2E4CD4BC564FAAF9966B5A88]
ATTESTED BY 'C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\SchemaSig
\WSUSSignDb.dll'
Signing object:[dbo].[spDeployRevisionToDss]
Signing object:[dbo].[tbTargetInTargetGroup]
Signing object:[dbo].[fnGetTimeFromBlob]
Signing object:[dbo].[spFireStateMachineEvent]
Signing object:[dbo].[tbSchedule]
Signing object:[dbo].[spGetAutoDeploymentRuleByID]
Signing object:[dbo].[fnGetLocalUpdateID]
Signing object:[dbo].[tbBundleDependency]
Signing object:[dbo].[spGetNotificationEventItem]
Signing object:[dbo].[spSaveParsedExtendedProperties]
Signing object:[dbo].[tbEulaProperty]
Signing object:[dbo].[fn_CategoryGuid_to_Index]
Signing object:[dbo].[spGetNotificationEventNamesToWakeUp]
Signing object:[dbo].[spUpdateInventoryRulesXml]
Signing object:[dbo].[spGetUpdatesAndDeployments]
Signing object:[dbo].[fn_LanguageID_to_Index]
Signing object:[dbo].[tbUpdateStatusPerComputer]
Signing object:[dbo].[spGetNotificationEventNamesToWakeUpOnStartup]
Signing object:[dbo].[spAddDetailedInventoryRules]
Signing object:[dbo].[spSetAutoDeploymentRule]
Signing object:[dbo].[tbEulaAcceptance]
Signing object:[dbo].[fn_map_Index_to_Bitmask]
Signing object:[dbo].[spCleanupIntermediateFileStatesOnStartup]
Signing object:[dbo].[spGetInventoryVersion]
Signing object:[dbo].[tbEmailNotificationRecipient]
Signing object:[dbo].[spGetAutoDeploymentRuleIDs]
Signing object:[dbo].[fnGetChangeNumber]
Signing object:[dbo].[tbUpdateSummaryForAllComputers]
Signing object:[dbo].[spStartCatalogSync]
Signing object:[dbo].[spAddInventoryXml]
Signing object:[dbo].[tbRevisionInCategory]
Signing object:[dbo].[spCreateAutoDeploymentRule]
Signing object:[dbo].[tbLocalizedProperty]
Signing object:[dbo].[spGetChangeTrackingInformation]
Signing object:[dbo].[spCancelCatalogSync]
Signing object:[dbo].[spAddDetailedInventoryInformation]
Signing object:[dbo].[spDeleteAutoDeploymentRuleByID]
Signing object:[dbo].[spGetChangeTrackingNumber]
Signing object:[dbo].[spSetHandshakeAnchor]
Signing object:[dbo].[spGetUpdateListToApproveForAutoDeploymentRule]
Signing object:[dbo].[tbFile]
Signing object:[dbo].[spGetAllLanguagesWithEnabledState]
Signing object:[dbo].[spResetNotificationState]
Signing object:[dbo].[tbCategory]
Signing object:[dbo].[spGetComputersNotContactedSinceCount]
Signing object:[dbo].[spCheckConnection]
Signing object:[dbo].[spGetLocalIdList]
Signing object:[dbo].[spDeclineUpdate]
Signing object:[dbo].[spGetChangeTrackingNumbersForCache]
Signing object:[dbo].[spQueueCatalogSyncRequest]
Signing object:[dbo].[spGetParentCategories]
Signing object:[dbo].[spGetLanguageListForCache]
Signing object:[dbo].[spGetSubscriptionProgress]
Signing object:[dbo].[spSearchUpdates]
Signing object:[dbo].[tbXml]
Signing object:[dbo].[spGetRevisionIdListForCache]
Signing object:[dbo].[spSetSubscriptionProgress]
Signing object:[dbo].[spGetAllUpdates]
Signing object:[dbo].[spGetRelatedRevisionsForUpdateID]
Signing object:[dbo].[tbComputerSummaryForMicrosoftUpdates]
Signing object:[dbo].[spSetCatalogSyncFail]
Signing object:[dbo].[tbRevision]
Signing object:[dbo].[spGetUpdateCount]
Signing object:[dbo].[spGetAllUpdateIDs]
Signing object:[dbo].[spNotifySyncCancel]
Signing object:[dbo].[spGetRevisions]
Signing object:[dbo].[spGetProgramKeys]
Signing object:[dbo].[spSyncWorkDone]
Signing object:[dbo].[spGetComputerTargetByName]
Signing object:[dbo].[tbGroupAuthorization]
Signing object:[dbo].[fnCsvToInt]
Signing object:[dbo].[spGetNextQueuedSubscription]
Signing object:[dbo].[spSimpleSearchComputers]
Signing object:[dbo].[fnCsvToUniqueID]
Signing object:[dbo].[spGetSubscriptionState]
Signing object:[dbo].[spSimpleSearchUpdates]
Signing object:[dbo].[tbAuthorization]
Signing object:[dbo].[spGetCoreUpdateXml]
Signing object:[dbo].[spFixCatalogSyncStates]
Signing object:[dbo].[spGetEulaFiles]
Signing object:[dbo].[spGetLocalizedUpdateXml]
Signing object:[dbo].[spCancelFilesAndRelatedRevisions]
Signing object:[dbo].[spGetEulaAcceptances]
Signing object:[dbo].[tbFileOnServer]
Signing object:[dbo].[spGetLocaleNames]
Signing object:[dbo].
[spDeactivateDeploymentsAndNotifyParentRevisionsChildNotReady]
Signing object:[dbo].[spAcceptEula]
Signing object:[dbo].[spGetGlobalUpdates]
Signing object:[dbo].[tbRequestedTargetGroup]
Signing object:[dbo].[spCheckRevisionsNeedingFile]
Signing object:[dbo].[spAcceptEulaForReplicaDSS]
Signing object:[dbo].[spGetHardwareDrivers]
Signing object:[dbo].[spNotifyFileActualStateMUUrlNeeded]
Signing object:[dbo].[spRecurseInsertCategoriesIntoFlatTable]
Signing object:[dbo].[spGetMonitorableStatus]
Signing object:[dbo].[tbRequestedTargetGroupsForTarget]
Signing object:[dbo].[spNotifyFileActualStateDownloadNeeded]
Signing object:[dbo].[spInsertCategoriesIntoFlatTable]
Signing object:[dbo].[spGetFileLocations]
Signing object:[dbo].[spNotifyFileActualStateImportNeeded]
Signing object:[dbo].[spRepairPrecomputedTables]
Signing object:[dbo].[spGetAllTargetGroups]
Signing object:[dbo].[tbDeletedComputer]
Signing object:[dbo].[spNotifyFileActualStateNotNeeded]
Signing object:[dbo].[tbRevisionExtendedLanguageMask]
Signing object:[dbo].[spGetInstallableItems]
Signing object:[dbo].[tbFileDownloadProgress]
Signing object:[dbo].[spGetFrontEndServerInfo]
Signing object:[dbo].[spNotifyActualStateAndRevisionsFileCancelled]
Signing object:[PUBLIC_VIEWS].[fnUpdateInstallationStateMap]
Signing object:[dbo].[spGetApprovedUpdateMetadata]
Signing object:[dbo].[spSetFrontEndServerInfo]
Signing object:[dbo].[spWakeUpContentAgent]
Signing object:[dbo].[spHasApprovalsChanged]
Signing object:[dbo].[tbSingletonData]
Signing object:[dbo].[spSetFileLocationChange]
Signing object:[dbo].[tbComputerTargetDetail]
Signing object:[dbo].[spRemoveFileFromProgress]
Signing object:[dbo].[spGetUpdateByID]
Signing object:[dbo].[spGetRevisionInfo]
Signing object:[dbo].[spRemoveFileFromProgressAndWakeUpContentAgent]
Signing object:[dbo].[spGetUpdatesBundledByUpdate]
Signing object:[dbo].[spGetDeltaRevisionInfo]
Signing object:[dbo].[spNotifyRevisionsFileReady]
Signing object:[dbo].[spGetUpdatesThatBundleUpdate]
Signing object:[dbo].[spAdduser]
Signing object:[dbo].[spNotifyRevisionsFileFailed]
Signing object:[dbo].[spGetUpdatesSupersededByUpdate]
Signing object:[dbo].[spGrantAsp]
Signing object:[dbo].[spCheckFileDesiredState]
Signing object:[dbo].[spGetUpdatesThatSupersedeUpdate]
Signing object:[dbo].[tbReference]
Signing object:[dbo].[tbEventMessageTemplate]
Signing object:[dbo].[spCheckFileDownloadQueue]
Signing object:[dbo].[spGetUpdatesRequiredByUpdate]
Signing object:[dbo].[spCheckDesiredStateAndNotifyRevisionsFileReady]
Signing object:[dbo].[tbUpdate]
Signing object:[dbo].[spGetUpdatesThatRequireUpdate]
Signing object:[dbo].[tbEventInstance]
Signing object:[dbo].
[spCheckFileDownloadQueueAndNotifyRevisionsFileFailed]
Signing object:[dbo].[spGetLanguagesForUpdate]
Signing object:[dbo].[spCheckDesiredStateAndNotifyRevisionsFileFailed]
Signing object:[dbo].[spGetContentDownloadProgress]
Signing object:[dbo].[tbFrontEndServersHealth]
Signing object:[dbo].
[spNotifyRevisionsFileNotReadyAndCheckDesiredState]
Signing object:[dbo].[spCancelDownload]
Signing object:[dbo].[tbEvent]
Signing object:[dbo].
[spCheckFileDownloadQueueAndRemoveFileFromProgress]
Signing object:[dbo].[spCancelAllDownloads]
Signing object:[dbo].[tbConfigurationC]
Signing object:[dbo].[spCheckFileDownloadQueueAndDesiredState]
Signing object:[dbo].[spResumeDownload]
Signing object:[dbo].[tbComputerTarget]
Signing object:[dbo].[spUpdateQueueEntryTimeAndCheckFileDownloadQueue]
Signing object:[dbo].[spResumeAllDownloads]
Signing object:[dbo].[tbEventSource]
Signing object:[dbo].[spNotifyContentSyncNotificationEventWorking]
Signing object:[dbo].[spSetConfiguration]
Signing object:[dbo].[spGetNextContentSyncWorkItem]
Signing object:[dbo].[tbUpdateType]
Signing object:[dbo].[spSetRollupConfiguration]
Signing object:[dbo].[tbEventNamespace]
Signing object:[dbo].[spGetNextContentSyncWorkItemOnStartup]
Signing object:[dbo].[spGetResetStateMachineNeededFlag]
Signing object:[dbo].[spUpdateFileDownloadProgress]
Signing object:[dbo].[tbUpdateFlag]
Signing object:[dbo].[spDeleteDeployment]
Signing object:[dbo].[tbClientWithRecentNameChange]
Signing object:[dbo].[spDownloadFiles]
Signing object:[dbo].[spCreateImplicitDeployment]
Signing object:[dbo].[tbDownstreamServerTarget]
Signing object:[dbo].[spSetFileMUUrl]
Signing object:[dbo].[tbHandler]
Signing object:[dbo].[spUndeclineUpdate]
Signing object:[dbo].[spGetUpdatesForFile]
Signing object:[dbo].[spDeployUpdate]
Signing object:[dbo].[spRetrieveFileDigestFromRowID]
Signing object:[dbo].[fnMapPatchingTypeStringToTinyInt]
Signing object:[dbo].[tbLanguage]
Signing object:[dbo].[spGetDeploymentByID]
Signing object:[dbo].[tbDownstreamServerSummaryRollup]
Signing object:[dbo].[spNotifyEulaFilesNeeded]
Signing object:[dbo].[fnGetNextDailyRunTime]
Signing object:[dbo].[spGetDeploymentsForAnUpdate]
Signing object:[dbo].[spImportEventNamespaceDescriptor]
Signing object:[dbo].[spCheckRevisionInstallationPossibility]
Signing object:[dbo].[fnGetNextEmailNotificationTime]
Signing object:[dbo].[spGetDeployments]
Signing object:[dbo].[spAutoPurgeReportingEvents]
Signing object:[dbo].[tbDownstreamServerClientSummaryRollup]
Signing object:[dbo].
[spNotifyParentsEulasReadyAndCheckRevisionInstallationPossibility]
Signing object:[dbo].[fn_GetGrade]
Signing object:[dbo].[spRefreshDeployments]
Signing object:[dbo].[spLoadReportingEventAttributes]
Signing object:[dbo].
[spCheckRevisionNeededAndNotifyParentsChildInstallationPossible]
Signing object:[dbo].[fnGetOnlineSummaryFlags]
Signing object:[dbo].[spGetSubscription]
Signing object:[dbo].[tbLocaleMap]
Signing object:[dbo].[spAddDownstreamServerToTargetGroup]
Signing object:[dbo].[spUpdateChangeTrackingNumber]
Signing object:[dbo].[spGetSubscriptionCategories]
Signing object:[dbo].[spPreregisterDownstreamServer]
Signing object:[dbo].[trOnUpdatingConfigurationC]
Signing object:[dbo].[tbCategoryType]
Signing object:[dbo].[spGetSubscriptionNextSynchronizationTime]
Signing object:[dbo].[tbOSMap]
Signing object:[dbo].[spGetDssTargetGroup]
Signing object:[dbo].[trOnUpdatingConfigurationB]
Signing object:[dbo].[spSetSubscription]
Signing object:[dbo].[spUpdateDownstreamServerID]
Signing object:[dbo].[trOnUpdatingConfigurationA]
Signing object:[dbo].[tbStateMachine]
Signing object:[dbo].[spSetSubscriptionLastRunTime]
Signing object:[dbo].[tbDownstreamServerRollupConfiguration]
Signing object:[dbo].[tbDownstreamServerClientActivityRollup]
Signing object:[dbo].
[spReturnStateMachineTransitionEventLogEntriesFromError]
Signing object:[dbo].[trOnUpdatingConfiguration]
Signing object:[dbo].[spSetScheduleFrequency]
Signing object:[dbo].[spCheckFilesAndChildRevisionsReady]
Signing object:[dbo].[trOnInsertingUpdateStatus]
Signing object:[dbo].[tbStateMachineState]
Signing object:[dbo].[spSetSubscriptionDeploymentAnchor]
Signing object:[dbo].[tbEventRollupCounters]
Signing object:[dbo].[tbTarget]
Signing object:[dbo].[spNotifyFilesAndChildRevisionsNeeded]
Signing object:[dbo].[trOnDeletingUpdateStatus]
Signing object:[dbo].[spSetSubscriptionAnchor]
Signing object:[dbo].
[spActivateDeploymentsAndNotifyParentRevisionsChildReady]
Signing object:[dbo].[trOnUpdatingUpdateStatus]
Signing object:[dbo].[spGetTargetGroupByID]
Signing object:[dbo].[fnFindOsID]
Signing object:[dbo].[spFailParentRevisions]
Signing object:[dbo].[trOnAddingCategory]
Signing object:[dbo].[tbStateMachineEvent]
Signing object:[dbo].[spGetTargetGroupForComputer]
Signing object:[dbo].[fnGetSummarizationState]
Signing object:[dbo].[tbTargetType]
Signing object:[dbo].[spCheckEulasAndChildRevisionsReady]
Signing object:[dbo].[trOnUpdatingCategory]
Signing object:[dbo].[spGetTargetGroupsForComputer]
Signing object:[dbo].[fnGetEffectiveDeployment]
Signing object:[dbo].[spDeactivateDeploymentsNotifyFilesNotNeeded]
Signing object:[dbo].[trExpandCategoryInSubscription]
Signing object:[dbo].[spGetChildTargetGroups]
Signing object:[dbo].[fnGetTargetGroupIDForComputer]
Signing object:[dbo].[tbDeployment]
Signing object:[dbo].[spResetStateMachineAndReEvaluate]
Signing object:[dbo].[fn_GetBestRevisionForEvaluateDeployment]
Signing object:[dbo].[tbStateMachineTransition]
Signing object:[dbo].[spGetParentTargetGroup]
Signing object:[dbo].[spAddReportingEventBatch]
Signing object:[dbo].[spCancelAllNotReadyRevisions]
Signing object:[dbo].[spMoveEvaluateDeploymentsAsNeeded]
Signing object:[dbo].[spCreateTargetGroup]
Signing object:[dbo].[spProcessActivityEvents]
Signing object:[dbo].[spDownloadAllNotNeededRevisions]
Signing object:[dbo].[spDeleteUneededPrerequisiteDeployments]
Signing object:[dbo].[tbStateMachineEventTransitionLog]
Signing object:[dbo].[spDeleteTargetGroup]
Signing object:[dbo].[spAddReportingEventInternal]
Signing object:[dbo].[spWakeUpResetAgent]
Signing object:[dbo].[spDeleteUneededBundleDeployments]
Signing object:[dbo].[spAddTargetToTargetGroup]
Signing object:[dbo].[spAddUpdateStatusEventBatch]
Signing object:[dbo].[spWakeUpEmailNotificationAgent]
Signing object:[dbo].[spProcessPrerequisitesForRevision]
Signing object:[dbo].[spRemoveTargetFromTargetGroup]
Signing object:[dbo].[spHandleClientRebootedEvent]
Signing object:[dbo].[spNotifyResetAgentNotificationEventWorking]
Signing object:[dbo].[trOnUpdatingRevision]
Signing object:[dbo].[spGetAllComputers]
Signing object:[dbo].[spUpdateLatestRollupEventTime]
Signing object:[dbo].[spNotifyResetAgentNotificationEventDone]
Signing object:[dbo].[trOnUpdatingDeployment]
Signing object:[dbo].[tbNotificationEvent]
Signing object:[dbo].[spSearchComputers]
Signing object:[dbo].[spGetCurrentSqlServerTime]
Signing object:[dbo].[spWakeUpRollupAgent]
Signing object:[dbo].[trOnAddingDeployment]
Signing object:[dbo].[spGetComputerCount]
Signing object:[dbo].[spGetLatestRollupEventTime]
Signing object:[dbo].[spNotifyRollupAgentNotificationEventWorking]
Signing object:[dbo].[trOnDeletingDeployment]
Signing object:[dbo].[tbChangeTracking]
Signing object:[dbo].[spGetAllDownstreamServers]
Signing object:[dbo].[spUpdateCurrentRollupState]
Signing object:[dbo].[spNotifyRollupAgentNotificationEventDone]
Signing object:[dbo].[trAdjustIsLeaf_reduce]
Signing object:[dbo].[spGetInventoryItemsForComputer]
Signing object:[dbo].[spGetCurrentRollupState]
Signing object:[dbo].
[spNotifyEmailNotificationAgentNotificationEventWorking]
Signing object:[dbo].[trExpandRevisionInCategory]
Signing object:[dbo].[tbFlattenedRevisionInCategory]
Signing object:[dbo].[spGetInventorySummary]
Signing object:[dbo].[spGetRollupCounter]
Signing object:[dbo].
[spNotifyEmailNotificationAgentNotificationEventDone]
Signing object:[dbo].[trExpandFlattenedRevisionInCategory]
Signing object:[dbo].[spGetComputersHavingInventoryItem]
Signing object:[dbo].[spUpdateRollupCounter]
Signing object:[dbo].[spSaveUssHostOnMU]
Signing object:[dbo].[trExpandRevisionLanguage]
Signing object:[dbo].[tbServerSyncResult]
Signing object:[dbo].[spGetComputersInTargetGroup]
Signing object:[dbo].[spSetLastRollupInfo]
Signing object:[dbo].[tbDeadDeployment]
Signing object:[dbo].[spRetrieveUssHostOnMU]
Signing object:[dbo].[trAdjustIsLeaf_increase]
Signing object:[dbo].[spAddComputerToTargetGroup]
Signing object:[dbo].[spGetLastRollupInfo]
Signing object:[dbo].[spGetLastServerSyncCookie]
Signing object:[dbo].[trOnAddingUpdatingGroupAuthorization]
Signing object:[dbo].[tbPreComputedLocalizedProperty]
Signing object:[dbo].[spAddComputerToTargetGroupAllowMultipleGroups]
Signing object:[dbo].[spResetOnlineSummaryTables]
Signing object:[dbo].[spSetLastServerSyncCookie]
Signing object:[dbo].[trOnDeletingGroupAuthorization]
Signing object:[dbo].[spRemoveComputerFromTargetGroup]
Signing object:[dbo].[tbConfigurationB]
Signing object:[dbo].[spGetComputersToRollup]
Signing object:[dbo].[spResetServer]
Signing object:[dbo].[trOnAddingUpdatingAuthorization]
Signing object:[dbo].[tbPrecomputedCategoryLocalizedProperty]
Signing object:[dbo].[spGetDownstreamServersInTargetGroup]
Signing object:[dbo].[spMarkComputersAsNeedingFullComputerRollup]
Signing object:[dbo].[spGetLastSyncTime]
Signing object:[dbo].[trOnDeletingAuthorization]
Signing object:[dbo].[spCreateTargetEntry]
Signing object:[dbo].[spUpdateComputersAfterRollup]
Signing object:[dbo].[spSetLastSyncTime]
Signing object:[dbo].[trOnAddingLanguage]
Signing object:[dbo].[tbAutoDeploymentRule]
Signing object:[dbo].[spPreregisterComputer]
Signing object:[dbo].[spAddRollupComputers]
Signing object:[dbo].[tbRevisionLanguage]
Signing object:[dbo].[spIsRegistrationRequired]
Signing object:[dbo].[trOnChangingLanguage]
Signing object:[dbo].[spGetComputerByID]
Signing object:[dbo].[spGetComputerLastRollupNumbers]
Signing object:[dbo].[spGetComputerTargetGroup]
Signing object:[dbo].[trOnDeletingLanguage]
Signing object:[dbo].[spGetDownstreamServer]
Signing object:[dbo].[spGetOutOfSyncComputers]
Signing object:[dbo].[spCheckForClientNameChange]
Signing object:[dbo].[trOnAddingDriver]
Signing object:[dbo].[spDeleteComputer]
Signing object:[dbo].[spMarkComputersAsNeedingFullStatusRollup]
Signing object:[dbo].[tbProperty]
Signing object:[dbo].[spGetFrontEndServers]
Signing object:[dbo].[trOnDeletingDriver]
Signing object:[dbo].[tbUpdateClassificationInAutoDeploymentRule]
Signing object:[dbo].[spDeleteDownstreamServer]
Signing object:[dbo].[spGetComputerStatusToRollup]
Signing object:[dbo].[spRemoveFrontEndServer]
Signing object:[dbo].[trOnAddingComputerTarget]
Signing object:[dbo].[spSearchEventHistory]
Signing object:[dbo].[spUpdateComputerStatusAfterRollup]
Signing object:[dbo].[spGetClientsWithRecentNameChange]
Signing object:[dbo].[trOnDeletingComputerTarget]
Signing object:[dbo].[tbCategoryInAutoDeploymentRule]
Signing object:[dbo].[spPurgeReportingEvents]
Signing object:[dbo].[spAddRollupStatus]
Signing object:[dbo].[spGetComputerTargetGroupEx]
Signing object:[dbo].[trOnUpdatingComputerTarget]
Signing object:[dbo].[spGetComponentsWithErrors]
Signing object:[dbo].[spAddRollupStatusNoStatus]
Signing object:[dbo].[spRegisterComputer]
Signing object:[dbo].[tr_insert_ExpandedTargetInTargetGroup]
Signing object:[dbo].[tbTargetGroupInAutoDeploymentRule]
Signing object:[dbo].[spGetUpdateServerStatus]
Signing object:[dbo].[spMarkDataForFullRollup]
Signing object:[dbo].[tbRevisionExtendedProperty]
Signing object:[dbo].[spSetBatchURL]
Signing object:[dbo].[tr_delete_ExpandedTargetInTargetGroup]
Signing object:[dbo].[spGetDownstreamServerRollupSummary]
Signing object:[dbo].[fnMapLocalUpdateIDToGlobal]
Signing object:[dbo].[spUpdateServerHealthStatus]
Signing object:[dbo].[fn_mapRevisionIDtoUpdateType]
Signing object:[dbo].[tbSchemaVersion]
Signing object:[dbo].[spGetXmlForUpdate]
Signing object:[dbo].[fnMapGlobalToLocalUpdateID]
Signing object:[dbo].[tbKBArticleForRevision]
Signing object:[dbo].[spGetExportData]
Signing object:[dbo].[fn_calculate_driverVersion]
Signing object:[dbo].[spGetPreviousRevision]
Signing object:[dbo].[fnHasStaleDeployments]
Signing object:[dbo].[spGetExportUpdateData]
Signing object:[dbo].[fn_later_date]
Signing object:[dbo].[spGetLatestRevisionNumberForUpdate]
Signing object:[dbo].[fnHasSupersededUpdates]
Signing object:[dbo].[tbMoreInfoURLForRevision]
Signing object:[dbo].[spGetDataForSyncPackage]
Signing object:[dbo].[fn_revisionID_to_localUpdateID]
Signing object:[dbo].[tbServerHealth]
Signing object:[dbo].[spGetSdpXmlForUpdate]
Signing object:[dbo].[fnIsEulaAcceptanceRequired]
Signing object:[dbo].[spGetBundedByDataForSyncPackage]
Signing object:[dbo].[fn_revisionID_to_GlobalUpdateID]
Signing object:[dbo].[spGetEmailNotificationConfiguration]
Signing object:[dbo].[fnGetTargetGroupTypeID]
Signing object:[dbo].[spGetUpdateDataForSyncPackage]
Signing object:[dbo].[fn_map_Impact]
Signing object:[dbo].[spSetEmailNotificationConfiguration]
Signing object:[dbo].[fnGetComputerTargetID]
Signing object:[dbo].[tbSecurityBulletinForRevision]
Signing object:[dbo].[spGetUpdateTypeByRevisionID]
Signing object:[dbo].[fnGetWeightFromImpact]
Signing object:[dbo].[tbProgramKeys]
Signing object:[dbo].[spGetEmailNotificationStatus]
Signing object:[dbo].[fnGetLatestRevisionNumber]
Signing object:[dbo].[spEnableReplica]
Signing object:[dbo].[fnGetImpact]
Signing object:[dbo].[spSetEmailNotificationStatus]
Signing object:[dbo].[fnIsInReplicaMode]
Signing object:[dbo].[tbLocalizedPropertyForRevision]
Signing object:[dbo].[spGetAllExplicitComputerDeployments]
Signing object:[dbo].[fn_map_RebootBehavior]
Signing object:[dbo].[tbComputersThatNeedDetailedRollup]
Signing object:[dbo].[spScheduleEmailNotification]
Signing object:[dbo].[spGetUpdatesForBulkHideInReplicaSync]
Signing object:[dbo].[fnGetRebootBehavior]
Signing object:[dbo].[spGetEmailsToNotify]
Signing object:[dbo].[tbFileForRevision]
Signing object:[dbo].[spDeleteRevision]
Signing object:[dbo].[fnGetWeightFromBehavior]
Signing object:[dbo].[spGetEmailNotificationRecipients]
Signing object:[dbo].[spGetCompressionThesholds]
Signing object:[dbo].[fn_base40ToBinary]
Signing object:[dbo].[spAddEmailNotificationRecipient]
Signing object:[dbo].[spGetUpdatesWithPermanantlyInactiveDeployments]
Signing object:[dbo].[spSaveXmlFragment]
Signing object:[dbo].[spAddConstraint]
Signing object:[dbo].[spDeclineSupersededUpdates]
Signing object:[dbo].[tbRevisionSupersedesUpdate]
Signing object:[dbo].
[spDeleteDeploymentsForUpdatesWithPermanantlyInactiveDeployments]
Signing object:[dbo].[spGetChildCategories]
Signing object:[dbo].[spDeclineExpiredUpdates]
Signing object:[dbo].[tbConfigurationA]
Signing object:[dbo].[spSetUpdateFlagCatalogSite]
Signing object:[dbo].[spGetUssDeployments]
Signing object:[dbo].[spCountObsoleteUpdatesToCleanup]
Signing object:[dbo].[tbInstalledUpdateSufficientForPrerequisite]
Signing object:[dbo].[spGetUpdatesWithCatalogSiteFlag]
Signing object:[dbo].[spUpdateSubTimestamp]
Signing object:[dbo].[spGetObsoleteUpdatesToCleanup]
Signing object:[dbo].[spMarkComputerAsNeedingDetailedRollup]
Signing object:[dbo].[spPopulateLanguageInSubscription]
Signing object:[dbo].[spDeleteUpdate]
Signing object:[dbo].[tbBundleAtLeastOne]
Signing object:[dbo].[spMarkComputerAsDeletedForDss]
Signing object:[dbo].[spAddNewLanguage]
Signing object:[dbo].[spDeleteUpdateByUpdateID]
Signing object:[dbo].[fnTbUpdateTypeNamesToGet]
Signing object:[dbo].[spUpdateDownstreamServerTarget]
Signing object:[dbo].[spCheckRevisionExists]
Signing object:[dbo].[spCountUpdatesToCompress]
Signing object:[dbo].[tbBundleAll]
Signing object:[dbo].[spUpdateDownstreamServerSummaryRollup]
Signing object:[dbo].[spCheckUpdateExists]
Signing object:[dbo].[spGetUpdatesToCompress]
Signing object:[dbo].[fnTbComputersInTargetGroup]
Signing object:[dbo].[spUpdateDownstreamServerClientSummaryRollup]
Signing object:[dbo].[spGetFilter]
Signing object:[dbo].[spCompressUpdate]
Signing object:[dbo].[spFilterUpdatesByScopeInternal]
Signing object:[dbo].[tbPrerequisite]
Signing object:[dbo].[spUpdateDownstreamServerClientActivityRollup]
Signing object:[dbo].[spCheckFileExists]
Signing object:[dbo].[spCleanupObsoleteComputers]
Signing object:[dbo].[spGetCategories]
Signing object:[dbo].[spGetDownstreamServerClientSummaries]
Signing object:[dbo].[spUpdateOnlineSummaryTablesForUpdateVisible]
Signing object:[dbo].[spCleanupUnneededContentFiles]
Signing object:[dbo].[spGetTopLevelCategories]
Signing object:[dbo].[tbDriver]
Signing object:[dbo].[spClearAllClientActivityCounts]
Signing object:[dbo].[spUpdateOnlineSummaryTablesForUpdateNotVisible]
Signing object:[dbo].[spGetFailedToDownloadUpdatesCount]
Signing object:[dbo].[spGetCategoryPropertiesByID]
Signing object:[dbo].[spGetClientSummaryForAllServers]
Signing object:[dbo].[spImportUpdate]
Signing object:[dbo].[tbInventoryRule]
Signing object:[dbo].[spGetSubCategoriesByUpdateID]
Signing object:[dbo].[tbCompatiblePrinterProvider]
Signing object:[dbo].[spGetClientActivityForAllServers]
Signing object:[dbo].[spDeploymentAutomation]
Signing object:[dbo].[spGetUpdatesUnderACategory]
Signing object:[dbo].[spSetLastTimeReportToMU]
Signing object:[dbo].[spSetInitialDeploymentStatus]
Signing object:[dbo].[tbInventoryClass]
Signing object:[dbo].[spGetTotalSummary]
Signing object:[dbo].[tbDriverClass]
Signing object:[dbo].[spGetLastTimeReportToMU]
Signing object:[dbo].[spImportUpdateForServerSync]
Signing object:[dbo].[spGetSummariesPerComputer]
Signing object:[dbo].[spGetTempContentCache]
Signing object:[dbo].[fn_FormatError]
Signing object:[dbo].[spGetSummariesPerUpdate]
Signing object:[dbo].[tbTargetGroup]
Signing object:[dbo].
[spPopulateMissingExpandedUpdateContentThrottlingInfo]
Signing object:[dbo].[fn_FormatLog]
Signing object:[dbo].[tbInventoryProperty]
Signing object:[dbo].[spGetTotalUpdateSummaryForTargetGroup]
Signing object:[dbo].[spSetStringInContextInfo]
Signing object:[dbo].[fn_BuildDeploymentMessage]
Signing object:[dbo].[spGetUpdateSummariesForTargetGroup]
Signing object:[dbo].[spGetStringFromContextInfo]
Signing object:[dbo].[spSelectProcFortbNotificationEvent]
Signing object:[dbo].[tbInventoryXml]
Signing object:[dbo].[tbConfiguration]
Signing object:[dbo].[spGetTotalSummaryForComputer]
Signing object:[dbo].[spSetOfflineSyncExclusionList]
Signing object:[dbo].[spUpdateProcFortbNotificationEvent]
Signing object:[dbo].[spGetComputerSummariesForTargetGroup]
Signing object:[dbo].
[spGetEncryptedProxyPasswordFromDatabaseForUpgrade]
Signing object:[dbo].[spSelectProcFortbSubscription]
Signing object:[dbo].[tbImplicitCategory]
Signing object:[dbo].[spGetTargetGroupSummariesForUpdate]
Signing object:[dbo].[tbFlattenedTargetGroup]
Signing object:[dbo].[fnGetConfigurationValue]
Signing object:[dbo].[spUpdateProcFortbSubscription]
Signing object:[dbo].[tbInventoryClassInstance]
Signing object:[dbo].[spGetUpdateSummaryForSingleTargetGroup]
Signing object:[dbo].[spSelectProcFortbRevision]
Signing object:[dbo].[spGetTotalSummaryForCategory]
Signing object:[dbo].[tr_insert_tbTargetGroup]
Signing object:[dbo].[spConfiguration]
Signing object:[dbo].[spUpdateProcFortbRevision]
Signing object:[dbo].[tbInventoryPropertyInstance]
Signing object:[dbo].[spGetUpdateSummariesForCategory]
Signing object:[dbo].[tbTargetGroupType]
Signing object:[dbo].[spGetUpstreamServerInfo]
Signing object:[dbo].[spDropForeignKeyConstraint]
Signing object:[dbo].[spSelectProcFortbFileOnServerDesired]
Signing object:[dbo].[tbCategoryInSubscription]
Signing object:[dbo].[spGetComputerSummariesForCategory]
Signing object:[dbo].[spGetUpdateXmlFromRevision]
Signing object:[dbo].[spDropTableColumnIfExists]
Signing object:[dbo].[spUpdateProcFortbFileOnServerDesired]
Signing object:[dbo].[spGetUpdateInstallationInfoForUpdate]
Signing object:[dbo].[tbExpandedTargetInTargetGroup]
Signing object:[dbo].[fnGetFullMaskFromFilter]
Signing object:[dbo].[spAddTableColumnIfNotExists]
Signing object:[dbo].[spSelectProcFortbFileOnServerActual]
Signing object:[dbo].[tbLanguageInSubscription]
Signing object:[dbo].[spGetUpdateInstallationInfoForComputer]
Signing object:[dbo].[fnGetAnchorFromBlob]
Signing object:[dbo].[spDropPrimaryKeyConstraint]
Signing object:[dbo].[spUpdateProcFortbFileOnServerActual]
Signing object:[dbo].[spGetUpdateInstallationInfoForTargetGroup]
Signing object:[dbo].[tr_update_tbExpandedTargetInTargetGroup]
Signing object:[dbo].[fnMakeAnchorBlob]
Signing object:[dbo].[tbPrerequisiteDependency]
Signing object:[dbo].[spFireStateMachineEventEx]
Changed database context to 'SUSDB'.

Running a transacted installation.

Beginning the Install phase of the installation.
See the contents of the log file for the C:\Program Files\Update
Services\Setup\bin\Microsoft.UpdateServices.Setup.CustomActions.dll
assembly's progress.
The file is located at C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log.
Installing assembly 'C:\Program Files\Update Services\Setup\bin
\Microsoft.UpdateServices.Setup.CustomActions.dll'.
Affected parameters are:
categorymessagefile = C:\Program Files\Update Services\Common
\EventCategories.dll
logtoconsole =
assemblypath = C:\Program Files\Update Services\Setup\bin
\Microsoft.UpdateServices.Setup.CustomActions.dll
showcallstack =
logfile = C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log
wsusinstall =
Creating performance counter category WSUS: Reporting Web Service.
Creating performance counter category WSUS: Client Web Service.
Creating performance counter category WSUS: Client Web Service
Methods.
Creating performance counter category WSUS: Server Web Service.
Creating performance counter category WSUS: Server Web Methods.
Creating performance counter category WSUS: Update Regulation Web
Methods.
Creating performance counter category WSUS: API Remoting Web Service.
Creating EventLog source Windows Server Update Services in log
Application...

The Install phase completed successfully, and the Commit phase is
beginning.
See the contents of the log file for the C:\Program Files\Update
Services\Setup\bin\Microsoft.UpdateServices.Setup.CustomActions.dll
assembly's progress.
The file is located at C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log.
Committing assembly 'C:\Program Files\Update Services\Setup\bin
\Microsoft.UpdateServices.Setup.CustomActions.dll'.
Affected parameters are:
categorymessagefile = C:\Program Files\Update Services\Common
\EventCategories.dll
logtoconsole =
assemblypath = C:\Program Files\Update Services\Setup\bin
\Microsoft.UpdateServices.Setup.CustomActions.dll
showcallstack =
logfile = C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log
wsusinstall =

The Commit phase completed successfully.

The transacted install has completed.

Running a transacted installation.

Beginning the Install phase of the installation.
See the contents of the log file for the C:\Program Files\Update
Services\Service\bin\WsusService.exe assembly's progress.
The file is located at C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log.
Installing assembly 'C:\Program Files\Update Services\Service\bin
\WsusService.exe'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Program Files\Update Services\Service\bin
\WsusService.exe
showcallstack =
logfile = C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log
Installing service WSUSService...
Service WSUSService has been successfully installed.
Creating EventLog source WSUSService in log Application...

The Install phase completed successfully, and the Commit phase is
beginning.
See the contents of the log file for the C:\Program Files\Update
Services\Service\bin\WsusService.exe assembly's progress.
The file is located at C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log.
Committing assembly 'C:\Program Files\Update Services\Service\bin
\WsusService.exe'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Program Files\Update Services\Service\bin
\WsusService.exe
showcallstack =
logfile = C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log

The Commit phase completed successfully.

The transacted install has completed.
StartServer starting...
UpgradeConfigurationSettings failed. Exception:
System.Data.SqlClient.SqlException: Cannot open database "SUSDB"
requested by the login. The login failed.
Login failed for user 'PHILA\hnguyen'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj)
at
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, 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.UpdateServices.DatabaseAccess.DBConnection.Connect(String
connectionString)
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.Connect()
at
Microsoft.UpdateServices.Internal.DataAccess.HandleProxyPasswordOnUpgrade()
at
Microsoft.UpdateServices.Setup.StartServer.StartServer.UpgradeConfigurationSettings()
StartServer encountered errors. Exception=Cannot open database "SUSDB"
requested by the login. The login failed.
Login failed for user 'PHILA\hnguyen'.

The uninstall is beginning.
See the contents of the log file for the C:\Program Files\Update
Services\Service\bin\WsusService.exe assembly's progress.
The file is located at C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log.
Uninstalling assembly 'C:\Program Files\Update Services\Service\bin
\WsusService.exe'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Program Files\Update Services\Service\bin
\WsusService.exe
showcallstack =
logfile = C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log
Removing EventLog source WSUSService.
Service WSUSService is being removed from the system...
Service WSUSService was successfully removed from the system.

The uninstall has completed.

The uninstall is beginning.
See the contents of the log file for the C:\Program Files\Update
Services\Setup\bin\Microsoft.UpdateServices.Setup.CustomActions.dll
assembly's progress.
The file is located at C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log.
Uninstalling assembly 'C:\Program Files\Update Services\Setup\bin
\Microsoft.UpdateServices.Setup.CustomActions.dll'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Program Files\Update Services\Setup\bin
\Microsoft.UpdateServices.Setup.CustomActions.dll
showcallstack =
logfile = C:\DOCUME~1\HNGUYE~1.PHI\LOCALS~1\Temp
\1\WSUSCa_080403_1610.log
wsusinstall =
Removing performance counter category WSUS: API Remoting Web Service.
Removing performance counter category WSUS: Update Regulation Web
Methods.
Removing performance counter category WSUS: Server Web Methods.
Removing performance counter category WSUS: Server Web Service.
Removing performance counter category WSUS: Client Web Service
Methods.
Removing performance counter category WSUS: Client Web Service.
Removing performance counter category WSUS: Reporting Web Service.

The uninstall has completed.
Changed database context to 'master'.

[Lawrence Garvin [MVP]]

<HNguy...@gmail.com> wrote in message
news:3841d4b1-1a4a-441f...@a70g2000hsh.googlegroups.com...

> I have WSUS 2.0 SP1 installed and I've tried upgrading to WSUS 3.0 two
> times already. Both times have failed. I've had to reinstall WSUS
> 2.0 and recover the DB. I'm thinking about just uninstalling WSUS 2.0
> and install a fresh copy of WSUS 3.0 and start from scratch, if this
> doesn't work. Can someone please take a look at the logs and
> determine what is causing my problem?

> Revoked login access from 'CITYHALL\WSUS Administrators'.

I presume CITYHALL is the WSUS Server machinename (since "WSUS
Administrators" is a local group)...

> System.Data.SqlClient.SqlException: Cannot open database "SUSDB"
> requested by the login. The login failed.
> Login failed for user 'PHILA\hnguyen'.

So, this must be your DOMAIN account<???>

Is this DOMAIN account a member of the LOCAL Administrators group on machine
CITYHALL?

--
Lawrence Garvin, M.S., MCITP, MCBMSP, MCTS(x4), MCP
Senior Data Architect, APQC, Houston, Texas
Microsoft MVP - Software Distribution (2005-2008)

MS WSUS Website: http://www.microsoft.com/wsus
My Websites: http://www.onsitechsolutions.com;
http://wsusinfo.onsitechsolutions.com
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin

[HNguy...@gmail.com]

Yes, the account is my domain account and it is a member of the local
administrators group.

[HNguy...@gmail.com]

Any ideas anyone?

On Apr 4, 7:55 pm, "Lawrence Garvin [MVP]" <ons...@postalias.news>
wrote:
> <HNguyen1...@gmail.com> wrote in message