The user I provided in the ODBC connection is also an admin.Īs your report is querying a Microsoft SQL Server database, and not the ClearSCADA database, you must set the report location to remote and not local. This is a local setup and I am an administrator on my machine and in SQL. So its not an issue with the report, its contents, or the connection information. I even verified that the query would execute successfully in SQL directly. I was able to see through the query that Crystal Reports used to retrieve the data when previewing the report in the editor. I also checked SQL Profiler to see if there was any error on the SQL side but I did not seen messages. This seems to be a ClearSCADA issue because Crystal Reports is able to connect and retrieve data from SQL Server using the ODBC connection. The problem is that when I try to generate the report through ViewX, I am seeing in the events and the crystal report logs that the report failed to generate the report because the database logon failed. I know that the connection, specifically the credentials, is working because I can preview the report in the Crystal Reports editor which successfully pulls in the data. The report is pointed to the table and is not using a command to pull in the data. I built a crystal report that pulls in data from a SQL table using an ODBC connection. I have already submitted a request to support for this issue but I thought I would see if anyone else had any thoughts on this or had run into this issue before and got it resolved. Elektrik Tasarım Dağıtım ve Uygulama Çözümleri.Motorabgangstechnik & Antriebstechnik Forum.Level and Pressure Instrumentation Forum.EcoStruxure Automation Expert / IEC 61499 Forum.APC UPS Data Center Backup Solutions Forum.APC UPS, Critical Power, Cooling and Racks.