The SDF file is from SQL Compact Edition (CE). It is not compatible with SQL Server Express which uses MDF/LDF files.
You need to create a new DB in SQL Express (MDF) and convert data from CE (SDF) to use it in SQL Express (MDF).