
Create a connection string
When creating a data link to an external data source, the connection string stored in the Microsoft Dynamics AX database may contain the user identification and password of the user in the external data source that is allowed to access the data.
One way to exclude user login credentials from the connection string is to use Microsoft Windows NT Integrated Security.
-
If the data link is defined to use Windows NT Integrated Security, then the user identification and password is not part of the connection string and, therefore, not stored in the Microsoft Dynamics AX database.
-
If Windows NT Integrated Security is not used, then the user in the external data source should be given access to as little data as possible.