SQL error code 18456
I am trying to restore a DB using SQL backup and get the error as per the subject line. The rest of the error is as follows:
Login failed for user 'sa'.
BUT, I can do a restore on the DB using plain old SQL.
- Changed 'sa' password
- Registered the server on SQL backup using 'sa', connects perfectly
I have other SQL instances on the same server which restore perfectly with SQL backup.