A new registry key in SQL Server 2000 Analysis Services controls server behavior when a pre-SQL Server 2000 Analysis Services SP3 client tries to access the server (905615)

MORE INFORMATION

The new registry value is stored in the following registry subkey: You must create this registry subkey on the server.

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.

Follow these steps, and then quit Registry Editor:

1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following key in the registry:

   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion

3. On the Edit menu, point to New, and then click DWORD.
4. Type ConnectPre80SP3Clients, and then press ENTER.
5. On the Edit menu, click Modify.
6. Type 1, and then click OK.

Depending on the value of the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion registry subkey, the following behavior occurs:

Value	Behavior
The registry subkey does not exist	Pre-SQL Server 2000 Analysis Services SP3 clients can connect to the server. However, the clients may not be able to query SQL Server 2000 Analysis Services.
0	Pre-SQL Server 2000 Analysis Services SP3 clients cannot connect to SQL Server 2000 Analysis Services. This registry value is also known as "secure."
1	Pre-SQL Server 2000 Analysis Services SP3 clients can connect and query SQL Server 2000 Analysis Services. This registry value is also known as "nonsecure."

By default, the registry subkey value is 1. This value allows for backward compatibility.