Microsoft KB Archive/888526

= How to set up application names in SQL Server 2000 Analysis Services =

Article ID: 888526

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services
 * Microsoft SQL Server 2000 Analysis Services

-



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



INTRODUCTION
This article describes how to set up application names in Microsoft SQL Server 2000 Analysis Services.



MORE INFORMATION
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.</li></ol> </li> Click Start, click Run, type regedit, and then click OK.</li> Locate and then click the following subkey in the registry:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters

</li> On the Edit menu, point to New, and then click DWORD.</li> Type DisableStrictNameChecking, and then press ENTER.</li> On the Edit menu, click Modify.</li> Type 1, and then click OK.</li> Quit Registry Editor.</li></ol>

If you do not follow all these steps, you may receive the following error message when you try to connect to the Analysis Services instance by using the CNAME alias:

Bad file name or number

<div class="references_section">