How to use RDS from an IIS 4.0 virtual server (184606)


The information in this article applies to:

  • Remote Data Service for ADO 2.1 SP2
  • Remote Data Service for ADO 1.5
  • Remote Data Service for ADO 2.0
  • Remote Data Service for ADO 2.01
  • Remote Data Service for ADO 2.1
  • Remote Data Service for ADO 2.1 SP1
This article was previously published under Q184606
We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx

SUMMARY

When adding a second virtual server within Internet Information Server (IIS) version 4.0, you may see the following error:
8447 - Internet Server Error
Additional steps must be taken for Remote Data Service (RDS) to work with a second virtual server.

MORE INFORMATION

In the following scenario the main server is called myserver and is located at this home directory: 
   C:\InetPub\wwwroot
The second virtual server is called myserver2 and is located at this home directory: 
   C:\vserver2
The following steps may be used to make RDS work on the second virtual server (myserver2).

Note Adding the "Execute Access (Including Script)" permission to a directory will allow users to execute scripts on the Web server.
  1. Using Windows Explorer create a MSADC folder under C:\vserver2.
  2. Using the IIS Management Console create a virtual directory called MSADC in myserver2. Point the MSADC directory to the C:\vserver2\msadc directory.
  3. Copy the Msadcs.dll file into C:\vserver2\msadc.
  4. The MSADC virtual directory should be given "Execute Access (Including Script)" permission. To do this, right-click the virtual directory and click properties. Select the virtual directory tab. Under Permissions, you will see the different permissions possible for the directory.
Use the steps below to confirm whether RDS is working on the virtual server:
  1. Copy the Adctest.asp and Ssdatb32.cab from the C:\Program Files\Common Files\system\msadc\samples folder to the myserver2 virtual directory root, C:\vserver2.
  2. Change the IIS 4.0 properties of myserver2 to allow Script execution. To do this, right-click the Virtual Server myserver2 within the IIS Management Console and click Properties. Select the Home Directory Tab, and then set the "Application Settings Permission" to Script.
  3. Access the Adctest.asp file from the browser: 
          http://myserver2/adctest.asp

REFERENCES

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

165180 How to create a virtual server

251122 Troubleshooting common problems with Remote Data Services

Internet Information Server version 4.0 documentation

For additional information, please see the following World Wide Web URL:

http://msdn.microsoft.com/dataaccess

Modification Type:MajorLast Reviewed:9/10/2005
Keywords:kbConfig kbhowto KB184606 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.