ConfigMgr Console can no longer connect to database!

Scenario: 2 servers, 1 SCCM 2007 R2 SP2, 1 SQL 2008 R2 and ofc, clients

For the last month i've tested OSD, Software Distribution, reporting etc..
Everything seemed to be working great (although some strange DCOM errors kept
showing about MP's not being able to install and what not!)
But today, i tried to open the console (from the ConfigMgr Site Server) and
it no longer connects to the database!

"The ConfigMgr console could not connect to the ConfigMgr site database.
Verify that this computer has network connectivity to the SMS Provider
computer and that your user account has Remote Activation permissions on both
the ConfigMgr site server and SMS Provider computers. For more information,
see "How to Configure DCOM Permissions for Configuration Manager Console
Connections" in ConfigMgr Help."

All DCOM permissions are correctly configured, and it was working perfectly
for so long.. On the SQL side, nothing has been tampered with. Has anyone
seen this issue occuring after having a working SCCM environment over a
period of time?