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!