Vantage 8.03.408B - SQL DB running Progress 10.1B
We have several custom crystal reports that are pulling data from a sql stored procedure. When we run one of the reports we keep getting a prompt asking for a db user login credentials. When we type in a sql user we created named ‘Epicor’ the report will run but if we try typing in a epicor user or ‘sysprogress’ the report will not connect to SQL, so we know it needs a SQL login to get to the data. The confusion is since progress still sits between SQL and Vantage, I’m not sure which vantage/progress user I need to use to access these reports that point back to our SQL db. Does any one know what SQL user the ‘sysprogress’ user in vantage uses? I know the system agent settings their is the ‘ODBC’ user/pass fields. So I’m assuming a sql user needs to exist named ‘sysprogress’? Any help is appreciated.