User '' does not have the required permissions, SSRS 2008 on Windows 8

Question

When you try to log in to the SSRS root site at http: // (server name) / Reports, it displays:

User '' does not have the required permissions. Ensure that you have sufficient permissions and that Windows User Account Control (UAC) restrictions have been removed.

This is a 64-bit version of Windows 8 Pro running SQL Server 2008. Everything should use the local system as the execution account.

I tried to change the execution account as my administrator user, I added the site as a trusted site, my UAC is completely disabled, I tried to get to the site using IE AS ADMIN , Chrome and Firefox. Everything I tried on the site claims that I have no rights. I am switching to SQL Server and guaranteeing that my roles are everything for my user. It does not matter. I am currently reinstalling SSRS node to install SQL Server, but I'm curious if anyone else has this problem.

I will try to change my account to a "local" account, since I think this may be a problem, but I do not understand why SQL Server can fully recognize my login. Honestly, I have never come across this, and I wonder if this is only a problem with Windows 8, access to SQL Server 2008. I would update it, but I have the full version of SQL Server 2008, not 2012, so I don’t I decide to just upgrade if Express 2012 comes with Business Intelligence Development Studio and the SSRS site with tools.

EDIT: 3-8-2016:

• There is no answer with: “Just turn on the site’s settings”, as this is the first time you install the server or machine administrator locally and cannot access the landing page as that administrator.
• There is no answer with: “Just run IE as admin” will work the last time I tested this.
• Answers with the settings "SITE MAY WORK trusted settings" in Windows 8 and higher, since I had a similar problem with Windows 10 and Windows 10, she fixed it. I'm not going to roll back two versions of the OS to check at home, though, sorry.

I do not understand how this question can exist for some time, and people on the mission now declare that it is duplicated when the answer itself is different from the potential duplicate. This whole stream concerns who can get to the site with a higher resolution and simply not create roles and users after the fact. This is the main user who does not get to the landing page as an administrator on the site specified as the default. Not even the same stadium. How to get to the page as an administrator, so that local users in comparison with the highest level of God, which the user did not get, is not the same.

Answer 1

Well, that really annoys what needs to be done, but here.

From what I read in Windows 8, the default admin account is not allowed by default.

Usually I do not use this account, but in this case I was desperate, because my account could not log in.

I understand that ONLY YOU ENTER, you can set the site’s settings, which doesn’t help if you don’t even see the main landing page of the site to see this setting.

The steps I took for the final decision were:

• Remove SSRS Node COMPLETELY by going to Control Panel> SQL Server 2008> Delete> Check Reporting Services
• Enable the default administrator account: command prompt> run as administrator> network user administrator p @ ssw0rD, press enter.
• New line: net user administrator / active: yes
• Reboot
• Reinstall SSRS from disk when logged in as the default administrator.
• Install SP3 as Administrator
• Go to IE.exe RIGHT NOW in Windows 8: C: \ Program Files \ Internet Explorer \ iexplore.exe> ​​Run as administrator.
• Go to http: // (server_name) / Reports
• You MUST now be able to finally see the site settings. NOW YOU CAN VISIT all directions of adding YOUR USER in accordance with the settings of the site. Also go to folder permissions and add the default user here.
• (optional) For security, I would have hidden the default administrator account now, using step 2, but replacing / active: no.

If your chief administrator cannot open the door, no one gets in. That was the main question I had. My default administrator was unable to log in. Now everything works fine and dandy, as when deploying from BIDS.

Answer 2

Everything in this answer is true, but do not reinstall all SSRS errors ...

Windows 8

• Disable UAC
• Enable administrator account (you can go to Control Panel> Computer Management> Users)
• Reboot the computer.
• Run the IE ad administrator when prompted to log in to your local administrator account that you have enabled.
• You will need to configure the protection of site settings and the settings of folders. A simple quick fix simply adds “Everything” to both of them with full rights.

The problem is solved!

Answer 3

