Login failed for user smartview

This happens after restoring a backup.

The passwords are basically screwed.

To resolve, Go to tools>>Smartview>>Smartview setup.
Change the password.

Go to SQL> Security>Logins.
Change the password for smartview user here as well to match the new password in GP.

Voila!