EOne SmartPost - None of the windows open after installation

Issue:
After you install EOne Smartpost in Dynamics GP, the menus all appear, but when you click on them, none of the windows open.


Resolution:

1. Check the application error logs in the event viewer for smartpost
2. Reset the password for your Smartpost user account

If that doesn't work, move on

1. Install .net framework 3.5
1. http://www.microsoft.com/net/download
2. Upgrade to .net framework 4.5
3. Reset your Smartpost SQL user account password to confirm it is correct
4. Uninstall and reinstall Smartpost

Run the uninstaller.  After running the uninstall, go into the Great Plains directory and then go into the AddIns subfolder.  Delete the files named:

eOne.SmartPost.dll

eOne.SmartPost.dll.config

Then go into the GP directory and delete the SMRTPST.DIC and SMRTPST.vba files.

Then reinstall SmartPost again.  

http://www.eonesolutions.com/KnowledgeBase.aspx?article=QQF8AA002JGK

Exclusive access could not be obtained because the database is in use

Use Master

 Alter Database YOURDB

  SET SINGLE_USER With ROLLBACK IMMEDIATE

  RESTORE DATABASE YOURDB
  FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\YOURDB.bak'

Only use this if the database is not live, and users are not actively performing transactions.

This is a last resort option to be used in cases where all users have logged out, and some unknown service keeps accessing the database.

This will disconnect all other users, and run the restore.

The restore will remove the single_user flag.