When the GP Manufacturing integration .cnk fails due to permissions in the PanatrackerGP database, use this method to fix it:
Find the user in SQL, double click it, under User Mapping, select the PanatrackerGP database. In the Database role membership portion, check db_datawriter and db_datareader.