Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.

Question

HI,

I AM GETTING GIVEN BELOW ERROR WHEN I WANT TO DEPLOY MY SSRS 2008 REPORTS.
I HAVE CREATED SSRS 2008 REPORTS IN SQL SERVER 2008 INSELF.IT NOT MIGRATED FROM 2005 .
I HAVE ALSO BROWSE ABOUT THIS ERROR FORUMS AND BLOGS ARE SAYING IT WILL GET RESOLVE IN RTM RELEASE OF 2008.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=356519&wa=wsignin1.0

http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/65cefd7d-00d8-4be6-a53a-7e34dfd7eb2b


Error 1 The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. D:\SQL SERVER 2008 PROJECT\SSRS_2008\SSRS_2008\Report1.rdl 0 0 

I AM USING GIVEN BELOW VERSION OF SQL SERVER 2008.

Microsoft

SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

PLEASE LET ME KNOW IF THIS ISSUE HAS BEEN RESOLVE OR NOT ALSO PROVIDE ME SOME FORUM LINKS WHERE I CAN POST MY PROBLEMS AND ALSO SHARE MY KNOWLEDGE.

THANKS
KALI CHARAN TRIPATHI
[e-mail]
[e-mail]

---

Tripathi_soft

Answer 1

Did you find a solution for this?
I am getting the below error while trying to deploy Sql Server 2008 Reporting Services reports.

Error 1 The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition' which cannot be upgraded.

I have 2 instances of SQL Server running.
 a) MSSQLSERVER2008
 b) MSSQLSERVER2005

How do i resolve this issue?

Answer 2

Hi,

I had this similar error..

I had two instances
a) MSSQLSERVER2008
b) mssql2008R2

both were in interated mode. Because i had installed SQL2008R2(whose instance is mssq2008R2)  as this is an updated version, I was geeting this error. So I configured(in congiguration manager) my mssql2008R2 instance and pointed it to the sharepoint site that I was previously reffereing and every thing went fine. I was able to deploy my report.

Best Regards,
Azhar