SQL 2008 R2 Reporting Services if you do not have permission to view reports in IE

I have some problem with viewing reports in Internet Explorer and always get this message when I log in: Sad smile

User ‘YOUR-PC\YOU’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

After spending many hours to reading documentation and many websites how to resolve this problem I try my solution. So as we see message show we do not have permission to view reports because UAC restriction. Try to turn off UAC restriction by  typing UAC in Start->Search Programs and Files and you will see Change User Account Control settings click it or go to Control Panel –> User Accounts and Family Safety –> User Accounts and click Change User Account Control settings, you get

Turn it OFF


Than you need to reboot your computer.

I trying login again and it is work Smile


I can not login before because there was only BUILTIN\Administrator


I add new role



and add security to in Home page open Folder Settings




After adding Roles and Security  go back to UAC control and put slider on previous position(restore UAC to original state), reboot computer and try login again. Now you must login to Reporting Service

Hope this help , thanks Smile

Posted in Uncategorized | Leave a comment

Connect to SQL 2008 Express running on Windows Server 2003 through home network

I installed SQL 2008 R2 on Windows Server 2003 and try to connect through my home network, from my laptop running Windows 7 Pro, to SQL Express using SQL Server Management Studio on my laptop

In Server name select <Browse for more…> , and I see only Windows Server name.  Where is SQL instance?


On Windows Server 2003 I open SQL Server Configuration Manager


Open TCP/IP property window:


This is what I get after installing SQL Express, TCP use port 1229 (IPALL)

After working around this problem I add sql instance to windows server and specify port 1229 after comma


And use SQL Server Authentication (you must setup Authentication on Express and open port through firewall) 


Finally I connected to my SQL Express


And now I have data on other side of wire Smile

Hope this help .

Posted in Uncategorized | 1 Comment