Author Archives: Andriy
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
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