The reason could be, your DataSource control which you use in the code might referring to the ConnectionString setting named "LocalSqlServer".
Check your implementation place what key you are referring to.
Point I noticed:
IMO both connection string should not work as it is not constructed properly.
<add name="LocalSqlServer";
You should not put "
;" next to name attribute in the
add
tag.