I came across the same issue, but with Windows 7 and SQL Server 2008. I solved the problem by following the instructions from the Suresh Kumar blog at http://skamie.wordpress.com/2010/06/24/ssrs-and-uac/

In brief, here are the steps you need to take to solve this problem:

Launch your browser using run as administrator.

Go to Report Manager and in the "Site Settings" → "Security" section, assign your account or group of local administrators to the "System Administration" role.

Then go to your home folder, and according to security settings, assign your account or group of local administrators to the roles of browser, Conent Manager, My Reports, Publisher, and Report Builder.

Now you can start your browser as usual and access SSRS without any problems.

Answer 4

I had the same problem on my Windows 8 system (32-bit) with SQL Server 2008R2. When I started IE using "run as Administrator", it still asked for the username and password and led to the fact that "the user does not have access rights" when I entered my username and password. This is what fixed it for me:

I disabled UAC in the registry (set HKLM \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Policies \ System \ EnableLUA to 0). First I set the notification level in the "Control Panel" | System and Security | Change the user account control to the lowest level, but it does not matter.

After rebooting, I started using IE using "run as Administrator". Went to Report Manager | Site Settings | Security: added my account as a system administrator.

Back in the report manager, I went to Home | Folder settings and added my account in the role of Content Manager.

I turned on UAC through the control panel | System and Security | Change your user account management settings to the default level again. (Reboot required)

When I run IE as an administrator and provide my username and password, it shows the report manager home page.

Answer 5

Launch Internet Explorer as an administrator (right-click the icon on the taskbar)

Step 1 :: Add your local username to the site’s Security Roles page . (Security - System Administrator)

Step 2 :: Add a local username to the Folder Settings on the main page. (Select Content Manager)

Close the administrator IE session. Open IE normally as a user.

Answer 6

Windows 8.1

I solved this with Austin McLaughlin's answer posted earlier. In my case, I logged in with a local account with administrator privileges, but tried to http://127.0.0.1/Reports (hereinafter referred to as "Service Manager reporting"), it gives an error reported by OP.

The key for me was that the administrator account was disabled by default on my Windows 8.1 laptop. Please note that initially I did not have Windows 8.1 Pro, so in the "Computer Management" section there was no "Local Users and Groups". So I had to buy Windows 8.1 Pro Pack through MS for $ 100.

• In Windows Explorer, right-click on the node computer and select Manage.
• Go to local users and groups> Users
• Right-click on "Administrator" and select "Properties"
• Cancel "Account Disabled"
• Reboot the computer.
• Log in to the PC as an administrator (I don’t need to enter a password for the administrator account when I log in for the first time.)
• On your desktop, launch IE. Of course, there is no need to start as an Administrator, since you are logged in as an Administrator.
• Go to Reporting Services Manager.

At this point, you must log in to the report manager and on the main screen. I couldn’t do this before.

9. On the home screen, click "Assign New Role"
10. In the "Group or username" enter the local administrator account that you use for development; ie: [yourmachine] \ [username]
11. Select all the checkboxes (the shortcut should click the checkmark to the left of the "Role") and click "OK".
12. At the top right of the page, click "Site Settings."
13. On the left side of the page, click "Security."
14. Click Assign New Role
15. In the Group or Username field, enter the same account as in step 10
16. Check the box next to "System Administrator" and click "OK"
17. As a precaution, disable the administrator account that was enabled in step 4.
18. Log out, then return to your local account from step 10.
19. In IE, go to Reporting Services Manager. Note. I did not need to run IE as an administrator.

At this point, you will be able to access the Reporting Services Manager page and further configure Reporting Services.

Answer 7

Change the service account type to “ Network Service ” on the service account tab, then stop and start the service and start IE as Administrator.

Answer 8

From the Reporting Services configuration manager, you can go to the node the URL of the report manager . The url works from this screen. Now you can use the folder settings to add yourself as a Content Manager, etc. Now the URL will work for your user.

Answer 9

In IE, simply add the Add Reporting Services website to your Local Intranet sites. What is it.

Answer 10

Just open IE as “Run as administrator” and just enter the URL as http: // localhost / reports