Login failed for user sa The user is not associated with a trusted SQL Server connection Microsoft SQL Server Error 18452 in sql 2008

Question

Windows 7 Ultimate is what I use. Although SQL authentication with user sa doesn't work, I can log in using Windows authentication mode. The sa user is active. What then shall I do?

Answer 1

Go to Start > Programs > Microsoft SQL Server > Enterprise Manager.

Right-click the SQL Server instance name > Select Properties from the context menu > Select Security node in left navigation bar.

Under Authentication section, select SQL Server and Windows Authentication.

I hope this helps you.