title: Service account to access SQL server from IIS
body: <p>My Asp.Net/C# web app hosted on IIS is using 2 different service accounts to access 2 DBs on 2 SQL servers on the network. IIS is running as service account1 coonnecting to DB1 on SQL server1. </p>
  
  <p>I have the User ID, Password for account 2 configured in the web.config connectionstring expecting  this to supersede the IIS setting just for DB2 on SQL server2. This is not working. Is there a better way to handle this? Appreciate your help.</p>
  
  <p>
      
      
    </p>