Monday 12 March 2012

The stored procedure verify/versioninformation() of form duSQLInstall Pass Through SQL returned the following results: DBMS: 468, Microsoft Dynamics GP: 0.

After installing SQL and restoring GP database backups you sign into GP and get the following error:
The stored procedure verify/versioninformation() of form duSQLInstall Pass Through SQL returned the following results: DBMS: 468, Microsoft Dynamics GP: 0.

This is because of the collations.

To resolve this you need to uninstall SQL and go to control panel and change the location to United States. Restart the machine and ensur that the location remains the same.

Reinstall SQL and ensure you change the collation to: SQL_Latin1_General_CP1_CI_AS

Then run GP Utilites to recreate new company. (this is so the database folder will be present in SQL so you can restore to them) after company has been created restore the SQL backups.

Run script in SQL "sp_helpdb" expand the "status" column and ensure that all databases have the correct collation: SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52

No comments:

Post a Comment