We help IT Professionals succeed at work.

Access to BI SQL Server

AXISHK
AXISHK asked
on
236 Views
Last Modified: 2014-11-23
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 ?
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
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
EugeneZSQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
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.

Author

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
SQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Tks
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.