ASP.NET C# Schema asking for Password?
I have a crystal report that is on a web page (or rather crystal report viewer to show the report), this report is attached to an XSD file only (I will be using a datatable /dataview later to fill the data to show on the report), when I refresh the page, the crystal report is asking for a login to the Schema.. well this is impossible since the schema has no login at all.
I stepped through the code, the test datatable that is attached as a result for the information that is applied to the schema has 1 record in it like it should. On my test machine running local IIS shows the result but a published version of the site always asks for a database login for the schema.
C# ASP.NET application
SQL 2005 (doesn't matter because I do all the datapull and use dataviews / datatables to fill the results to show)
Windows Server 2003
Crystal Reports XI R2
Is there a piece of the puzzle I am missing at the time I deploy it that I have in the test environment that I am not seeing?