stuart-CDSLTD
asked on
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.SqlE xception: 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.Conn ectionPool .CreateCon nection() +406
System.Data.SqlClient.Conn ectionPool .UserCreat eRequest() +151
System.Data.SqlClient.Conn ectionPool .GetConnec tion(Boole an& isInTransaction) +464
System.Data.SqlClient.SqlC onnectionP oolManager .GetPooled Connection (SqlConnec tionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlC onnection. Open() +384
Microsoft.UpdateServices.D atabaseAcc ess.DBConn ection.Con nect(Strin g connectionString) +311
Microsoft.UpdateServices.D atabaseAcc ess.DBConn ection.Con nect() +567
Microsoft.UpdateServices.I nternal.Ge nericDataA ccess.Exec uteSP(Stri ng spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 queryTimeoutInSeconds) +226
Microsoft.UpdateServices.I nternal.Ge nericDataA ccess.Exec uteSP(Stri ng spName, DBParameterCollection args, IExecuteSPHandler handler) +17
Microsoft.UpdateServices.I nternal.Da taAccess.E xecuteSPMu ltipleResu ltSets(Str ing spName, DBParameterCollection args, Type[] resultTypes) +198
Microsoft.UpdateServices.I nternal.Da taAccess.E xecuteSPGe tConfigura tion() +147
Microsoft.UpdateServices.I nternal.Ba seApi.Upda teServerCo nfiguratio n.Load() +143
Microsoft.UpdateServices.I nternal.Ba seApi.Upda teServerCo nfiguratio n..ctor() +84
Microsoft.UpdateServices.I nternal.Cl assFactory .CreateWel lKnownType (Type type, Object[] args) +534
Microsoft.UpdateServices.I nternal.Cl assFactory .CreateIns tance(Type type, Object[] args) +191
Microsoft.UpdateServices.I nternal.Ba seApi.Upda teServer.G etConfigur ation() +45
Microsoft.SBS.UpdateServic es.DataPro vider..cto r() +120
Microsoft.SBS.UpdateServic es.StatusP age.Utilit y.SyncInPr ogress(Dat aProvider dp) +155
Microsoft.SBS.UpdateServic es.StatusP age.formHo me.Page_Lo ad(Object sender, EventArgs e) +290
System.Web.UI.Control.OnLo ad(EventAr gs e) +67
System.Web.UI.Control.Load Recursive( ) +35
System.Web.UI.Page.Process RequestMai n() +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;In itial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connect ion=Yes;Po oling='tru e'; Max Pool Size = 100
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.SqlE
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.Conn
System.Data.SqlClient.Conn
System.Data.SqlClient.Conn
System.Data.SqlClient.SqlC
System.Data.SqlClient.SqlC
Microsoft.UpdateServices.D
Microsoft.UpdateServices.D
Microsoft.UpdateServices.I
Microsoft.UpdateServices.I
Microsoft.UpdateServices.I
Microsoft.UpdateServices.I
Microsoft.UpdateServices.I
Microsoft.UpdateServices.I
Microsoft.UpdateServices.I
Microsoft.UpdateServices.I
Microsoft.UpdateServices.I
Microsoft.SBS.UpdateServic
Microsoft.SBS.UpdateServic
Microsoft.SBS.UpdateServic
System.Web.UI.Control.OnLo
System.Web.UI.Control.Load
System.Web.UI.Page.Process
--------------------------
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;In
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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;In itial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connect ion=Yes;Po oling='tru e'; Max Pool Size = 100
Please help if anyone can suggest an answer.....
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;In
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Already tried this but the upgrade will not run unfortunately. I am currently in the process of uninstalling an re-installing WSUS 2.0
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER