Infoview OK but Scheduled is not, SQL Server - "incorrect log on parameters
We have moved a timetable package to SQL Server (from Oracle) and cannot get the scheduled reports to work (in Enterprise). The new reports work OK in Infoview so the log on parameters must be acceptable but the error message says: "Unable to connect: incorrect log on parameters. Details: [Database Vendor Code: 18456 ] ".
This is a brand new installation of SQL Server and therefore has never worked. No sub-reports are involved. As a test I have created a simple report picking up 2 columns of data from a single table that only has 10 records. Have tried scheduling to Email as well as to "Unmanaged Disk" as TXT and RPT and XLS but no improvement. Am using ODBC connection using "SQL Server" driver and as I say above the connection seems to work.
Does this sound familiar to anyone?
Edited by: Leo Capaldi on Sep 16, 2008 5:22 PM