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 |
|
kmistic
Starting Member
40 Posts |
 Posted - 2004-08-04 : 15:49:08
|
| hello,I am having trouble connecting to Analysis Services Server only when another person is already connected. When he is connecting and i try to connect i get the error. Cannot Connect to the repository Analysis server: <servername> Error: Could not use:;file already in use.This only happens when the other person is already connected. I connect fine if the other person is not connectedMy guess is it has something to do with him having it opened exclusively, but i have no idea how or where to change that.Any Ideas? |
|
|
NicoNel2000
Starting Member
12 Posts |
Posted - 2004-08-05 : 10:57:05
|
| Migrate the repository to SQL Server.Default = Repository is an access database.To do: Analysis Services, right-click your server and select Migrate Repository.To view your current repository string (to see what repository are currently used) select "Edit Repository String" instead.Hope this helped |
 |
|
|
kmistic
Starting Member
40 Posts |
Posted - 2004-08-05 : 13:28:46
|
| I think that worked... thanks alot |
|
|
|
NicoNel2000
Starting Member
12 Posts |
Posted - 2004-08-06 : 02:06:31
|
| Cool...Glad I could help.Just make sure the repository (only 2 tables), is now in a database that get backed up. |
|
|
|
|
|
|
Cannot connect to repository