Cannot open database requested in login 'SBSMonitoring'. Login fai
I get an error message saying
"The page cannot be displayed
An error occurred on the page you are trying to view."
When i run usage report in the Server Management. It started coming up all of a sudden. I have gone through the event viewer and i see below error message:
Event Type: Error
Event Source: ServerStatusReports
Event Category: None
Event ID: 1
Date: 20-4-2007
Time: 12:21:19
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 '#########"
Stack Trace: at usage.globalFn.connectDataSource(Boolean pingFirst)
at usage.frmUsage.renderReportWorker()
at usage.frmUsage.renderReport()
I want to know if there is anything i can try out to get it working????
Re: Cannot open database requested in login 'SBSMonitoring'. Login fai
I want to know if you have made any changes recently??? If it started coming up like that all of a sudden then its obvious that some recent changes might have messed up something. I have come across few people who have mentioned that they were getting the same error message after upgrading MSDE database to SQL Server. In order to fix the same they had to roll back to MSDE. So in case even you have done that then try rolling back to MSDE and see if your Server Management usage reports starts loading fine.