Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Another MSSQL/IIS connection problem. Here's the solution to the problem that i've faced.
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Source Error(Example):
The source where the error occured
Stack Trace:
[SqlException: Login failed for user 'sa'. Reason: |
Solution: Add this statement: "Integrated Security=SSPI;" after Initial Catalog
Problem Solved!*I found out this problem was faced by lotsa people, here i include the solution for those that need it.