INF: Running OLAP Services on a Domain Controller

Article translations Article translations
Article ID: 273836 - View products that this article applies to.
This article was previously published under Q273836
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

SUMMARY

This article contains information about the Microsoft SQL Server OLAP Services 7.0 and Microsoft SQL Server 2000 Analysis Services installation limitations on a Microsoft Windows 2000- or Microsoft Windows NT-based domain controller.

SQL Server Books Online incorrectly states that OLAP Services 7.0 and Analysis Services are not supported on a domain controller. This configuration is supported by Microsoft Product Support Services.

MORE INFORMATION

You can successfully use and install OLAP Services 7.0 and Analysis Services on a domain controller, but there are some limitations to the security model. Microsoft does not recommend this configuration.

Warnings

  • The OLAP Administrators security group is created as a global group, not a local group.

    This might be a potential security issue if users are not restricted. For more information about the global group and the local group, search Windows 2000 Help.
  • Microsoft recommends that you do not run memory-intensive applications from a domain controller. Depending on the size of your cubes, online analytical processing (OLAP) uses a lot of system memory and therefore takes resources from the computer's primary function as a domain controller. This might adversely affect the whole domain.

Properties

Article ID: 273836 - Last Review: February 28, 2014 - Revision: 4.4
APPLIES TO
  • Microsoft SQL Server 2000 Analysis Services
  • Microsoft SQL Server OLAP Services
Keywords: 
kbnosurvey kbarchive kbinfo KB273836

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com