these were my original connection strings...
<add name="connStr" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />
<add name="ASPNETDBConnectionString" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />
<add name="ConnectionString" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />
<remove name="LocalSqlServer" />
<add name="LocalSqlServer">connectionString="connStr" providerName="System.Data.SqlClient" />
</add>
what i should have had...
<add name="connStr" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />
<add name="ASPNETDBConnectionString" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />
<add name="ConnectionString" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />
<remove name="LocalSqlServer" />
<add name="LocalSqlServer">connectionString="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providerName="System.Data.SqlClient"/>
</add>
the bolded section in the LocalSqlServer string is the fix.