Sources directly connected to the rock star tell us ... he died at St. John's Hospital in Santa Monica Tuesday.