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

Capture9

Than you need to reboot your computer.

I trying login again and it is work Smile

Capture2

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

Capture4

I add new role

Capture5

Capture6

and add security to in Home page open Folder Settings

Capture7

Capture8

Capture3

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

Advertisements
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?

Capture1 

On Windows Server 2003 I open SQL Server Configuration Manager

pic2

Open TCP/IP property window:

pic3

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

pic4 

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

pic5

Finally I connected to my SQL Express

pic6

And now I have data on other side of wire Smile

Hope this help .

Posted in Uncategorized | 1 Comment