Microsoft Sql Server 2008 R2 Error 18456 : Login failed for user sa

Question

microsoft sql server error 18456 in sql server 2008 r2login failed for user   sasql server was working properlyi just restarted the system and then i started getting the above errorhow do i resolve iti am able to login with windows authentication but not sql authentication

Mudassar · Accepted Answer

Somehow either the password has changed or reset Or it may be possible that Mixed Mode Authentication might be disabledSo try setting it again and also change password for sa

Microsoft Sql Server 2008 R2 Error 18456 : Login failed for user sa

Company

Explore

Follow us

Contact Us