asked on

Crystal Reports fail after SQL 2005 database conversion

We have converted a SQL Server 2000 Database to SQL Server 2005. Now all the Crystal Reports that we have written that use Stored Procedures will not work. For some reason all Stored Procedures, when looking at them in Crystal Reports have a ";1" added to the name. This is only with the Stored Procedures, not Tables or Views. Pls Help, we have over 200 reports that were written against the SQL 2000 database that now do not work.

frodoman

Were you using any repository data in your reports? If so, you may have clobbered the repository when you did your upgrade - hopefully you took a backup first?

Also, what version of Crystal are you using? AFAIK, only XI has been tested with Sql 2005 - earlier versions haven't been tested for compatibility.

Finally, security might be an issue but I'm assuming you've already looked at that? Also, I am assuming that the server location and instance name haven't changed?

CochiseCounty

ASKER

frodoman,

We are not using any repository data. All of your assumptions are correct. We are using Crystal Reports Pro XI. It seems that Crystal Reports only sees stored procedures with the added ';1' behind the name even though the SQL Server Management Studio does not show the stored procedures with the ';1'.

Thanks

ASKER CERTIFIED SOLUTION

frodoman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial