Hi,

I have configured the SSRS on my Primary site server where my SQL also resides on the same server. I could not get the Reports from the console. While looking in to the srsrp.log, found the following

Reporting Services is running SMS_SRS_REPORTING_POINT 4/21/2015 2:21:35 AM 508 (0x01FC)
Retrieved datasource definition from the server. SMS_SRS_REPORTING_POINT 4/21/2015 2:21:35 AM 508 (0x01FC)
Confirmed version [11.0.3000.0] for the Sql Srs Instance. SMS_SRS_REPORTING_POINT 4/21/2015 2:21:35 AM 508 (0x01FC)
Retrieved datasource definition from the server. SMS_SRS_REPORTING_POINT 4/21/2015 2:21:35 AM 508 (0x01FC)
Updating data source {5C6358F2-4BB6-4a1b-A16E-8D96795D8602} at R_P01 SMS_SRS_REPORTING_POINT 4/21/2015 2:21:35 AM 508 (0x01FC)
Cleared the 'DataSourceNeedsUpdated' flag SMS_SRS_REPORTING_POINT 4/21/2015 2:21:35 AM 508 (0x01FC)
(!) Error retrieving folders - [A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.)]. SMS_SRS_REPORTING_POINT 4/21/2015 2:21:35 AM 508 (0x01FC)
No folder configuration information found. SMS_SRS_REPORTING_POINT 4/21/2015 2:21:35 AM 508 (0x01FC)

Not sure how we can track the target principal name.

Any help is much appreciated.

Regards,

Vinod

Was this server renamed after SQL was installed?

Hi,

No the server was not renamed.

regards,

Vinod

Does the site server computer account have sysadmin permissions to SQL and reporting services?

Jeff

Does the site server computer account have sysadmin permissions to SQL and reporting services?

Jeff

• Proposed as answer by Joyce LMicrosoft contingent staff, Moderator 4 hours 41 minutes ago
• Marked as answer by vinod7 3 hours 5 minutes ago

Does the site server computer account have sysadmin permissions to SQL and reporting services?

Jeff

• Proposed as answer by Joyce LMicrosoft contingent staff, Moderator Thursday, April 23, 2015 3:05 AM
• Marked as answer by vinod7 Thursday, April 23, 2015 4:40 AM

Hi Jeff,

Thanks. It was permission issue and it's resolved now.

Regards,

Vinod