We have upgraded from Crystal 10 to SAP Crystal Reports for Enterprise. Version 220.127.116.113. Build 2013 Support Pack 7
Windows server 2003
SQL Server 2000
We can successfully create a new report connecting to a SQL database using ODBC.
However, if we open a pre-existing report (Created with Crystal 10 using the same ODBC connection), we can see the layout of the report, but if we try to change to the "Page" view, we get the following error message:
Logon error: [Microsoft][odbc sql server driver][SQL Server] Login failed for user '(null)'. Reason: Not associated with a trusted SQL server connection.
It asks us to login to the ODBC, but this is still all we receive.
The error message appears because the Crystal Report Server is configured to run under a local machine account, or an account which does not have access to the reporting database server. Configure the Crystal Report Server to run under a domain account, which has sufficient rights to access the Microsoft SQL Server database server. Check with your Database Administrator about the rights required on the database server.
Basically , You have to navigate to CCM >> SIA >> Properties and check the Account from which it is running.
Hope this will help.