Dynamics GP Web Service Installation Error troubleshooting.
1) Uninstalled Completely Dynamics GP Web Services.
2) Remove ADAM instance prior to the reinstall of GP WebService
3) Make sure eConnect is not installed on Dynamics Database server before installing Dynamics GP Web Service. If eConnect is installed Uninstalled eConnect with all SQL objects.
4) Run following SQL Script to verify Dynamics GP Database is exist in SQL Server or not
a. Select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500
b. Select * from Dynamics..DB_Upgrade
c. Select * from Dynamics..DU000020 order by companyID
5) DB_Upgrade will show if any company is not with Current Version and SP.
6) If you found any discrepancy in physically available Dynamics GP Company Database in SQL and Select Statement in “SY01500” run clearcompanies sql script from Microsoft, Download from KB973027 (Point No : 4)