In my case the user "sa" was locked out. I had to unlock it in SSMS. Expand the server => Security => Logins => "sa", rightclick => "properties" => "status" => Uncheck "login is locked out"
Steven
- 111
- 3