Unable to connect to remote server (SSRS)

I attempted to log into a new installation of SSRS Manager and received an error : Unable to connect to remote server .

This is what I did to fix the issue:

I went to C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config file.

I changed the value for the SecureConnectionLevel key to 0. It was previously set to 2.

<Add Key ="SecureConnectionLevel" Value="0"/>

I logged back into SSRS Manager and was able to after that.

SSRS - Default to All without using Multi-Values

I was helping a client and stumbled upon this.

http://dataqueen.unlimitedviz.com/2011/06/how-to-default-to-all-in-an-ssrs-multi-select-parameter/

SSRS the operation you are attempting requires a secure connection (https)

I stumbled upon an issue where SSRS was not HTTPS but could kept getting the following error:

 The operation you are attempting requires a secure connection (https)

Here is what I did to fix the issue.

Update the RSReportServer.config file using the following steps:

1. In Windows Explorer, locate the ReportServer directory. The following path is the default path of this directory: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer
2. Right-click RSReportServer.config, click Open With, click Notepad and then click OK.
3. Locate the following Add Key entry: <Add Key="SecureConnectionLevel" Value="2"/>
4. Change the Value setting from 2 to 0.

SSMS 2012 Report Security Bug

Looks like in SQL Server 2012 there is an issue with some base reports that come with SSMS. Here is a link that provided me guidance.

http://dbfriend.blogspot.com/2012/10/ssms-report-security-bug.html?goback=%2Egde_137774_member_177201860

How to disable SQL 2005/2008/2008 R2 Splash Screen for SQL Server Management Studio.

Are you tired of waiting for the Splash Screen to go away when launching SQL Server Management Studio. Well here is how you can get rid of it.

Go to the Properties of the SQL Server Management Studio Shortcut.

add a space to the end of the "Target:" and type -nosplash

Congratulations you have now disabled the Splash Screen.

SSRS - UAC Error on "First" login.

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.

After you login the first time to SSRS you probably get the error message above. Well to fix this you can do the following.

1) Right click on Internet Explorer and run in Adminstrator mode
2) Type in the address localhost/reports
3) You will now be able to add the user to Site Settings and Folder Options.

Here is a reference link with screen captures.


http://www.soheib.com/technical-knowledge/sql-server-2012-reporting-services-uac-user-access-control/

Fifa 2012 - Playing online w/Guests vs. Online Friend

The person with the Guests - Start a head to head match.

The Online person - Wait on the Xbox Live screen with the friend. When the friend creates the game "Join Session in progress" as fast as possible.