title: Web service with .net does not connect to mysql db in interner information service
body: <p>I've written a webservice that connects to a mysql database and provides api. It works fine when I run it in visual studio. Now I want it to work when I put it in internet information service. But api does not return. My single page appication that expects this api to run gives me the error below</p>
  
  <pre><code> GET http://localhost:8024/api/Interviewee 500 (Internal Server Error)
  
  
  angular.js:15536 Possibly unhandled rejection: {"data":{"Message":"An error has occurred.","ExceptionMessage":"Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.","ExceptionType":"System.InvalidOperationException","StackTrace":"   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at IntervieweeService.Controllers.IntervieweeController.GetInterviewees() in C:\\Projects\\IntervieweeApp\\IntervieweeService\\IntervieweeService\\Controllers\\IntervieweeController.cs:line 30\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.&lt;&gt;c__DisplayClass6_1.&lt;GetExecutor&gt;b__3(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.&lt;InvokeActionAsyncCore&gt;d__1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ActionFilterResult.&lt;ExecuteAsync&gt;d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.&lt;SendAsync&gt;d__15.MoveNext()"},"status":500,"config":{"method":"GET","transformRequest":[null],"transformResponse":[null],"jsonpCallbackParam":"callback","url":"http://localhost:8024/api/Interviewee","headers":{"Accept":"application/json, text/plain, */*"}},"statusText":"Internal Server Error","xhrStatus":"complete"}
  (anonymous) @ angular.js:15536
  (anonymous) @ angular.js:11815
  processChecks @ angular.js:17946
  $digest @ angular.js:19075
  $apply @ angular.js:19463
  done @ angular.js:13312
  completeRequest @ angular.js:13569
  requestLoaded @ angular.js:13474
  load (async)
  (anonymous) @ angular.js:13457
  sendReq @ angular.js:13257
  serverRequest @ angular.js:12998
  processQueue @ angular.js:17914
  (anonymous) @ angular.js:17962
  $digest @ angular.js:19075
  $apply @ angular.js:19463
  done @ angular.js:13312
  completeRequest @ angular.js:13569
  requestLoaded @ angular.js:13474
  load (async)
  (anonymous) @ angular.js:13457
  sendReq @ angular.js:13257
  serverRequest @ angular.js:12998
  processQueue @ angular.js:17914
  (anonymous) @ angular.js:17962
  $digest @ angular.js:19075
  $apply @ angular.js:19463
  bootstrapApply @ angular.js:1945
  invoke @ angular.js:5122
  doBootstrap @ angular.js:1943
  bootstrap @ angular.js:1963
  angularInit @ angular.js:1848
  (anonymous) @ angular.js:36216
  fire @ jquery-2.2.4.js:3187
  fireWith @ jquery-2.2.4.js:3317
  ready @ jquery-2.2.4.js:3536
  completed @ jquery-2.2.4.js:3552
  </code></pre>
  
  <p>connection string</p>
  
  <pre><code>Server=localhost;Port=8024;Database=intervieweedb;Uid=rrrr;Pwd=111;
  </code></pre>
  
  <p>How can I make this work? Thanks</p>