Dex.ini Settings

I wanted to write about Dex.ini and explain what is in the file and how can it help the user experience. Before I started working on it, I thought maybe somebody else already had an article on this. True enough I found a good article from Merit Solutions, here's a summary and if you want more detail just click the link:

DEX.INI: The Microsoft Dynamics GP defaults files which contain setup and operating information. Each setting contains information such as where files are located and whether certain functions are performed. It is stored on each computer where the Microsoft Dynamics GP application files are installed. The information in the file affects only the computer where the file is located. This file is also essential for Microsoft Dynamics GP to run correctly, so we have to be very careful when editing it. But at the same time, it can be a good advantage to explore its possibilities.

Below are some settings which can be used for troubleshooting Microsoft Dynamics GP problems or making work in Dynamics GP more comfortable. Some of them are default settings, but some of them are optional.

• SQLLogSQLStmt=TRUE
  SQLLogODBCMessages=TRUE
  SQLLogAllODBCMessages=TRUE - Turn on all of these 3 settings and information is going to be appended to the end of the existing log DEXSQL.LOG file (or a new file is going to be created)
  

More on this article.......

User or role already exists in the current database

When you try to give a user access to a database you get the above message. To resolve this you need to have access to SQL Server Enterprise Manager.

Open Enterprise Manager then go to Security>Logins, right-click on the user having this problem then go to Properties. Open the Database Access tab then Unmark or Uncheck the database you're giving the user access to.

Go back to Great Plains then try to give the user access again.