Troubleshooting Server (Analysis Server)
What problem are you having?
When you try to register an Analysis server in Analysis Manager, Analysis Manager displays the following error message: "Cannot open connection to Analysis server servername. Network error servername".
Cause: MSSQLServerOLAPService is not started on the specified server.
Solution: Start MSSQLServerOLAPService on the server. To do this, use the Services application, which is in Control Panel in Microsoft® Windows NT® 4.0 or the Administrative Tools folder in Control Panel in Windows 2000.
If the service is already started, you may not have permissions on the server computer to administer Microsoft SQL Server™ 2000 Analysis Services (see Troubleshooting Security (Analysis Server)).
Cause: The computer name has been changed, the network card has been replaced, or other changes have been made to the computer.
Solution: Reinstall Analysis Services.
Cause: The password has been changed for the logon account used by Analysis Services.
Solution: Change the logon account password for Analysis Services. To do this, use the Services application, which is in Control Panel in Windows NT 4.0 or the Administrative Tools folder in Control Panel in Windows 2000.
Cause: The first word in the name of the root folder for Analysis Services is duplicated among root folder names on the same disk. For example, Analysis Services is installed in the Program Files root folder and another root folder named Program exists.
Solution: Rename the root folder that does not contain Analysis Services.
Cause: The current display font does not support the full character set for the language in use, specifically characters in the extended ASCII character set. Analysis Services uses the system's Icon font setting for the majority of its user interface display.
Solution: Change the display font to one that supports the extended character set for the language in use:
- Run the Display application in Control Panel, and then click the Appearance tab.
- Select Icon in the Item list and then, under Font, select a font that supports the extended ASCII character set, such as Times New Roman or Tahoma.
MSSQLServerOLAPService failed to start, and the system displayed the following error message: "Cannot obtain server's start directory from registry".
Cause: If the path of the data directory contains more than 102 characters, Analysis Services cannot start.
Solution: During installation, make sure that the size of the path of the Data directory is limited to 102 characters. You can change the path after installation by using the Data folder box in the Properties dialog box for the server.