Vaidy reminds us that Mixed Mode Authentication is required in SQL Server for Dynamics and illustrates how to make sure that it is set correctly.
GP & Mixed Mode Authentication
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.