Cannot Pass Database Login Info when Opening Crystal Reports
Posted on 2008-10-28
I just recently installed Crystal Reports Enterprise Server XI R2 on a Windows 2003 SP2 Server using a sql 2005 express database instead of the canned mysql. I am trying to free up my sql 2000 licenses by using the free version but not having luck so far.
Whenever I go to open a crystal report on a sql server, i am prompted with a login prompt. I went into the business view manager and set the data connections to never prompt and took the defaults when publishing the report "to prompt user for database login", but i am still getting the login prompt. The login credentials to the CMS database are the exact same as the credentials used on the sql server. I am at wits end here, not sure what else to try. I would hate to have to go back to the sql 2000. I am just wondering if sql 2005 express does not work with this version of crystal. TIA