Hi there,
I am having problems implementing windows integrated security with "openquery", using a linked server, with windows integrated security.
The strange thing is that I can access my cube if signed in as administrator. If however, I set up a new user, and assign him to the Administrators role (in windows 2003), this new user gets an "access denied" message in trying to access the cube! In analysis services, I have given full access to "everyone" as well as this new user. Anyway, the user should have precisely the same rights as "Administrator"....?
To add to the confusion, this situation does not occur on a different server - i.e. I cannot replicate the problem!
Any ideas?
Many thanks in advance
Chris
I am having problems implementing windows integrated security with "openquery", using a linked server, with windows integrated security.
The strange thing is that I can access my cube if signed in as administrator. If however, I set up a new user, and assign him to the Administrators role (in windows 2003), this new user gets an "access denied" message in trying to access the cube! In analysis services, I have given full access to "everyone" as well as this new user. Anyway, the user should have precisely the same rights as "Administrator"....?
To add to the confusion, this situation does not occur on a different server - i.e. I cannot replicate the problem!
Any ideas?
Many thanks in advance
Chris