The following is what you need to do; to get your CAS server authenticate against Databases instead of default inMemory Authentication:-

Single Sign On CAS Acegi Configuration

Overview:

taking the definition from Acegi Documentation