After a server update from SQL Server 2005 to 2008 I ran into problems with some of our ASP.NET 2.0 applications that make use of CR XI rpt - files to dynamically create PDFs. The application calls the rpt-files and passes an integer parameter to them.
On SQL Server 2005 all works fine but at SQL Server 2008 there are suddenly login problems. The application seemed to hang and after some research I found out that there' s a 401-Error. A little bit confusing me is that when I open the rpt files in CR Designer and use identical data for login and the parameter everything works fine.
Has anyone an idea what' s going wrong?
Our apps use OLE DB Driver for the data source connection but also switching to SQL Native didn't have any positive effect.
Or is SQL Server 2008 not supported by CR XI and we have to upgrade?
Thanks in advance,