After I got 80% of all the required reports done, my boss decided to change
our MS SQL Server logon account from SQL Server authentication to NT trusted
authentication.

In our application, we use Crystal Report ocx (crystl32.ocx) to preview and
print the report I created using crystal report so that our users don't have
to purchase crystal report to view or print those predefined reports. we use
the following syntax to connect to SQL Server using the ocx:
CrystalReport1.Connect = "DSN=server name; UID = id; PWD=password;
dsq=database name"

The reports I already made are based on SQL authentication. Now that we
changed to use NT authentication, we modified the connect string to:
CrystalReport1.Connect = "DSN=server name; UID =; PWD=; dsq=database name"
(just blank out the user id and password, this is according to KBase article
c2008291)

This works for new reports created off a Microsoft SQL Server connection
using NT authentication. But to save my several weeks' hard work, how can I
change my old reports to use NT authentication? (If I don't change, the
connect statement will give me an error 20599 cannot open SQL Server) I
don't have any luck in using "Set Location".

What I did is to create a new connection under More data sources/Microsoft
SQL Server using NT trusted authentication and set the tables to the
corresponding tables under the new connection. After I am done (by hitting
"done" in the "Set Location" dialog) and try to preview it, it always gave
me a "General SQL Server error: Check messages from the SQL Server"!!

There got to be a way to make such a change!!!??? Please help!!!

Susan