title: Web Api works locally but not on my test server
body: <p>I am using the latest asp.net mvc 5 and web api 2.  Everything works locally but when my web site is deployed to my test server, everything works except the web api. When a HttpGet call is made to the api I get a 500 Internal Server Error with an ExceptionMessage:</p>
  
  <blockquote>
    <p>ExceptionMessage=A network-related or instance-specific error occurred
    while establishing a connection to SQL Server. The server was not
    found or was not accessible. Verify that the instance name is correct
    and that SQL Server is configured to allow remote connections.
    (provider: Named Pipes Provider, error: 40 - Could not open a
    connection to SQL Server)</p>
  </blockquote>
  
  <p>and an InnerException of::</p>
  
  <blockquote>
    <p>ExceptionMessage=The network path was not found</p>
  </blockquote>
  
  <p>What makes this especially weird is that I have another website on the same test server with web api that works perfectly.  Because of the first above Exception Message, I was thinking that it might have something to do with the connection string, but assumed that it wouldn't be that since the new asp.net Identity 2.0 is utilizing it, and everything seems to be working in that regard. What am I missing here?</p>