Configure SSL Connections on Report Server(https)

April 1, 2013 Leave a comment

You must have a server certificate installed on the computer. Ask for the certificate to your sysadmins(windows admins), or request a certificate from a trusted certificate authority.

The following steps do not include instructions for requesting, generating, downloading, or installing a certificate. You must have a certificate installed and available to use.

So let’s start.

1. Run Reporting Services Configuration Manager and connect to the reporting server.

2. In Web Service URL section –> SSL Certificate –> choose your certificate –> click Apply.

3. Report Manager URL section –> Advanced button –> Multiple SSL identities for Report Manager section –>

click Add button –> in Certificate choose your certificate and click OK –> OK.

4. Stop and Start your Reporting service, from the first section of the configuration manager.

5. Check that the URL works by indicating https instead of http.

Filed under Reporting Services, SQL Server Tagged with , ,

SQL Server Reporting Services. Error: …Windows User Account Control (UAC) restrictions have been addressed

February 8, 2013 1 Comment

Error:
User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Solution:

1. Run IE as Administrator:

image

2. Go to the Reporting Services address: http://localhost/Reports

3. Go to the Site Settings:

image

4. In Security section –> click New Role Assignment

image

5. Add username or group that you want to grant permissions and choose appropriate role:

image

6. Go to the Home page and click Folder Settings:

image

7. Add username or group that you want to grant permission.

That’s all.

Filed under DB, Reporting Services, SQL Server Tagged with , ,

SQL Server Reporting Services. Error: …Windows User Account Control (UAC) restrictions have been addressed

February 8, 2013 1 Comment

Error:
User ‘DomainUser’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Solution:

1. Run IE as Administrator:

image

2. Go to the Reporting Services address: http://localhost/Reports

3. Go to the Site Settings:

image

4. In Security section –> click New Role Assignment

image

5. Add username or group that you want to grant permissions and choose appropriate role:

image

6. Go to the Home page and click Folder Settings:

image

7. Add username or group that you want to grant permission.

That’s all.

Filed under DB, Reporting Services, SQL Server Tagged with , ,

Migrate SQL Server Reporting Services to another server

February 8, 2013 Leave a comment

Here are the steps how to migrate RS to another server using same database release. For example: From SQL Server 2008-> to SQL Server 2008.

1. Install Database and Reporting Services on target server. If you have just database service installed , you can add Reporting Service by running SQL Server Installation Center:

image

follow the steps and check Reporting Services box for installation.

2.  Backup Reporting Service databases on source server, for me they are: ReportServer and ReportServerTempDB.

3. Backup Encryption Key on source server.

Run Reporting Services Configuration Manager:

image

Connect to the  Reporting Server –> Go to the Encryption Keys section and click Backup button.

image

It will ask you for the password , which will be needed for the restoration on target server.

4. Restore ReportServer and ReportServerTempDB databases(backed up in the 2-nd step) with the overwrite option on the target server.

5. On target server go to the Reporting Services Configuration Manager –> Encryption Keys section and restore the key. (Enter the password, when prompted, which you have indicated during backup of the key on source server )

Note, in Database section reporting service should point to the database named ReportServer .

You should now navigate to the reporting service address: http://target_server_hostname:80/Reports.

Filed under DB, Reporting Services, SQL Server Tagged with , , ,