When printing an invoice in Sage 300 2017 the user is always asked for a password

Posted By Tascoli 5 months ago

The full story is that our client of over 20 years has had to move their system from their local server to an Azur server at short notice.

Everything is working fine except when they print the AR invoice form, both the customized form and the default form. The Crystal Run time prompts for a password. They provide this, the password for the ODBC data connection, and it prints.

It is just rather annoying for our client.

We could change the ODBC connection but we have a customisation running with additional tables and we are concerned that a change may impact the customisation.

The client should upgrade their system to the latest version but right now we just need to fix this issue.

If we connect as Admin through the remote desktop then the prompt does not appear.

Any old timers out there that may have an idea?

Thanks

James

Top Replies

Jay Converse Acumen 5 months ago in reply to Accsys Consulting AU +2

Trick #2. If the tables are non-Sage, then adding an unjoined CSCOM to the subreport will trick the Sage crystal runtime engine to pass in the right Sage credentials.

0 Jay Converse Acumen 5 months ago

The DSN in Crystal should not be active directory. If you can't fix the report, add user AD accounts to SQL.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Accsys Consulting AU 5 months ago in reply to Jay Converse Acumen

Tascoli , this, what the Sage 300 Whisperer says. I've spent ages mucking around with connection strings etc, updating default data sources for reports etc and the easiest way by far to resolve this to add an AD group with all your Sage 300 users as a security login in SQL then map permissions to the databases for that group.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen 5 months ago in reply to Accsys Consulting AU

Trick #2. If the tables are non-Sage, then adding an unjoined CSCOM to the subreport will trick the Sage crystal runtime engine to pass in the right Sage credentials.
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Accsys Consulting AU 5 months ago in reply to Jay Converse Acumen

Whoa, this is a huge trick - I never thought of that and always wondered how the credentials got passed in - thanks for that!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

When printing an invoice in Sage 300 2017 the user is always asked for a password

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING