Re: Cannot open database requested in login 'SBSMonitoring'. Login

Tech-Archive recommends: Fix windows errors by optimizing your registry



I did not change anything. The server is running for half a year now. This
happend spontanously.



"Costas" wrote:

Did you upgrade the MSDE database to SQL Server?

If yes, then you have to roll back to MSDE because the monitoring component
needs it. In that case you'll have to reinstall the component

Costas


"Maarten Schmeitz" <Maarten Schmeitz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:42ADC8DC-6149-45A4-97EC-699B5546AA50@xxxxxxxxxxxxxxxx
When i try to run a usage report in the Server Management i'll get the
error:

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.


When i look in event viewer (application) i'll see the next error:

Event Type: Error
Event Source: ServerStatusReports
Event Category: None
Event ID: 1
Date: 20-4-2007
Time: 14:44:06
User: N/A
Computer: SRV01
Description:
Server Status Report:
URL: http://localhost/monitoring/usage.aspx?reportMode=0
Error Message: Cannot open database requested in login 'SBSMonitoring'.
Login fails.
Login failed for user 'NIESMETAAL\niesadmin'.
Stack Trace: at usage.globalFn.connectDataSource(Boolean pingFirst)
at usage.frmUsage.renderReportWorker()
at usage.frmUsage.renderReport()

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


How can i solve this problem?

.



Relevant Pages

  • RE: Unable to Veiw Performance Reports after WSUS was removed
    ... SQL database for monitoring component. ... Open Server Management. ... Click Set Up Monitoring Reports and Alerts. ... Reporting wizard to configure the monitoring component. ...
    (microsoft.public.windows.server.sbs)
  • RE: Unable to Veiw Performance Reports after WSUS was removed
    ... SQL database for monitoring component. ... Open Server Management. ... Click Set Up Monitoring Reports and Alerts. ... Reporting wizard to configure the monitoring component. ...
    (microsoft.public.windows.server.sbs)
  • RE: Unable to Veiw Performance Reports after WSUS was removed
    ... Microsoft CSS Online Newsgroup Support ... Unable to Veiw Performance Reports after WSUS was removed ... SQL database for monitoring component. ... Open Server Management. ...
    (microsoft.public.windows.server.sbs)
  • RE: Monitoring Error no emails comming through
    ... > reports on the SBS server managements. ... > can access other internal website such as OWA or backup reports? ... > Here I assume that you only encountered problem on monitoring components, ... > Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Event ID 4353 - failure to run reports
    ... and the Monitoring reports no longer work. ... A SBS Server Status Report is much big and it ... select Microsoft SQL Server Desktop Engine ...
    (microsoft.public.windows.server.sbs)