title: When consuming WCF through IIS its connecting to another database instead of the one in connection string
body: <p>This question can be weird but i tried my best to find a solution but i am not able to.</p>
  
  <p>I created a WCF service which will return an object with the help of a <code>sql function</code>. There is a connection string in the WCF to connect to SQL SERVER and its connecting to <code>mydatabase_uat</code>. The sql function is 
  <code>my_function</code> when I run it locally it is executing perfectly and giving the result.</p>
  
  <p>I deployed the same in <code>IIS7</code>. Then Wrote another consuming application which consume the same WCF. Then I got an error.</p>
  
  <blockquote>
    <p>Cannot find either column "dbo" or the user-defined function or
    aggregate "dbo.my_function", or the name is ambiguous</p>
  </blockquote>
  
  <p>I have another database <code>mydatabase_live</code>. For checking i created the same function <code>my_function</code> in <code>mydatabase_live</code>. After that the WCF consuming application works perfectly.</p>
  
  <p>So the consuming application is pointing to <code>mydatabase_live</code> but the connection string in WCF is to  <code>my_database_uat</code></p>
  
  <p>I am not understanding why this is happening. Anybody here gone through this issue?</p>
  
  <p>Note: There is no connection string in consuming application</p>