title: Sql Server 2012 listener not working with sql server authentication with asp.net on windows server 2012
body: <p>I am in the process of setting up an asp.net application on Windows server 2012 and IIS 8.0 connected to a SQL Server 2012 database with AlwaysOn availability groups database. However, I am having an error message popping up when trying to access the application with a login failure message. Now at this point I have replicated the same set up on a Windows server 2008 r2 sp1 and IIS 7.5 and the site works as expected. </p>
  
  <p>My connection string is thus  </p>
  
  <pre><code>&lt;add name="DatabaseConnectionString" 
       connectionString="Server=tcp:testdblistener;Database=Ibank;User Id=xx;Password=xxxxxxx;MultiSubnetFailover=True" 
       providerName="System.Data.SqlClient"/&gt;      
  </code></pre>
  
  <p>If I replace the <code>testdblitener</code> with the machine name of any nodes it works perfectly.</p>
  
  <p>Please help</p>