title: Insert Into with sqlCommand and ExecuteNonQuery is failing
body: <p>When I run the following code on my local mssql server database which uses integrated security, it works fine. When I run it on the remote server where the only difference that I can see is that it uses SQLServer authentication, the insert statement doesn't execute and I get no errors. When I insert or update using SQLDataSource on the server using a listView, the updates work perfectly and i am using the same connection string. I am only having the problem using the SQLCommand with the ExecuteNonQuery. Here is the code:</p>
  
  <pre><code>using (SqlConnection thisConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString))
          {
              thisConnection.Open();
              SqlCommand cmd = new SqlCommand("insert into dbo.msgs (msg1, msg2) values ('abc', 'abc')", thisConnection);
  
              int results = cmd.ExecuteNonQuery();
  
          }
  </code></pre>
  
  <p>My Local sqlServer connection string in web.config is </p>
  
  <pre><code>&lt;add name="LocalSqlServer" connectionString="Data Source=MYLAPTOP\sqlexpress;Initial Catalog=DBName;Integrated Security=True" providerName="System.Data.SqlClient"   /&gt;
  </code></pre>
  
  <p>My connection string on GoDaddy is :</p>
  
  <pre><code> &lt;add name="LocalSqlServer" connectionString="Data Source=xxx.xxx.xx.xx;Initial Catalog=DBName;Integrated Security=False;User Id=username; Password=password" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>the insert is just being ignored. </p>