SQL database names are restricted to 5 characters by the Dynamics GP Company Creation utility so the SQL database names used in a Dynamics GP installation tend to be far less informative than the Dynamics Company Name, which appears in the drop down list during the company selection process at login.
If you only have access to the SQL Database it is unlikely that you will know which database corresponds to which Company.
The following query can be run on demand within SQL by the appropriate technical resource to list all Companies within the Dynamics DB:
This query will display a list of company databases and the corresponding company names, so when the DataShare Connect asks for the database name for a particular company, mistakes can be avoided. See image the results of the query below.
Please sign in to leave a comment.