You receive a "Microsoft OLE DB Provider for ODBC Drivers error '80004005'" error message when you try to start the Web Reporting tool in Systems Management Server 2.0 (841922)


The information in this article applies to:

  • Microsoft Systems Management Server 2.0

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:
  1. Click Start, point to Programs, point to Administrative Tools, and then click Internet Services Manager.
  2. Expand server name\Default Web Site, where server name is the computer name of your server.
  3. Right-click SiteDB_SMS_site code, where site code is the three character code of your SMS site, and then click Properties.
  4. Click the Virtual Directory tab and make sure that Execute Permissions is set to Scripts only or to Scripts and Executables.
  5. Click Configuration. If you cannot click Configuration, click Create, and then click Configuration.
  6. 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:
    1. Click Add.
    2. Click Browse, locate the %windir%\System32\Inetsrv\Asp.dll file, and then click Open.
    3. In the Extension text box, type .asp.
    4. Click Limit to, type GET,HEAD,POST,TRACE, and then click OK.
  7. On the App Options tab, make sure that Enable session state is turned on (checked).
  8. Quit the Internet Information Services snap-in.
  9. Click Start, point to Programs, point to Administrative Tools, and then click Services.
  10. Stop and then restart the World Wide Web Publishing Service to commit the changes to the metabase on the Internet Information Services (IIS) server.

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.
Modification Type:MinorLast Reviewed:6/13/2005
Keywords:kbReport kbDatabase kbsmsUtil kberrmsg kbtshoot kbMiscTools kbprb KB841922 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.