Microsoft KB Archive/931178

Knowledge Base

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

---

SUMMARY

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:

1. Open the following folder:

   %ProgramFiles%\Softricity\SoftGrid Reporting Service

2. Right-click SftReporting.udl, and then click Properties.
3. Click the Provider tab.
4. Make sure that Microsoft OLE DB Provider for ODBC Drivers is selected.
5. Click the Connection tab.
6. In Specify the source of data box, make sure that Use data source name is selected.
7. In the Use data source name box, make sure that SoftGridReporting appears.
8. In the User name box, confirm the user name.
9. In the Password box, confirm the password.
10. Make sure that the Allow saving password check box is selected.
11. In the Enter the initial catalog to use box, make sure that the name of the database that you are using appears.
12. Click the Security tab.
13. 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 "Information about ASP.NET worker process accounts" section.

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: <user></user>
• Password: <password></password>
• Database name: <service></service>

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:

1. Open the following folder:

   %ProgramFiles%\Softricity\SoftGrid Reporting Service

2. On the File menu, click New, and then click Text Document.
3. In New Text Document.txt box, type SftReporting.udl.
4. Right-click SftReporting.udl, and then click Properties.
5. Click the Provider tab.
6. Click Microsoft OLE DB Provider for ODBC Drivers.
7. Click the Connection tab.
8. Under Specify the source of data, click Use data source name. Then, type SoftGridReporting.
9. In the User name box, type the user name.
10. In the Password box, type the password.
11. Click to select theAllow saving password check box.
12. Under Enter the initial catalog to use, type the name of the database that you are using.
13. Click the Security tab.
14. Click Advanced.
15. 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.
16. 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.
17. Click OK, and then click Yes next to You have denied all user access to SftReporting.udl.
18. Click Add.
19. Under From this location, click Locations.
20. Click the computer name, and then click OK.
21. Under Enter the object names to select, type Administrators, and then click OK.
22. Click Administrators (COMPUTERNAME\Administrators).
23. Click to select the Full Control check box in the Allow column.
24. 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 "Information about ASP.NET worker process accounts" section.

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: <user></user>
• Password: <password></password>
• Database name: <service></service>

How to test the SftReporting.udl file

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.

Information about ASP.NET worker process accounts

Operating system	Role	ASP.NET work process account
Microsoft Windows 2000 Server	Member server	ASP.NET Machine Account (ComputerName\ASPNET)
Microsoft Windows Server 2003	Member server	ASP.NET Machine Account (ComputerName\ASPNET)
Windows 2000 Server	Domain controller	Launch IIS Process Account (DomainName\IWAM_ComputerName)
Windows Server 2003	Domain controller	NETWORK SERVICE

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

Name	Permission
Administrators (ComputerName\Administrators)	Full control
ASP.NET Machine Account (ComputerName\ASPNET)	Read
IIS_WPG (ComputerName\IIS_WPG)	Read
Launch IIS Process Account (COMPUTERNAME\IWAM_ComputerName)	Read
LOCAL SERVICE	Read
NETWORK SERVICE	Read
SYSTEM Full Control	Full Control

Keywords: kbexpertiseinter kbhowto KB931178

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.