The server SQL Express download links are broken, they return an HTTP "302 Moved Temporarily" response.
The broken links are:
Fix provided at https://github.com/dstj/sql_server/tree/fix_download_link
Before this change can be merged you'll need to sign the Opscode CLA and then mark this ticket as Fix Provided. More information on the process here:
Merged in https://github.com/opscode-cookbooks/sql_server/commit/b579440
Released in 1.3.0