May 23, 2005 at 1:59 am
| 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 |
May 24, 2005 at 1:24 am
I'm not sure I fully follow your situation, but I would look to see what account your server's are running under as a service - perhaps the service account of one instance does not have rights to access the other server?
Cheers
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply