Error: Database Error in WSUS 3.0 SP2

• Monday, March 05, 2012 8:14 AM

   

   
  

  0

  Hello,

  I installed wsus 3.0 sp2 on windows 2008 R2 & configured it completely & use default setting for instal (like using internal database for wsus),

  but when trying to connect to upstream server which is in another server in my local network(also my upstream server is configured on different website(not default website) port 8530 for http connection & 8531 for https & configure downstream server in default website port 80 ), I got Database Error :

  The WSUS administration console was unable to connect to the WSUS Server Database.
      
  Verify that SQL server is running on the WSUS Server. If the problem persists, try restarting SQL.
      
  
  
  System.Data.SqlClient.SqlException -- Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
  Info:spSetConfiguration - SyncToMU or UpstreamServerName config value changed - no reset
  
  
  Source
  .Net SqlClient Data Provider
  
  
  Stack Trace:
     at Microsoft.UpdateServices.UI.AdminApiAccess.UpdateServerConfigurationManager.SaveServerConfiguration(IUpdateServerConfiguration configuration)
     at Microsoft.UpdateServices.UI.SnapIn.Dialogs.UssConnectionSettingsDialog.SaveAllSettings()
     at Microsoft.UpdateServices.UI.SnapIn.Dialogs.BaseSettingsDialog.OKDialogButton_Click(Object sender, EventArgs e)

  please help,

  Shokoofeh

  • Reply
  • Quote