Microsoft KB Archive/841922

= You receive a &quot;Microsoft OLE DB Provider for ODBC Drivers error '80004005'&quot; error message when you try to start the Web Reporting tool in Systems Management Server 2.0 =

Article ID: 841922

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-





SYMPTOMS
When you try to connect to the Systems Management Server (SMS) 2.0 Web Reporting tool, you receive the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /sitedb_sms_cll/Manage/Manage1.asp, line 14



CAUSE
This error may occur when one of the following conditions is true:
 * The properties of the Web application are missing.
 * The properties of the Web application are incorrect.
 * The Execute permissions for the Web application are set to None.
 * The .asp extension is not mapped in the Web application properties.



RESOLUTION
To resolve this problem, follow these steps:  Click Start, point to Programs, point to Administrative Tools, and then click Internet Services Manager. Expand  \Default Web Site, where  is the computer name of your server. Right-click SiteDB_SMS_ , where  is the three character code of your SMS site, and then click Properties. Click the Virtual Directory tab and make sure that Execute Permissions is set to Scripts only or to Scripts and Executables. Click Configuration. If you cannot click Configuration, click Create, and then click Configuration. Click the App Mappings tab and make sure that you have a mapping for the .asp extension. If .asp is not in the Application Mappings list, follow these steps: <ol style="list-style-type: lower-alpha;"> Click Add.</li> Click Browse, locate the %windir%\System32\Inetsrv\Asp.dll file, and then click Open.</li> In the Extension text box, type .asp .</li> Click Limit to, type GET,HEAD,POST,TRACE, and then click OK.</li></ol> </li> On the App Options tab, make sure that Enable session state is turned on (checked).</li> Quit the Internet Information Services snap-in.</li> Click Start, point to Programs, point to Administrative Tools, and then click Services.</li> Stop and then restart the World Wide Web Publishing Service to commit the changes to the metabase on the Internet Information Services (IIS) server.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
When you install the SMS Web Reporting Utility, the Setup program prompts you for the server name and the database name. The Setup program creates a new Microsoft SQL Server logon account, and then assigns rights to the account. The Setup program uses the server and account information to write the Global.asa file at the root of the Web folder.

The connection information is contained in session-level variables. Because they are session variables, the values can be used by any Web page in the Web application. The session variables are initialized on each new user connection to the Web application. By default, Web application sessions are active for twenty minutes.

In the Internet Services Manager, Web folders and Web applications appear as sub folders under Default Web site. You can modify the Web application properties to interpret server content for clients. For example, .asp Web pages are sent to an interpreter such as Asp.dll that renders plain HTML code and then returns the information to the Web browser. Asp.dll also manages the Web application in the Web folder. The SMS Web Reporting tool uses the Global.asa file to establish session variables. The session variables are used by .asp pages to query the database.

Keywords: kbreport kbdatabase kbsmsutil kberrmsg kbtshoot kbmisctools kbprb KB841922

-

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

© Microsoft Corporation. All rights reserved.