WSUS Post-deployment Configuration Failed

server 2012

i'm doing basic install of wsus on member server s drive, post error below:

2013-03-11 14:10:07  postinstall started
2013-03-11 14:10:07  detected role services: api, ui, widdatabase, services
2013-03-11 14:10:07  start: loadsettingsfromxml
2013-03-11 14:10:07  start: getconfigvalue filename=updateservices-services.xml item=contentlocal
2013-03-11 14:10:07  value true
2013-03-11 14:10:07  end: getconfigvalue
2013-03-11 14:10:07  start: getconfigvalue filename=updateservices-services.xml item=contentdirectory
2013-03-11 14:10:07  value s:\wsus
2013-03-11 14:10:07  end: getconfigvalue
2013-03-11 14:10:07  content directory s:\wsus
2013-03-11 14:10:07  database roleservice not installed
2013-03-11 14:10:07  end: loadsettingsfromxml
post install starting
2013-03-11 14:10:07  start: run
2013-03-11 14:10:07  configuring content directory...
2013-03-11 14:10:07  configuring groups...
2013-03-11 14:10:08  starting group configuration wsus administrators...
2013-03-11 14:10:08  found group in regsitry, attempting use it...
2013-03-11 14:10:10  writing group registry...
2013-03-11 14:10:10  finished group creation
2013-03-11 14:10:10  starting group configuration wsus reporters...
2013-03-11 14:10:10  found group in regsitry, attempting use it...
2013-03-11 14:10:10  writing group registry...
2013-03-11 14:10:10  finished group creation
2013-03-11 14:10:10  configuring permissions...
2013-03-11 14:10:10  fetching content directory...
2013-03-11 14:10:10  fetching contentdir registry store
2013-03-11 14:10:10  value s:\wsus
2013-03-11 14:10:10  fetching group sids...
2013-03-11 14:10:10  fetching wsusadministratorssid registry store
2013-03-11 14:10:10  value s-1-5-21-2610565223-164225667-3587587312-1002
2013-03-11 14:10:10  fetching wsusreporterssid registry store
2013-03-11 14:10:10  value s-1-5-21-2610565223-164225667-3587587312-1003
2013-03-11 14:10:10  creating group principals...
2013-03-11 14:10:10  granting directory permissions...
2013-03-11 14:10:10  granting permissions on content directory...
2013-03-11 14:10:10  granting registry permissions...
2013-03-11 14:10:10  granting registry permissions...
2013-03-11 14:10:10  granting registry permissions...
2013-03-11 14:10:10  configuring shares...
2013-03-11 14:10:10  configuring network shares...
2013-03-11 14:10:10  fetching content directory...
2013-03-11 14:10:10  fetching contentdir registry store
2013-03-11 14:10:10  value s:\wsus
2013-03-11 14:10:10  fetching wsus admin sid...
2013-03-11 14:10:10  fetching wsusadministratorssid registry store
2013-03-11 14:10:10  value s-1-5-21-2610565223-164225667-3587587312-1002
2013-03-11 14:10:10  content directory local, creating content shares...
2013-03-11 14:10:11  creating share "updateservicespackages" path "s:\wsus\updateservicespackages" , description "a network share used client systems collecting software packages (usually applications) published on wsus system."
2013-03-11 14:10:11  deleting existing share...
2013-03-11 14:10:11  creating share...
2013-03-11 14:10:11  share created
2013-03-11 14:10:11  creating share "wsuscontent" path "s:\wsus\wsuscontent" , description "a network share used local publishing place published content on wsus system."
2013-03-11 14:10:11  deleting existing share...
2013-03-11 14:10:11  creating share...
2013-03-11 14:10:11  share created
2013-03-11 14:10:11  creating share "wsustemp" path "c:\program files\update services\logfiles\wsustemp" , description "a network share used local publishing remote wsus console instance."
2013-03-11 14:10:11  deleting existing share...
2013-03-11 14:10:11  creating share...
2013-03-11 14:10:11  share created
2013-03-11 14:10:11  finished creating content shares
2013-03-11 14:10:11  configuring wid database...
2013-03-11 14:10:11  configuring database...
2013-03-11 14:10:11  establishing db connection...
2013-03-11 14:10:12  checking see if database exists...
2013-03-11 14:10:13  database exists
2013-03-11 14:10:13  switching database single user mode...
2013-03-11 14:10:13  loading install type query...
2013-03-11 14:10:13  declare @currentscriptversion   int
declare @currentdbversion       int
if not exists(select * sys.databases name='susdb')
begin
    select 1
end
else
begin
    set @currentscriptversion = (9200 + 16384)
    set @currentdbversion = (select schemaversion susdb.dbo.tbschemaversion componentname = 'coredb')
    if @currentdbversion < 926
    begin
        select 3
    end
    else if @currentdbversion < @currentscriptversion
    begin
        select 2
    end
    else if @currentdbversion = @currentscriptversion
    begin
        select 0
    end
    else
    begin
        select 4
    end
end

2013-03-11 14:10:13  system.data.sqlclient.sqlexception (0x80131904): invalid object name 'susdb.dbo.tbschemaversion'.
   @ microsoft.updateservices.databaseaccess.dbconnection.drainobsoleteconnections(sqlexception e)
   @ microsoft.updateservices.databaseaccess.dbconnection.executegetsingleresult()
   @ microsoft.updateservices.administration.configuredb.getinstalltype()
   @ microsoft.updateservices.administration.configuredb.connecttodb()
   @ microsoft.updateservices.administration.configuredb.configure()
   @ microsoft.updateservices.administration.postinstall.run()
   @ microsoft.updateservices.administration.postinstall.execute(string[] arguments)
clientconnectionid:76f6ee2d-1ffb-4e49-98ea-0fc57758f6b7
fatal error: invalid object name 'susdb.dbo.tbschemaversion'.

can point me in right direction, thanks!

others have solved by opening iis manager , deleting old wsus web site, running complete wsus installation again.

see http://social.technet.microsoft.com/forums/en-us/winserverwsus/thread/91e45363-bbf7-414a-8932-779b1c170c3e

ian broadbent

Windows Server  >  WSUS