?
Solved

SBS Monitoring and Udates - SQL Problems

Posted on 2009-04-24
7
Medium Priority
?
531 Views
Last Modified: 2012-05-06
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

0
Comment
Question by:stuart-CDSLTD
  • 4
  • 2
7 Comments
 
LVL 47

Assisted Solution

by:Donald Stewart
Donald Stewart earned 160 total points
ID: 24227846
0
 

Author Comment

by:stuart-CDSLTD
ID: 24231681
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
 

Author Comment

by:stuart-CDSLTD
ID: 24245116
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Assisted Solution

by:dcsdave
dcsdave earned 80 total points
ID: 24245654
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
 

Author Comment

by:stuart-CDSLTD
ID: 24245683
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
 
LVL 47

Assisted Solution

by:Donald Stewart
Donald Stewart earned 160 total points
ID: 24245746
Uninstalling and reinstalling has been the general consensus for this issue
 
http://www.wsus.info/forums/lofiversion/index.php?t8017.html 
0
 

Accepted Solution

by:
stuart-CDSLTD earned 0 total points
ID: 24248382
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
Screencast - Getting to Know the Pipeline
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question