Friday, December 30, 2016

The certificate’s CN name does not match the passed value

An error has occurred during report processing. (rsProcessingAborted).
Cannot create a connection to data source ‘AutoGen_{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}’. A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 – the certificate’s CN name does not match the passed value.)

When you try testing the data source connectivity, you will receive the same error;

The error indicates the installed certificate does not match with current SQL server name. If we open the data source of the SQL server reporting services, on the connection string we can see the actual SQL server name. If we modify the server name under the connection string, the connection will successes. However, the modified SQL server name will revert as soon as save and close the page.

To fix the certificate’s CN name does not match the passed value, we have to change the SQL server name on the actual reporting server where reporting services role is installed.
Go to \Administration\Overview\Site Configuration\Servers and Site System Roles in SCCM console then identify the server where reporting server services installed. Then open the properties of the Reporting services point. 
On the General tab go to site database server name then enter the current SQL server name then click on Verify under the database name. If the database server name is correct then we should get successfully verified message.

Now, run the report. It should connect and run the reports without any errors.

No comments:

Post a Comment