Solve Error Login Failed for User in C# and SQL

This blog describe how to solve Solve Error Login Failed for User in C# and SQLconnection.

This is the Common Problem we are facing in Server DB Connection in Asp.net.If you are using windows authentication to connect to the Server DB, you need to set "Trusted_Connection=True;" if you are using SQL server authentication, you need to declare User "Id=myUsername; Password=myPassword;"

 

Code Snippet In Web.Config: 

 

Windows authentication 

<add name="windowsConnection" connectionString="Server=localhost; Database=databasename; Trusted_Connection=True;" />

SQL server authentication 

<add name="Sqlserverconnection" connectionstring="server=localhost; Database=databasename;uid=db; password=123 "/>

Tech Blog .