Have you made sure to set the correct connection type and rules using sp_session_set_connection_type and sp_session_set_connection_rules? This is important for offline mode to work properly.