Author Archives: Andriy

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:

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

I can not login before becouse 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 Continue reading

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 , 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

Hope this help . Continue reading

Posted in Uncategorized | 1 Comment