I created a Windows appliction using CR 2008 basic (VS2008). It connects to an SQL server 2008 computer using SQL server authentication. The application works fine in Vista and Windows Server 2008; it connects to the SQL server, generates the report and shows it fine. All this without asking me about username and password to logon to the database (as i provide the username and password in the code). However, when i use the application in Windows Server 2003 or Win XP, it gives a logon failed error and shows a prompt for entering username and passord to logon to the database. Even when i enter the correct password, it keeps giving logon error. I'd appreciate any help. Thanks.
More than likely, this is a database client issue - either not installed, not installed correctly, or incorrect version. E.g.; it is not a code issue. Couple of ways of troubleshooting this:
1) Download the Modules utility and compare the dlls loading on a working and non working machines. Modules is [here|https://smpdl.sap-ag.de/~sapidp/012002523100006252802008E/modules.zip]
2) Download an eval of CR 2008, install it on one of the non working computers and try to run the report fromthe designer. Eval of CR 2008 can be downloaded from [here|http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx]