Microsoft CRM: Unable to open Reports from CRM Application.

Hi,
I just installed an EVAL copy of Micorosft CRM with SQL 2005 on Windows 2003
Server.

Install went fine without any error messages. However, when I am in the CRM
application and try to access "Reports", I get an error

"Reports.config has invalid schema, and could not be loaded"

But if I access the CRM reports directly http://<server>/Reports, I can
access all the reports. Has anyone come across this issue and resolved it?

Any help is appreciated.

Thanks
Sanjay

Ricardo
Fri Mar 17 05:40:28 CST 2006

Hi,

I had a similar problem when i´ve installed the CRM 3.0. The problem was
regarding with the autentication on the Reports server by the CRM.

Are the CRM and SQL 2005 programs on the same server on on diferent ones?
Are you using host names in order to access the CRM?


--
Regards,

Ricardo


"SB" wrote:

> Hi,
> I just installed an EVAL copy of Micorosft CRM with SQL 2005 on Windows 2003
> Server.
>
> Install went fine without any error messages. However, when I am in the CRM
> application and try to access "Reports", I get an error
>
> "Reports.config has invalid schema, and could not be loaded"
>
> But if I access the CRM reports directly http://<server>/Reports, I can
> access all the reports. Has anyone come across this issue and resolved it?
>
> Any help is appreciated.
>
> Thanks
> Sanjay
>

SB
Fri Mar 17 10:26:38 CST 2006

Hi Ricardo,

Yes, Both SQL Server 2005 and CRM 3.0 are installed on the same server.
I wasn't using HOST name. I was using http://localhost/default.aspx on the
server to access the CRM. It sounds like you were able to resolve this issue.
Pls. let me know what you had to do.

Thanks
SB

Ricardo
Mon Mar 20 09:06:32 CST 2006

Hi,

If you have both programs (CRM 3.0 and SQL2005) in the same server you
should not have any authentication problem and you are not using a host name
that simplifies the instalation. So we need to check other things.

When you say that if you browse your reports directory
(http://<server>/Reports) do you see there the following directory?
http://<server>/Reports/<your company>_MSCRM


--
Regards,

Ricardo


"SB" wrote:

> Hi Ricardo,
>
> Yes, Both SQL Server 2005 and CRM 3.0 are installed on the same server.
> I wasn't using HOST name. I was using http://localhost/default.aspx on the
> server to access the CRM. It sounds like you were able to resolve this issue.
> Pls. let me know what you had to do.
>
> Thanks
> SB

taoyue
Thu Mar 23 17:19:18 CST 2006

------=_NextPart_0001_6B0DDED5
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Sanjay <SB@discussions.microsoft.com> wrote:
> Install went fine without any error messages. However, when I am in the
CRM
> application and try to access "Reports", I get an error
> "Reports.config has invalid schema, and could not be loaded"
> But if I access the CRM reports directly http://<server>/Reports, I can
> access all the reports. Has anyone come across this issue and resolved it?

This message will come up if reports.config really does have an invalid
schema, but it also may come up if the CRM application cannot open the file
for read. Reports.config is located in interpub\wwwroot\_resources (or
wherever the CRM web site is located) along with the corresponding XSD.

To verify proper schema, run an XML schema validator on the .xml and .xsd
file. You can get one online at
http://apps.gotdotnet.com/xmltools/xsdvalidator/

If the file somehow got into a weird locking state, you could try to
workaround by copying the files to a temp location, deleting them,
restarting the website, and copying the files back.

--
Tao Yue
Microsoft CRM Development
This posting is provided "AS IS" with no warranties, and confers no rights.
------=_NextPart_0001_6B0DDED5
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Sanjay <SB@discussions.microsoft.com> wrote:
\par > Install went fine without any error messages. However, when I am in the CRM
\par > application and try to access "Reports", I get an error
\par > "Reports.config has invalid schema, and could not be loaded"
\par > But if I access the CRM reports directly http://<server>/Reports, I can
\par > access all the reports. Has anyone come across this issue and resolved it?
\par
\par This message will come up if reports.config really does have an invalid schema, but it also may come up if the CRM application cannot open the file for read. Reports.config is located in interpub\\wwwroot\\_resources (or wherever the CRM web site is located) along with the corresponding XSD.
\par
\par To verify proper schema, run an XML schema validator on the .xml and .xsd file. You can get one online at http://apps.gotdotnet.com/xmltools/xsdvalidator/
\par
\par If the file somehow got into a weird locking state, you could try to workaround by copying the files to a temp location, deleting them, restarting the website, and copying the files back.
\par
\par --
\par Tao Yue
\par Microsoft CRM Development
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par }
------=_NextPart_0001_6B0DDED5--