This article has been archived. It is offered "as is" and will no longer be updated.
Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows registry
This article describes how to set up application names in Microsoft SQL Server 2000 Analysis Services.
On computers that are running Microsoft SQL Server 2000 Analysis Services, you can set up application names. With application names, you can connect to Analysis Services by using an alias name. It is useful to set up application names in disaster-recovery situations when a standby server has the same analysis data as the production server. When you promote the standby server to production server, you move the alias name to the standby server in the Domain Name System (DNS). In this scenario, clients are then redirected to the standby server.
To set up SQL Server 2000 Analysis Services to use application names, follow these steps.
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
Create a CNAME or a Canonical Name record in DNS. This record name is the host name of the production Analysis server. A CNAME is an alias or an additional host name that is resolved to the IP address of an existing host computer in the DNS namespace. For example, if you use the same computer as both a Web server and an FTP server, you may want to resolve both the Web host name and the FTP host name to the same IP address. By using a CNAME, you can resolve both names to the same IP address. To create a CNAME, follow these steps:
Start the DNS snap-in.
In the left pane of the snap-in, click the DNS Server object for your server, and then expand the server object.
Expand Forward Lookup Zones.
Right-click the zone that you want, and then click New Alias (CNAME). For example, right-click example.com.
In the Alias name box, type the alias that you want. For example, type ftp.
In the Fully qualified name (FQDN) for target host box, type the fully qualified host name of the host computer that you want, and then click OK. For example, type www.example.com, and then click OK.
Click Start, click Run, type regedit, and then click OK.
Locate and then click the following subkey in the registry: