OpsMgr 2007 Alert: Cannot login to database


Toolbox3Hi everyone, Vikram Sahay here and I’m back again with another interesting topic on System Center Operations Manager 2007. Hope you find it useful.

Recently we were working on an  issue where we were getting an alert from few of the SQL servers as: ‘Cannot login to database’

We checked and verified that the ‘Agent Action account’ or the ‘SQL Monitoring Account’ had the ‘SysAdmin’ rights on the SQL servers but we were still getting the error as ‘Cannot login to database’ which puzzled us.

Upon troubleshooting, we found that the alert was only from few of the custom databases and not from all the databases located on a SQL server.  Further, we found that when we got the alert we were getting an event like 17137 with the description as ‘Starting up database ‘<Custom DB name>’.  We also found that on the properties of those DBs (for which we get the alerts), the ‘Auto Close’ option was set as ‘True’ whereas the default value is set as ‘False’.

clip_image002

Once we changed the value of ‘Auto Close’ to ‘False’ we no longer got the ‘Cannot login to database’ alert.  This was a fairly rare issue so I thought I would share it here.  Hope you will find it useful.

Vikram Sahay | System Center Technical Lead

App-V Team blog: http://blogs.technet.com/appv/
AVIcode Team blog: http://blogs.technet.com/b/avicode
ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
DPM Team blog: http://blogs.technet.com/dpm/
MED-V Team blog: http://blogs.technet.com/medv/
OOB Support Team blog: http://blogs.technet.com/oob/
Opalis Team blog: http://blogs.technet.com/opalis
Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
OpsMgr Support Team blog: http://blogs.technet.com/operationsmgr/
SCMDM Support Team blog: http://blogs.technet.com/mdm/
SCVMM Team blog: http://blogs.technet.com/scvmm
Server App-V Team blog: http://blogs.technet.com/b/serverappv
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
WSUS Support Team blog: http://blogs.technet.com/sus/

clip_image001 clip_image002

Comments (3)

  1. Anonymous says:

    Also, I’ve just found a few servers where auto close is already true, and i’m seeing event 17137

  2. Anonymous says:

    This is a very interesting find, and I seem to finding some similar servers that are affected with this issue. The problem I have, these are DB’s managed by our customers, and for at least one this was set _intentionally_ is there a way to get around this
    issue without tweaking the config of a production database?

  3. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    http://showboxandroids.com/showbox-apk/
    http://showboxappandroid.com/
    Latest version of Showbox App download for all android smart phones and tablets.
    http://movieboxappdownloads.com/ – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    http://showboxappk.com/showbox-for-ipad-download/
    http://showboxappk.com/showbox-for-iphone/
    Showbox for PC articles:
    http://showboxandroids.com/showbox-for-pc/
    http://showboxappandroid.com/showbox-for-pc-download/
    http://showboxforpcs.com/
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings.
    http://www.showboxforipad.org/showbox-apk/ Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    http://www.showboxforipad.org/
    http://movieboxappdownloads.com/moviebox-apk-android/
    http://movieboxappdownloads.com/download-moviebox-pc/
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    http://showboxforiphone.org/
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    http://ymaillogintips.com/
    Sign Up & Do registration for latest movies on Showbox application