Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
billsox
Yak Posting Veteran
74 Posts |
 Posted - 2003-03-19 : 11:19:26
|
| Hi,I'm trying to connect to my company's Analysis server and I keep receiving an error message that says: Cannot connect to the repository. Error: Could not use ''; file already in use.I can only assume that the file it is trying to refer to is the OLAP repository file "msmdrep.mdb". I have no problems opening this database through Windows Explorer and there is no .ldb file that would indicate it is in use by another user. However, in the same directory there is another Access database called "msmdqlog.mdb" which I cannot open (I get a "Could not lock file" error when trying to open it). And there is an .ldb file which indicates that something is currently trying to use its objects.There are no other users that are accessing this server so I can't figure out what's going on. I am thoroughly confused. Any ideas? Perhaps a re-install? Help!Bill |
|
|
cstrong5917
Starting Member
1 Post |
Posted - 2004-01-26 : 17:27:55
|
| Did you ever figure out what caused this problem? |
 |
|
|
mikepre
Starting Member
5 Posts |
Posted - 2004-03-05 : 13:49:11
|
| Kind of late, but this is solved migrating the Olap repository from Access to SQL Server. Open Analysis Manager, right click over the server and there you are.Michael PrendergastDataMart S.A.Chile |
|
|
|
|
|
|
Can't connect to Analysis server