Windows Server Update Services problem - service terminates

Hi,

Yesterday our server was reported to be running extremely slow, so i looked at the system event logs and found that the Update Services was terminating with a 7034 event approx. every 10 minutes.:

The Update Services service terminated unexpectedly.  It has done this x time(s).

The application event viewer reports error 421 with varying messages, such as:

Connection to database failed. Reason=Cannot open database requested in login 'SUSDB'. Login fails.
Login failed for user 'NT AUTHORITY\SYSTEM'.. Connection string: Data Source=SVR\WSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100

And

Connection to database failed. Reason=Cannot open database requested in login 'SUSDB'. Login fails.
Login failed for user 'NT AUTHORITY\SYSTEM'.. Connection string: Data Source=SVR\WSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100

And

Connection to database failed. Reason=Cannot open database requested in login 'SUSDB'. Login fails.
Login failed for user 'DOMAIN\Administrator'.. Connection string: Data Source=SVR\WSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100

The update services tab of the management console shows and error also (see snippet).

Has anyone any suggestions - although only 4 clients are on the domain they are looking at rapid expansion shortly and the Update services is huge to us.

Thanks

Wes

Server Error in '/UpdateServices' Application.
--------------------------------------------------------------------------------
 
Cannot open database requested in login 'SUSDB'. Login fails. Login failed for user 'DOMAIN\Administrator'. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
 
Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'SUSDB'. Login fails. Login failed for user 'DOMAIN\Administrator'.
 
Source Error: 
 
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  
 
Stack Trace: 
 
 
[SqlException: Cannot open database requested in login 'SUSDB'. Login fails.
Login failed for user 'DOMAIN\Administrator'.]
   System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +552
   System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
   System.Data.SqlClient.SqlConnection.Open() +384
   Microsoft.UpdateServices.DatabaseAccess.DBConnection.Connect(String connectionString) +311
   Microsoft.UpdateServices.DatabaseAccess.DBConnection.Connect() +567
   Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 queryTimeoutInSeconds) +226
   Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler) +17
   Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPMultipleResultSets(String spName, DBParameterCollection args, Type[] resultTypes) +198
   Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetConfiguration() +147
   Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration.Load() +143
   Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration..ctor() +84
   Microsoft.UpdateServices.Internal.ClassFactory.CreateWellKnownType(Type type, Object[] args) +534
   Microsoft.UpdateServices.Internal.ClassFactory.CreateInstance(Type type, Object[] args) +191
   Microsoft.UpdateServices.DatabaseAccess.DBConnection.Connect(String connectionString) +311
   Microsoft.UpdateServices.DatabaseAccess.DBConnection.Connect() +567
   Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 queryTimeoutInSeconds) +226
   Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler) +17
   Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPMultipleResultSets(String spName, DBParameterCollection args, Type[] resultTypes) +198
   Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetConfiguration() +147
   Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration.Load() +143
   Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration..ctor() +84
   Microsoft.UpdateServices.Internal.ClassFactory.CreateWellKnownType(Type type, Object[] args) +534
   Microsoft.UpdateServices.Internal.ClassFactory.CreateInstance(Type type, Object[] args) +191
   Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetConfiguration() +45
   Microsoft.SBS.UpdateServices.DataProvider..ctor() +120
   Microsoft.SBS.UpdateServices.StatusPage.Utility.SyncInProgress(DataProvider dp) +154
   Microsoft.SBS.UpdateServices.StatusPage.formHome.Page_Load(Object sender, EventArgs e) +290
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750
 
 
 
 
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407

Select allOpen in new window