Note: Both of the checkboxes for the "Use ANSI." settings should not be marked.ħ. Log into PDK and the error should now be gone.Īnother reason may also be that the user in not in the role of DYNGRP. Change the name of the database from 'Master' to 'DYNAMICS' in the field for Change the default database to: Click Next to get to the In the Microsoft SQL Server DSN Configuration window.ĥ. (If you don't know the name of the ODBC, log into PDK and see what you selected for the Data Server name.)Ĥ. Click to select the ODBC for PDK, and click on Configure. Navigate to Start, click on Control Panel, click on Administrative Tools, click on Data Sources (ODBC), and click on the System DSN tab.ģ. To resolve this issue, you will need to set the Default Database for the PDK ODBC to 'Dynamics' (or whatever you named this database).
This happens when the ODBC is created by PDK. The PDK ODBC gets set to a default database name of 'Master', instead of 'Dynamics', since Microsoft Dynamics GP 2013 allows you to name this (Dynamics)database whatever you want.
Microsoft dynamics pos odbc connection update#
Update the SQL Server settings for this data source to disable trusted connections and try logging in again. Your'e attempting to log in from a data source using a trusted connection. The EXECUTE permission was denied on the object 'zDP_SY02100SS_1', database 'master', schema 'dbo'.Ī get/change on operation table 'SY_Pathnames' failed accessing SQL data.
0 kommentar(er)
