I am switching sql server to another VM and am having issues with the sa login. It is set to allow connections and has permissions, but it keep saying that login failed of user sa. WE are using SQL 2019. Is there a setting I am missing?
Ok, I need to remember to RESTART the MSSQL service!
You can mark your own replies as solutions. Useful for others reviewing similar issues.