Knowledge Base

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

Article ID: 931176

Article Last Modified on 5/16/2007

APPLIES TO

Microsoft SoftGrid for Terminal Services
Microsoft SoftGrid for Windows Desktops

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

From Administrative Tools, start Data Sources (ODBC).
Click the System DSN tab.
Click SoftGridReporting, and then click Configure.
In the Server box, make sure that the server name appears in either of the following formats:
- Server_name
- Server_name\Instance
Click Next.
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.
Make sure that the Connect to SQL Server to obtain default settings for the additional configuration options check box is cleared.
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:

From Administrative Tools, start Data Sources (ODBC).
Click the System DSN tab.
If a System DSN that is named "SoftGridReporting" appears, click the DSN, and then click Remove.
Click Add.
Click SQL Server, and then click Finish.
In the Name box, type SoftGridReporting.
In the Server box, type the server name. Use either of the following formats:
- Server_name
- Server_name\Instance
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.
Click to clear the Connect to SQL Server to obtain default settings for the additional configuration options check box.
Click Next two times.
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