Quote Originally Posted by rmiao View Post
Just add sql login as user of the db and grant proper permissions.
I have tried not sure what I am doing wrong.

<add name="DefaultConnection" connectionString="Data Source=10.5.41.19;Initial Catalog=aspnet-cxcDB-20130627224632.mdf;User ID=sa;Password=P@Dalia3636" providerName="System.Data.SqlClient" />
<add name="CXCDBConnectionString1" connectionString="Data Source=10.5.41.19;Initial Catalog=CXCDB;User ID=sa;Password=P@Dalia3636" providerName="System.Data.SqlClient" />

thanks for help