For more information about this error navigate to the report server on the local server machine, or enable remote errors

Issue Description

I was getting the below error on a SharePoint page which had SQL Server Reporting Services Report Viewer web part on it

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Fix

Enable Remote Errors for a SharePoint Site

1. In Site Actions click Site Settings for the site you want to modify.

2. Click Reporting Services Site Settings in the Reporting Services group.

3. Click Enable remote errors in local mode.

4. Click OK.

Difference between Integrated Security = True or SSPI

Guys,

I am pretty sure that when we work with connection strings we would have come across this multiple times. 

"Persist Security Info=False;Integrated Security=true;Initial Catalog=Northwind;server=(local)"

Below is an explanation:

Integrated Security -or- Trusted_Connection (Default value = 'false')

1. When false, User ID and Password are specified in the connection.

2. When true, the current Windows account credentials are used for authentication.

3. Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.

4. If User ID and Password are specified and Integrated Security is set to true, the User ID and Password will be ignored and Integrated Security will be used.

Exception - With an OLE DB (non SQL) connection:

1. Integrated Security is not equivalent to Trusted_Security.

2. TRUE and YES are not the same as SSPI.

To use Windows authentication with OLE DB, one must use "Integrated Security=SSPI". 
Using TRUE or YES for this value does not work. 
Using Trusted_Connection with any value does not work.

Difference between ODBC and OLE DB data sources

In this post I want to explain the difference between ODBC and OLE DB.This is what I found based on my reading on the web and my understanding.

1) ODBC provides access only to relational databases

2) OLE DB provides the following features:

a) Access to data regardless of its format or location

b) Full access to ODBC data sources and ODBC drivers

In simple words, ODBC is used only for SQL based data sources whereas OLE DB is used for both SQL and non SQL data sources.I have put in a diagram also below. That might explain it better.

Connection strings for Analysis Services (SSAS) or OLAP

When you work with SharePoint and you want to establish connection with Analysis Services (SSAS) or Cubes you would need to generate connection strings to connect to the Data Source. Some sample connection strings are below: 

Standard

Data Source=myServerAddress;Catalog=myDataBase;

Encrypted Connection

This one authenticates the user and encrypts the communication. This is the highest level of security.

Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=PktPrivacy;

Signed Connection

This one authenticates the user and prevents the content in the communication to be modified.

Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=PktIntegrity;

Authenticated Connection

This one authenticates the user but does not secure the communication.

Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=Connect;

Reference