SBS Monitoring and Udates - SQL Problems

On SBS 2003 a recent install of which I have done many, clicking on Updates brings up a debug screen that says SQL server does not exist and when I go to Monitoring and reporting it shows the page cannot be displayed.....all this is quite strange as its a new install with only Updates and service packs applied..I am also getting an event log error of 421.  .....  Ok Screens are posted below for both problems so hope you can help me with a solution to these as I have no explanation for these problems.

UPDATES SCREEN ERROR SHOWS -
Server Error in '/UpdateServices' Application.
--------------------------------------------------------------------------------

SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.

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.  
SqlException: SQL Server does not exist or access denied.]
   System.Data.SqlClient.ConnectionPool.CreateConnection() +406
   System.Data.SqlClient.ConnectionPool.UserCreateRequest() +151
   System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +464
   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.Internal.BaseApi.UpdateServer.GetConfiguration() +45
   Microsoft.SBS.UpdateServices.DataProvider..ctor() +120
   Microsoft.SBS.UpdateServices.StatusPage.Utility.SyncInProgress(DataProvider dp) +155
   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

MONITORING AND REPORTING SCREEN SHOWS

The page cannot be displayed
An error occurred on the page you are trying to view.

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

To work around this problem, perform the following steps. After each step, try again to access the page.

Ensure that the MSSQL$SBSMONITORING service is started.
Ensure that the server is not low on memory or disk space.
Restart the server.
Verify that the server is functional and that there are no system-wide problems.
Run the Set Up Monitoring Reports and Alerts task in the Server Management Monitoring and Reporting taskpad

EVENT LOG ERROR SHOWS - EVENT 421 - source = update sevices
Connection to database failed. Reason=SQL Server does not exist or access denied.. Connection string: Data Source=SVR-PTCOMMS\WSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100

stuart-CDSLTDAsked:
Who is Participating?
 
stuart-CDSLTDConnect With a Mentor Author Commented:
FURTER UPDATE -

I uninstalled the services only of the updates installation using add/remove programs.  Once this was completed I re-installed WSUS 3.0  (ver 2.0 would not install) and all seems to be working ok neow....but will feed back if i get any issues.
0
 
stuart-CDSLTDAuthor Commented:
Thanks for the info dstewartjr: but unfortunately I have checked out the KB article and non of these issues are correct for this problem.I have not deleted a file and it is still in the correct place on the server and the cliconfg still shows that shared memory is on...but thanks any way.   Hope someone can come up with the answer soon though!!
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
stuart-CDSLTDAuthor Commented:
UPDATE - OK I have re-installed the monitoring aspect of my problem so the only issue I have now is on the updates problem....so I still get code snippet below and the

EVENT LOG ERROR SHOWS - EVENT 421 - source = update sevices
Connection to database failed. Reason=SQL Server does not exist or access denied.. Connection string: Data Source=SVR-PTCOMMS\WSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100

Please help if anyone can suggest an answer.....
UPDATES SCREEN ERROR SHOWS - 
Server Error in '/UpdateServices' Application.
--------------------------------------------------------------------------------
 
SQL Server does not exist or access denied. 
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: SQL Server does not exist or access denied.
 
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.  
SqlException: SQL Server does not exist or access denied.]
   System.Data.SqlClient.ConnectionPool.CreateConnection() +406
   System.Data.SqlClient.ConnectionPool.UserCreateRequest() +151
   System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +464
   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.Internal.BaseApi.UpdateServer.GetConfiguration() +45
   Microsoft.SBS.UpdateServices.DataProvider..ctor() +120
   Microsoft.SBS.UpdateServices.StatusPage.Utility.SyncInProgress(DataProvider dp) +155
   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
 
 

Open in new window

0
 
dcsdaveConnect With a Mentor Commented:
I think if you install/upgrade to WSUS 3.0 it will let you configure a local database instead of SQL which would resolve your issue.  I run the local instance on many of my SBS servers and it works fine.
0
 
stuart-CDSLTDAuthor Commented:
Dave,

Already tried this but the upgrade will not run unfortunately.  I am currently in the process of uninstalling an re-installing WSUS 2.0
0
 
DonConnect With a Mentor Network AdministratorCommented:
Uninstalling and reinstalling has been the general consensus for this issue
 
http://www.wsus.info/forums/lofiversion/index.php?t8017.html 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.