How to validate and how to re-create the SoftGridReporting System DSN in SoftGrid

This article has been archived. It is offered "as is" and will no longer be updated.
SUMMARY
This article describes how to validate the SoftGridReporting System data source name (DSN) and how to re-create the SoftGridReporting System DSN.
MORE INFORMATION
When the SoftGrid Management Web Service is installed, a System DSN that is named SoftGridReporting is installed. If the DSN is modified or if the DSN is removed, the SoftGrid Management Console reports will not run.

How to validate the DSN

On the SoftGrid Management Web Service server, follow these steps
  1. From Administrative Tools, start Data Sources (ODBC).
  2. Click the System DSN tab.
  3. Click SoftGridReporting, and then click Configure.
  4. In the Server box, make sure that the server name appears in either of the following formats:
    • Server_name
    • Server_name\Instance
  5. Click Next.
  6. Under How should SQL Server verify the authenticity of the login ID, make sure that With SQL Server authentication using a login ID and password entered by the user is selected.
  7. Make sure that the Connect to SQL Server to obtain default settings for the additional configuration options check box is cleared.
  8. Click Next two times, and then click Finish.
Note If you do not know the server name or the instance, view the <location></location> section of the Server.conf file. This file is located in the following folder on the SoftGrid Virtual Application server:
%ProgramFiles%\Softricity\SoftGrid Server\Conf

How to re-create the DSN

On the SoftGrid Management Web Service server, follow these steps:
  1. From Administrative Tools, start Data Sources (ODBC).
  2. Click the System DSN tab.
  3. If a System DSN that is named "SoftGridReporting" appears, click the DSN, and then click Remove.
  4. Click Add.
  5. Click SQL Server, and then click Finish.
  6. In the Name box, type SoftGridReporting.
  7. In the Server box, type the server name. Use either of the following formats:
    • Server_name
    • Server_name\Instance
  8. Under How should SQL Server verify the authenticity of the login ID, click With SQL Server authentication using a login ID and password entered by the user.
  9. Click to clear the Connect to SQL Server to obtain default settings for the additional configuration options check box.
  10. Click Next two times.
  11. Under Test Data Source, click OK.

    Note Do not click Test Data Source. The test will fail.
Note If you do not know the server name or the instance, view the <location></location> section of the Server.conf file. This file is located in the following folder on the SoftGrid Virtual Application server:
%ProgramFiles%\Softricity\SoftGrid Server\Conf

How to test the DSN

On the SoftGrid Management Web Service server, follow these steps:
  1. Open the following folder:
    %ProgramFiles%\Softricity\SoftGrid Reporting Service
  2. Right-click SftReporting.udl, and then click Properties.
  3. Click the Connection tab.
  4. Click Test Connection.
Properties

Article ID: 931176 - Last Review: 01/15/2015 09:23:16 - Revision: 2.0

  • Microsoft SoftGrid for Terminal Services
  • Microsoft SoftGrid for Windows Desktops
  • kbnosurvey kbarchive kbhowto kbexpertiseinter KB931176
Feedback