You Receive an Error Message When You Try to Register or Connect to an Analysis Services Computer as a Domain User (829738)
The information in this article applies to:
- Microsoft SQL Server 2000 Analysis Services, when used with:
- the operating system: Microsoft Windows 2000
SYMPTOMSWhen 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: <servername>
Error: Could
not use ''; file already in use.
CAUSEThis 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
<driveletter>:\Program Files\Microsoft Analysis
Services\Bin\Msmdrep.mdb. - The user does not have the
required share permissions for the \\<AnalysisServicesComputerName>\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.
RESOLUTIONIf 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:
- Click Start, point to
Programs, point to Microsoft SQL Server,
point to Analysis Services, and then click Analysis
Manager.
- In the Analysis Manager tree pane, expand Analysis Servers.
- Right-click the server whose Analysis Services repository
database you want to migrate, and then click Migrate Repository.
- 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 \\ <AnalysisServicesComputerName>\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: - Right-click My Computer, and then click
Manage.
- In the Computer Management tree pane,
expand System Tools, expand Shared Folders,
and then click Shares.
- In the right pane, right-click
MsOLAPRepository$, and then click
Properties.
- Click the Share Permissions tab, and then make sure
that Administrators and OLAP Administrators
have been added.
- Assign Full Control permissions to the Administrators group and the OLAP
Administrators group.
- 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
Modification Type: | Major | Last Reviewed: | 11/20/2003 |
---|
Keywords: | kbprb kberrmsg KB829738 kbAudDeveloper |
---|
|