Question

SQL 2005 with E9 and Crystal asks for password always

  • 25 January 2021
  • 1 reply
  • 26 views

  • Anonymous
  • 0 replies

Hello

E 9.05 progress db for E9. We have a Crystal report running against a sql 2005 DB on server 2019. This is legacy data from our old green screen program. The report is pointing to the correct DB, runs fine as an admin user but when run as a regular user in E9 it inputs the default sysprogress user/password in the report login credentials. This is with the login credentials hard coded into the ODBC. Its as if E9 is ignoring what is in the report and the ODBC and defaulting to the sysprogess info. Granted a specific user read/view access to the db and all tables.

Am i missing something?


1 reply

Userlevel 4

I have this in my notes from a long time ago:-

 

go into progress data administration

connect to database in multi-user mode

security

edit user list

add sysprogress user with same pwd

Reply