Access to BI SQL Server

User 'XXXXXX' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

user has already assigned with "System Administrator"  and "System User" and start IE in administrator. But it still encounters the same error. any idea ?
AXISHKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
How are they trying to access the database?
Through SQL Management Studio, a reporting tool, a web page?

Which BI tool are you using?

mlmcc
0
Eugene ZCommented:
please clarify what and how this user try to access.  also post what sql server 2008 edition and service pack  you have.. more details is better.
0
AXISHKAuthor Commented:
It is SQL 2012 server. The user try to access the SSRS 2012 but it returns with the attached error.
SSRS.png
SSRS-1.png
SSIS-2.png
0
Eugene ZCommented:
it sounds like known bug:

/check this MS bug workaround from the below post link/


Start with Service pack for sql 2012 installation if you have not installed yet).

If you configured SSRS properly and you can access all pages and just some user can not.

please make sure that user is on the same network as your SSRS box and his\her AD login (domain\XXXX )was added to the SSRS  "System Administrator"  roles.
Or just as a  temp \test solution, you'll need to grant local administrator access to the machine that SSRS is installed on since it automatically has system-wide admin rights in report manager this user will access SSRS link,

also check this MS bug workaround

User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
https://connect.microsoft.com/SQLServer/feedback/details/622737/user-does-not-have-required-permissions-verify-that-sufficient-permissions-have-been-granted-and-windows-user-account-control-uac-restrictions-have-been-addressed
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AXISHKAuthor Commented:
Tks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.