I have some issue with my default connection through web.config.
I have configured my default connection to connect my local database server and I'm getting error "Unable to connect to SQL Server database".
I have checked my server name 10 times and my database name as well, and I found all is good. also I tested from server explorer in visual studio and it works fine and connecting to the SQL server:
Here is how I'm trying to connect through web config and fail anytime:
<add name="DefaultConnection" connectionString="Data Source=localhost;Initial Catalog=Codeexample;Persist Security Info=True;User ID=sa;Password=*******;multipleactiveresultsets=True;" providerName="System.Data.SqlClient" />