How to set up application names in SQL Server 2000 Analysis Services (888526)


The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services
  • Microsoft SQL Server 2000 Analysis Services 64 bit
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.
  1. 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:
    1. Start the DNS snap-in.
    2. In the left pane of the snap-in, click the DNS Server object for your server, and then expand the server object.
    3. Expand Forward Lookup Zones.
    4. Right-click the zone that you want, and then click New Alias (CNAME). For example, right-click example.com.
    5. In the Alias name box, type the alias that you want. For example, type ftp.
    6. 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.
  2. Click Start, click Run, type regedit, and then click OK.
  3. Locate and then click the following subkey in the registry:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters

  4. On the Edit menu, point to New, and then click DWORD.
  5. Type DisableStrictNameChecking, and then press ENTER.
  6. On the Edit menu, click Modify.
  7. Type 1, and then click OK.
  8. Quit Registry Editor.
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

REFERENCES

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

281308 Connecting to SMB share on a Windows 2000-based computer or a Windows Server 2003-based computer may not work with an alias name

Modification Type:MajorLast Reviewed:5/9/2006
Keywords:kbinfo kbhowto KB888526 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.