Report Server (MSSQLSERVER) cannot load the SQLPDW extension.

Question

Hi 

微软的CRM SSRS报表服务器，总是不定时在Windows Event里报这个错误：

Report Server (MSSQLSERVER) cannot load the SQLPDW extension.

之前还报：Report Server (MSSQLSERVER) cannot load the TERADATA extension.，但后来我安装了这个.NET Data Provider for Teradata，现在就只报cannot load the SQLPDW extension，不清楚这个错误如何来解决？

非常感谢。

Answer 1

跟这个帖子的一样：

This error occurs because the Teradata extension is registered in the Reporting Services configuration file by default, but the Teradata assemblies are not shipped with SQL Server 2008 or as part of the .NET Framework. If the error message does not bother you, you can ignore the error when it is logged.

However, if you want to avoid this error, do one of the following:

• Open the Reporting Services configuration file located in folder C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer, remove or comment out the Teradata extension. Do this only if you do not require functionality that the Teradata extension provides.

• Install the .NET Data Provider for Teradata. Do this only if you require functionality that the Teradata extension provides. You can obtain the provider from the Teradata Web site. Reporting Services requires that the provider be version 12 or later.

For more information about this issue, please see http://technet.microsoft.com/en-us/library/ms159704.aspx#TeradataException 

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/34b2f6c4-a6a2-43bd-a349-ebab5b8d92f0/report-server-intermittent-terradata-errors?forum=sqlreportingservices

---

Please Mark As Answer if it is helpful.

Answer 2

跟这个帖子的一样：

This error occurs because the Teradata extension is registered in the Reporting Services configuration file by default, but the Teradata assemblies are not shipped with SQL Server 2008 or as part of the .NET Framework. If the error message does not bother you, you can ignore the error when it is logged.

However, if you 这个want to avoid this error, do one of the following:

• Open the Reporting Services configuration file located in folder C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer, remove or comment out the Teradata extension. Do this only if you do not require functionality that the Teradata extension provides.

• Install the .NET Data Provider for Teradata. Do this only if you require functionality that the Teradata extension provides. You can obtain the provider from the Teradata Web site. Reporting Services requires that the provider be version 12 or later.

For more information about this issue, please see http://technet.microsoft.com/en-us/library/ms159704.aspx#TeradataException 

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/34b2f6c4-a6a2-43bd-a349-ebab5b8d92f0/report-server-intermittent-terradata-errors?forum=sqlreportingservices

---

Please Mark As Answer if it is helpful.

这个贴子未提及SQLPDW如何处理。