Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error granting rights to tables in dynamics database

Status
Not open for further replies.

SpeedBWild

Programmer
Apr 29, 2004
117
US
I have just completed the upgrade from Dynamics 6.0 to Great Plains 7.5 The databases all seemed to update sucessfully. I got the green check mark. When I went to log into GP after installing SP6 and after doing the 'additional task updates' I get the following error.
"Error occured Granting rights for tables in the DYNAMICS database" GPS Error: 58 SQL ERROR - Incorrect syntax near "-" and ODBC Error: 37000.

Then GP opens. When I go to the activity table in the Dynamics I see that I am logged in.

Any ideas?

Thanks,
 
Try to run Grant70.sql against the Dynamics database. The script is found in the SQL>Util folder.
 
I did that it didn't help. I am still getting the same error message. Any other ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top