Cannot open database requested in login 'SBSMonitoring'. Login fai

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?

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@discussions.microsoft.com> wrote in
message news:42ADC8DC-6149-45A4-97EC-699B5546AA50@microsoft.com...
> 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?

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@discussions.microsoft.com> wrote in
> message news:42ADC8DC-6149-45A4-97EC-699B5546AA50@microsoft.com...
> > 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?
>

Here are some steps that might be of help:
http://www.eventid.net/display.asp?e...eports&phase=1

Costas

"Maarten Schmeitz" <MaartenSchmeitz@discussions.microsoft.com> wrote in
message news:DC9709CD-DF8B-415F-AE75-BD6979FC6ED2@microsoft.com...
>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@discussions.microsoft.com> wrote in
>> message news:42ADC8DC-6149-45A4-97EC-699B5546AA50@microsoft.com...
>> > 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?
>>

Hi Maarten,

We are having this problem now - did you manage to solve this issue in
a simple way?

Thanks,
Edmund


On 20 Apr, 15:00, Maarten Schmeitz
<MaartenSchme...@discussions.microsoft.com> wrote:
> I did not change anything. The server is running for half a year now. This
> happend spontanously.
>
>
>
> "Costas" wrote:
> > Did you upgrade the MSDEdatabaseto 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 Schme...@discussions.microsoft.com> wrote in
> > messagenews:42ADC8DC-6149-45A4-97EC-699B5546AA50@microsoft.com...
> > > When i try to run a usage report in the Server Management i'll get the
> > > error:
>
> > > The pagecannotbe 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$SBSMONITORINGservice 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:Cannotopendatabaserequestedinlogin'SBSMonitoring'.
> > >Loginfails.
> > >Loginfailed 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?- Hide quoted text -
>
> - Show quoted text -