The pilot was executing an ILS approach to an uncontrolled airport in low visibility conditions. He had his landing light and strobe lights on and failed to activate the pilot controlled runway lights. When his passenger informed him she saw lights, he went visual and could not see either the ground or runway environment. The aircraft drifted right and impacted the ground approximately 800 feet right and 1,000 feet down the runway. The landing gear collapsed and the aircraft slid to a stop on a taxiway adjacent to the ramp area.