Microsoft KB Archive/829738

= You Receive an Error Message When You Try to Register or Connect to an Analysis Services Computer as a Domain User =

Article ID: 829738

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services, when used with:
 * Microsoft Windows 2000 Standard Edition

-



SYMPTOMS
When a domain user tries to register or connect to a Microsoft SQL Server 2000 Analysis Services computer by using Analysis Manager, the domain user may receive an error message that is similar to the following:

Cannot connect to the repository.

Analysis server:

Error:

Could not use ''; file already in use.



CAUSE
This error message occurs most frequently when the OLAP repository is in a Microsoft Access database. However, the error message may occur for any one of the following reasons:
 * The OLAP repository database is in an Access database.

Note By default, the OLAP repository database is :\Program Files\Microsoft Analysis Services\Bin\Msmdrep.mdb.
 * The user does not have the required share permissions for the \\ \msolaprepository$ hidden share path on the Analysis Services computer.
 * The user is not a member of the local Administrators group for the Analysis Services computer.
 * The OLAP repository database may be exclusively opened by a user.



RESOLUTION
If the error message occurs because the OLAP repository database is in an Access database, you must migrate the OLAP repository database from an Access database to a Microsoft SQL Server database to resolve this problem. To do so, follow these steps from the Analysis Services computer:
 * 1) Click Start, point to Programs, point to Microsoft SQL Server, point to Analysis Services, and then click Analysis Manager.
 * 2) In the Analysis Manager tree pane, expand Analysis Servers.
 * 3) Right-click the server whose Analysis Services repository database you want to migrate, and then click Migrate Repository.
 * 4) Follow the instructions in the wizard.

Note Make sure that there is a SQL Server database on the Analysis Services computer where you want to migrate the default OLAP repository database.

If the error message occurs because the user does not have the required share permissions for the \\ \msolaprepository$ hidden share path on the Analysis Services computer, you must provide the required share permissions for that share path to resolve this problem. To do so, follow these steps from the Analysis Services computer:
 * 1) Right-click My Computer, and then click Manage.
 * 2) In the Computer Management tree pane, expand System Tools, expand Shared Folders, and then click Shares.
 * 3) In the right pane, right-click MsOLAPRepository$, and then click Properties.
 * 4) Click the Share Permissions tab, and then make sure that Administrators and OLAP Administrators have been added.
 * 5) Assign Full Control permissions to the Administrators group and the OLAP Administrators group.
 * 6) Click OK.

If the error message occurs because the user is not a member of the local Administrators group for the Analysis Services computer, you must make sure that the domain user is a member of the Administrators group on the Analysis Services computer. If the domain user is not a member of the Administrators group, add the domain user as a member of that group to resolve this problem.

If the error message occurs because the OLAP repository database may be exclusively opened by a user, make sure that the OLAP repository database is not open in exclusive mode by any user. For additional information about how to determine which user has opened a database exclusively, click the following article number to view the article in the Microsoft Knowledge Base:

289580 ACC2002: Determining Which User Has Opened a Database Exclusively



MORE INFORMATION
If the Analysis Services computer is a domain controller, use Active Directory Users and Computers to add a user to a group. If the Analysis Services computer is not a domain controller, use Local Users and Groups in the Computer Management utility.

For more information about Active Directory Users and Computers, follow these steps:
 * 1) Click Start, and then click Help.
 * 2) Click the Index tab, and then type Active Directory Users and Computers.

For more information about Local Users and Groups in the Computer Management utility, follow these steps:
 * 1) Click Start, and then click Help.
 * 2) Click the Index tab, and then type Local Users and Groups.

For additional information about the permissions that you must have to administer an OLAP Server, click the following article number to view the article in the Microsoft Knowledge Base:

231951 INF: Permissions That You Must Have to Administer an OLAP Server

Keywords: kbprb kberrmsg KB829738

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.