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

Article translations Article translations
Article ID: 931176 - View products that this article applies to.
Expand all | Collapse all

On This Page

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: May 16, 2007 - Revision: 2.0
APPLIES TO
  • Microsoft SoftGrid for Terminal Services
  • Microsoft SoftGrid for Windows Desktops
Keywords: 
kbhowto kbexpertiseinter KB931176

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com