When Installating iVend error "The Database server collation should be SQL_Latin1_General_CP1_C1_AS"

When Installating iVend error "The Database server collation should be SQL_Latin1_General_CP1_C1_AS"

Product Version:
6.5 Update 6


Problem statement:

On Installation of iVend, an error occurs "The Database server collation should be SQL_Latin1_General_CP1_C1_AS" and installation stops.


Resolution:

It is recommended in the Hardware and Software specification guide that Collation should be "SQL_Latin1_General_CP1_CI_AS" for iVend.

So this is suggested to Set the collation in SQL Server accordingly to resolve the issue.