Configuration fails to create SQL Server Analysis database if the SQL server has been renamed - TC/TCE Process Automation for PeopleSoft - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - Essential - Premier - Standard - external - Standard - Essential - Premier

TC/TCE Process Automation for PeopleSoft

Platform
OnBase
Product
TC/TCE Process Automation for PeopleSoft
Release
Foundation 23.1
License
Standard
Essential
Premier

Problem

If you have renamed the computer on which you installed SQL Server Analysis Server, the configuration program fails when it tries to create the new SQL Server Analysis database and an error similar to the following is generated:

Cannot connect to the repository.

Analysis server: <machine name>

Error:

'\\<machine name>\MsOLAPRepository$\msmdrep.mdb' is not a valid path.

Make sure that you correctly spell the path name and that you are connected to the server on which the file resides.

Cause

The configuration program is unable to determine the new name of the computer on which you installed SQL Server Analysis Server.

Resolution

Perform the following manual steps to update Analysis Server with the new computer name:

  1. Click Start, point to All Programs, point to Microsoft SQL Server, point to Analysis Services, and then click Analysis Manager.
  2. In the Analysis Manager navigation panel, double-click the Analysis Servers node to expand it.
  3. Right-click the server with the repository connection string you want to edit, and then select Edit Repository Connection String.
  4. In the Edit Repository Connection String dialog box, verify the server name in this string and update it to the new computer name if it is incorrect.
  5. Navigate to the following location: <installation directory>\Program Files\Microsoft Analysis Services\Bin.
  6. Right-click the Bin folder, and then click Sharing and Security. The Bin Properties dialog box appears.
  7. In the Bin Properties dialog box, click the Sharing tab to verify that all Online Analytical Processing (OLAP) administrators have full permissions to this folder.