Microsoft KB Archive/931178

= How to validate and re-create the SftReporting.udl file in SoftGrid =

Article ID: 931178

Article Last Modified on 5/25/2007

-

APPLIES TO


 * Microsoft SoftGrid for Terminal Services
 * Microsoft SoftGrid for Windows Desktops

-



INTRODUCTION
This article describes how to validate and re-create the SftReporting.udl file.



MORE INFORMATION
When the SoftGrid Management Web Service is installed, a System data source name (DSN) that is named SoftGridReporting is added. And, the SftReporting.udl file is configured to use this DSN. If the SftReporting.udl file is modified or removed from the SoftGrid Management Console, the reports will not run.

How to validate the SftReporting.udl file
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 Provider tab. Make sure that Microsoft OLE DB Provider for ODBC Drivers is selected. Click the Connection tab. In Specify the source of data box, make sure that Use data source name is selected. In the Use data source name box, make sure that SoftGridReporting appears.</li> In the User name box, confirm the user name.</li> In the Password box, confirm the password.</li> Make sure that the Allow saving password check box is selected.</li> In the Enter the initial catalog to use box, make sure that the name of the database that you are using appears.</li> Click the Security tab.</li> Make sure that the appropriate ASP.NET worker process account is added. Make sure that this account has Read permissions.

For more information about the ASP.NET worker process account, see the &quot;Information about ASP.NET worker process accounts&quot; section.</li></ol>

Note If you do not know the user name, the password, or the database name, review the Server.conf file. This information is in the following sections:
 * User name:  
 * Password:  
 * Database name:  

The Server.conf file is located in the following folder on the SoftGrid Virtual Application server:

%ProgramFiles%\Softricity\SoftGrid Server\conf

How to re-create the SftReporting.udl file
On the SoftGrid Management Web Service server, follow these steps: <ol> Open the following folder:

%ProgramFiles%\Softricity\SoftGrid Reporting Service

</li> On the File menu, click New, and then click Text Document.</li> In New Text Document.txt box, type SftReporting.udl .</li> Right-click SftReporting.udl, and then click Properties.</li> Click the Provider tab.</li> Click Microsoft OLE DB Provider for ODBC Drivers.</li> Click the Connection tab.</li> Under Specify the source of data, click Use data source name. Then, type SoftGridReporting .</li> In the User name box, type the user name.</li> In the Password box, type the password.</li> <li>Click to select theAllow saving password check box.</li> <li>Under Enter the initial catalog to use, type the name of the database that you are using.</li> <li>Click the Security tab.</li> <li>Click Advanced.</li> <li>Click to clear the '''Allow inheritable permissions from the parent to propagate to this object and all child objects. Include these with entries explicitly defined here''' check box.</li> <li>Next to Selecting this option means that the parent permission entries that apply to child objects will no longer be applied to this object, click Remove.</li> <li>Click OK, and then click Yes next to You have denied all user access to SftReporting.udl.</li> <li>Click Add.</li> <li>Under From this location, click Locations.</li> <li>Click the computer name, and then click OK.</li> <li>Under Enter the object names to select, type Administrators, and then click OK.</li> <li>Click Administrators ( \Administrators).</li> <li>Click to select the Full Control check box in the Allow column.</li> <li>Make sure that the appropriate ASP.NET worker process account is added. Make sure that this account has Read permissions.

For more information about the ASP.NET worker process account, see the &quot;Information about ASP.NET worker process accounts&quot; section.</li></ol>

Note If you do not know the user name, the password, or the database name, review the Server.conf file. This information is in the following sections:
 * User name:  
 * Password:  
 * Database name:  

How to test the SftReporting.udl file
On the SoftGrid Management Web Service server, follow these steps: <ol> <li>Open the following folder:

%ProgramFiles%\Softricity\SoftGrid Reporting Service

</li> <li>Right-click SftReporting.udl, and then click Properties.</li> <li>Click the Connection tab.</li> <li>Click Test Connection.</li></ol>

Information about ASP.NET worker process accounts
For more information about the ASP.NET worker process account permissions and about Internet Information Services (IIS) 6.0, click the following article number to view the article in the Microsoft Knowledge Base:

812614 Default permissions and user rights for IIS 6.0

Default file permissions for the SftReporting.udl file
Keywords: kbexpertiseinter kbhowto KB931178

-

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

© Microsoft Corporation. All rights reserved.