Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 43
  • Last Modified:

Help with permissions Windows User Account Control (UAC)

I've tried so many things up to now.
I'm trying to solve : "Verify that sufficient permissions have been granted and Windows User Account Control (UAC)" on my local report server. I'm unable to see the Home folder to grant permissions, when clicking the "Home" link, nothing happens
0
fadiel ras
Asked:
fadiel ras
  • 10
  • 6
  • 2
1 Solution
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Try running the browser as "Administrator" (Right-click -> Run as Administrator).

Once the Report Manager is up, add your login on the site and on folder settings and give "System Administrator" permissions. You should be all set.
0
 
JohnBusiness Consultant (Owner)Commented:
Are you on a domain?   Go to Network and Sharing Center, Advanced Sharing properties and ensure the network is attached to Private or Domain. Ensure the Home Group is definitely OFF.

Try temporarily disabling your Firewall, restart and test.
0
 
fadiel rasAuthor Commented:
thanks Nakul. I've done that. problem is that I dont see the site settings option. when I click "Home" previously on other machines I would get the Root folder with DataSources, Setting etc. In this case, nothing happens
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
fadiel rasAuthor Commented:
Thanks John. yes on a Domain, but trying to access Localhost. I'll try and advise asap...
0
 
JohnBusiness Consultant (Owner)Commented:
Also check that no extra entries exist in local HOSTS file (C:\windows\system32\drivers\etc.)
The entries in the HOSTS file should be all comments.

Run a full scan with your Antivirus application.
0
 
fadiel rasAuthor Commented:
@John, please clarify >>Ensure the Home Group is definitely OFF.
should I turn it off, then also disable the firewall?
then start IS as an admin?
0
 
JohnBusiness Consultant (Owner)Commented:
Home Group is down at the bottom of the Advanced Settings. There is a choice between (a) Use User accounts and passwords and (b) Home Group. Select User Accounts and Passwords. Make sure the User Account has a password.

Try the above before temporarily disabling the firewall
1
 
fadiel rasAuthor Commented:
@John - no idea what you mean with this >>Also check that no extra entries exist in local HOSTS file (C:\windows\system32\drivers\etc.)
The entries in the HOSTS file should be all comments.
0
 
JohnBusiness Consultant (Owner)Commented:
Navigate to the folder above and open HOSTS with Notepad.
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Since you don't get the Site Settings option, can you confirm that you are a sysadmin on the SQL Server instance where the ReportServer database is hosted?
0
 
fadiel rasAuthor Commented:
@Nakul, yes I am, but will double check. this is fresh installation of SQL2014 Express on this machine
0
 
fadiel rasAuthor Commented:
@John, this  what I see in advanced settings, Homegroup
0
 
JohnBusiness Consultant (Owner)Commented:
Turn Home Group OFF by selecting Use user accounts and passwords. It is a choice, so selecting Use user accounts will turn Home Group OFF.  Home Group is not for use on domains.

Once OFF, you might consider disjoining from and rejoining back to the Domain.
1
 
fadiel rasAuthor Commented:
@Nakal - "Current user's login is a member of the sysadmin role"
0
 
fadiel rasAuthor Commented:
I'm now busy testing this, as I realized I had 2 problems, 1. being the settings issue, but 2. being that I'm prompted to log in when I launch the report server, I think that might be the root cause of my issue
0
 
JohnBusiness Consultant (Owner)Commented:
Test your ideas and then report back. Make sure your login is authorized.
0
 
fadiel rasAuthor Commented:
Solved. Thanks John and Nakal for your prompt responses.
my solution was in the marked answer section here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e8da121a-c0ac-4d0b-8774-abd5128d88fe/ssrs-2008-vista-security-header-only?forum=sqlreportingservices

Issue
When you browse to http://[ComputerName]/Reports it prompts you to login
 
Cause
This is caused by UAC.  Even if you run Internet Explorer as Administrator, once you log in you are no longer running with administrative privileges.

1.     Open Internet Explorer
2.     Click on the "Tools" menu and select "Internet Options"
3.     Click on the "Security" tab
4.     Click once on "Local intranet"
5.     Click on the "Sites" button
6.     Click on the "Advanced" button
7.     Make sure "Require server verification (https:) for all sites in this zone is unchecked.
8.     Add "http://[ ComputerName]" to the Websites list.
9.     Click the "Close" button to close the Advanced window.
10.   Click the “Custom Level” button near the bottom.
11.   Scroll down to the end and you will see the “User Authentication” section.
12.   User “User Authentication” and then “Logon” verify that “Automatic logon only in Intranet Zone” is selected.  If not select it.
13.   Click “OK” to close the Security Settings - Local Intranet Zone window.
14.   Click the "OK" button to close the Local intranet window.
15.   Click the "OK" button to close the Internet Options Window
16.   Close Internet Explorer
17.   Re-open Internet Explorer and browse to http://[ ComputerName]/Reports.  You should no longer be prompted to login.
0
 
fadiel rasAuthor Commented:
found on another thread
0
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 10
  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now