USDB.dbo.tbSchemaVersion

2013-07-02 13:22:40  postinstall started
2013-07-02 13:22:40  detected role services: api, ui, widdatabase, services
2013-07-02 13:22:40  start: loadsettingsfromparameters
2013-07-02 13:22:40  content local is: true
2013-07-02 13:22:40  content directory is: c:\wsus
2013-07-02 13:22:40  sql instname is:
2013-07-02 13:22:40  end: loadsettingsfromparameters
2013-07-02 13:22:40  start: run
2013-07-02 13:22:40  configuring content directory...
2013-07-02 13:22:40  configuring groups...
2013-07-02 13:22:40  starting group configuration wsus administrators...
2013-07-02 13:22:40  found group in regsitry, attempting use it...
2013-07-02 13:22:43  writing group registry...
2013-07-02 13:22:43  finished group creation
2013-07-02 13:22:43  starting group configuration wsus reporters...
2013-07-02 13:22:43  found group in regsitry, attempting use it...
2013-07-02 13:22:43  writing group registry...
2013-07-02 13:22:43  finished group creation
2013-07-02 13:22:43  configuring permissions...
2013-07-02 13:22:43  fetching content directory...
2013-07-02 13:22:43  fetching contentdir registry store
2013-07-02 13:22:43  value c:\wsus
2013-07-02 13:22:43  fetching group sids...
2013-07-02 13:22:43  fetching wsusadministratorssid registry store
2013-07-02 13:22:43  value s-1-5-21-3128221918-321857698-959514307-1001
2013-07-02 13:22:43  fetching wsusreporterssid registry store
2013-07-02 13:22:43  value s-1-5-21-3128221918-321857698-959514307-1002
2013-07-02 13:22:43  creating group principals...
2013-07-02 13:22:43  granting directory permissions...
2013-07-02 13:22:43  granting permissions on content directory...
2013-07-02 13:22:43  granting registry permissions...
2013-07-02 13:22:43  granting registry permissions...
2013-07-02 13:22:43  granting registry permissions...
2013-07-02 13:22:43  configuring shares...
2013-07-02 13:22:43  configuring network shares...
2013-07-02 13:22:43  fetching content directory...
2013-07-02 13:22:43  fetching contentdir registry store
2013-07-02 13:22:43  value c:\wsus
2013-07-02 13:22:43  fetching wsus admin sid...
2013-07-02 13:22:43  fetching wsusadministratorssid registry store
2013-07-02 13:22:43  value s-1-5-21-3128221918-321857698-959514307-1001
2013-07-02 13:22:43  content directory local, creating content shares...
2013-07-02 13:22:43  creating share "updateservicespackages" path "c:\wsus\updateservicespackages" , description "a network share used client systems collecting software packages (usually applications) published on wsus system."
2013-07-02 13:22:43  deleting existing share...
2013-07-02 13:22:43  creating share...
2013-07-02 13:22:43  share created
2013-07-02 13:22:43  creating share "wsuscontent" path "c:\wsus\wsuscontent" , description "a network share used local publishing place published content on wsus system."
2013-07-02 13:22:43  deleting existing share...
2013-07-02 13:22:43  creating share...
2013-07-02 13:22:43  share created
2013-07-02 13:22:43  creating share "wsustemp" path "c:\program files\update services\logfiles\wsustemp" , description "a network share used local publishing remote wsus console instance."
2013-07-02 13:22:43  deleting existing share...
2013-07-02 13:22:43  creating share...
2013-07-02 13:22:43  share created
2013-07-02 13:22:43  finished creating content shares
2013-07-02 13:22:43  configuring wid database...
2013-07-02 13:22:43  configuring database...
2013-07-02 13:22:43  establishing db connection...
2013-07-02 13:22:43  checking see if database exists...
2013-07-02 13:22:43  database exists
2013-07-02 13:22:43  switching database single user mode...
2013-07-02 13:22:43  loading install type query...
2013-07-02 13:22:43  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-07-02 13:22:43  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:d72e1c6d-e3b5-43fd-b783-4f6082c0957d

2013-07-02 13:22:43  system.data.sqlclient.sqlexception (0x80131904): invalid object name 'susdb.dbo.tbschemaversion'.

looks database present not 1 that's expected.

the logfile shows version of wsus existed on machine prior running installation, maybe give background of how got here?

---

lawrence garvin, m.s., mcitp:ea, mcdba, mcsa
solarwinds head geek
microsoft mvp - software packaging, deployment & servicing (2005-2013)
mvp profile: http://mvp.support.microsoft.com/profile/lawrence.garvin
http://www.solarwinds.com/gotmicrosoft
the views expressed on post mine , not reflect views of solarwinds.

Windows Server  >  WSUS