This is a discussion on Re: Unable to connect to Analysis Server within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> if you want to use analysis manager please make sure of the following 1. that your client has the ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| if you want to use analysis manager please make sure of the following 1. that your client has the same AS SP loaded as the server 2. that the SERVER has a share called msolaprepository$ created on c:/program files/microsoft analysis services/bin folder 3 that the security properties on that FOLDER have olap administrators listed for all permissions 4. that the user connecting to the server is a member of the olap administrators group on the server If all 4 are Yes it will work Regards Reg "Kristofer Gafvert" <kgafvert@NEWSilopia.com> wrote in message news:uh2FTQRYDHA.2548@TK2MSFTNGP09.phx.gbl... > Just installed the Analysis Service (for the first time, trying to > understand it). However, when i try to connect to my server (in Analysis > Manager, Console Root/Analysis Servers/<myServerName>) i get this error > message: > > "Unable to connect to the registry on the server (myServerNameHere), or you > are not a member of the OLAP Administrators group on this server." > > I have verified that i am in the group OLAP Administrators. I'm logged on to > the machine with an account that is a member of the group Administrators, so > i should have full access to the registry. What makes this even more strange > is that i sometimes (not very often!) can access the server, just a few > seconds after a failed attempt, but it is not working as expected. For > example, if i try to view the Data tab for a cube, i get: "Unspecified > Error". So i think there are some kind of security problems here too. But > what is the problem? Everything is running locally, both SQL Server and > Analysis Server. > > I've tried to reinstall Analysis Server. > I've tried to logon as Administator, still the same error message. > I've tried to change the account used by MSSQLServerOLAPService to an > account with administrator privilegies (saw that you had to do something > like that if you did not use the default settings when installing, but i did > use default for everything). > > Anyone have any tips for this? I would like to keep on reading my book, but > for now i'm stuck on the first chapter :-( > > -- > Regards, > Kristofer Gafvert (dial-up for the moment - posts might be delayed) > http://www.ilopia.com - My personal Web Site, with information about things > i find interesting, for example Windows Server 2003. > Reply to newsgroup only. Remove NEWS if you must reply by email, but please > do not. > > > |