Microsoft KB Archive/931176

= 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
 * 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:
 * 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.
 * 1) Make sure that the Connect to SQL Server to obtain default settings for the additional configuration options check box is cleared.
 * 2) Click Next two times, and then click Finish.

Note If you do not know the server name or the instance, view the   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 &quot;SoftGridReporting&quot; 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:
 * 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.
 * 1) Click Next two times.
 * 2) 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   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:  Open the following folder:

%ProgramFiles%\Softricity\SoftGrid Reporting Service

 Right-click SftReporting.udl, and then click Properties. Click the Connection tab. Click Test Connection.

Keywords: kbhowto kbexpertiseinter KB931176

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.