CRM 2011 on premise, UR3; SQL Server is on Same Box
I am executing a simple plugin to call a stored procedure to do some counting. The stored procedure will execute fine from SQL management studio and the c# code will execute just fine from a windows form application.
But when the code is imbedded and called from a plugin it times out. I have used SQL profiler and can see the execute being called, but it times out. Here is the error, code snippet follows.
====================
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: An error occurred in the StoredProc plug-in.System.Data.SqlClient.SqlException
(0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
===================
myConn = new SqlConnection(@"Data Source=xxxServerName;Initial Catalog=xxxxxxx_MSCRM;Integrated Security=True");
myConn.Open();
SqlCommand cmd = new SqlCommand("sp_UpdateCounts", myConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
