RSS

SSRS Report Server Settings Validation Error

28 Jan

Issue:

I’m trying to validate  report server setup of a client and got the error below
Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager.

image

Solution:

After some troubleshooting, it turns out UAC was not turned off. I am running on MS Windows Server 2012.

UAC has to be turned off via registry by changing the DWORD “EnableLUA” from 1 to 0 in “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system”. You will get a notification that a reboot is required. After the reboot, UAC is disabled.

After UAC is disabled, the issue is resolved.

Steps :

Windows 2008:
Deactivating UAC in Windows 2008 R2 was possible via running msconfig (for example winkey+r -> msconfig), going to the Tools tab and launching “Change UAC settings”. There, you select “Never notify” to disable UAC.

Windows Server 2012:
The same approach is still available in Windows Server 2012, though UAC is still active after you selected “Never notify”. You have the option to turn off UAC via registry by changing the DWORD “EnableLUA” from 1 to 0  in “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system”. You will get a notification that a reboot is required. After the reboot, UAC is disabled.

STEP 1: Go to UAC

image

STEP 2: Change to “Never notify”

STEP 3: Change “EnableLUA” to 0

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system

image

Advertisements
 
1 Comment

Posted by on January 28, 2015 in Development, General, Report

 

Tags: , , , , , ,

One response to “SSRS Report Server Settings Validation Error

  1. techguns.wordpress.com

    August 29, 2015 at 8:47 am

    Hello ,

    You can open AX ‘Run As Administrator’ and validate. As per mine its not required to change registries.

    Regards.,
    Ravi Theja Madisetty
    https://techguns.wordpress.com

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: