Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you try to generate a large report in Microsoft Dynamics GP: "Error accessing SQL data"

Error message when you try to generate a large report in Microsoft Dynamics GP: "Error accessing SQL data"

View products that this article applies to.

Symptoms

When you try to generate a large report in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you may receive the following error message:
Error accessing SQL data.

↑ Back to the top

Resolution

To resolve this problem, follow these steps:
  1. On the workstation where the error occurs, locate the Dex.ini file.

    Notes
    • In Microsoft Dynamics GP 10.0 and in later versions, the Dex.ini file is located in the Data folder in the folder where the Microsoft Dynamics GP client is installed.
    • In Microsoft Dynamics GP 9.0 and in earlier versions, the Dex.ini file is located in the folder where the Microsoft Dynamics GP client is installed.
  2. Right-click the Dex.ini file, and then click Open.
  3. If the following lines are missing, type the following lines at the bottom of the file:

    • SQLQueryTimeout=0
    • SQLProcsTimeout=0
    • SQLRprtsTimeout=0
  4. On the File menu, click Save, and then click Exit.
  5. Restart the computer.

  6. In Microsoft SQL Server Management Studio, or in SQL Server Enterprise Manager, increase the size of the tempdb setting.

  7. Increase the size of the free space that is available on the hard disk drives where the SQL Server data files are stored.

↑ Back to the top

Keywords: kbnosurvey, kberrmsg, kbexpertisebeginner, kbtshoot, kbprb, kbexpertiseinter, kbmbsgp10,, kbfreshness2007, kbmbspartner, kbmbsmigrate, kb

↑ Back to the top

Article Info
Article ID : 857827
Revision : 1
Created on : 3/13/2017
Published on : 12/30/2014
Exists online : False
Views : 160