Error: "Unable to connect: incorrect log on parameters" when printing
Description

My X3 Print Server is newly installated on a seperate Windows Server from my database server. 

 Since then, I have tried printing different reports but consistantly get the following error: 

  ERR 504 coming from the edition server : Error induced by the print engine Crystal .NET. 
SBONFAC.rpt - - Message 1/3 : Error running the report: D:\Sage\SafeX3\PRTSRV\BRI\Report\SBONFAC.rpt 
- Message 2/3 : Connection error: Table:FACILITY - Location x3v12p.SEED.FACILITY 
- Message 3/3 : Error in File SBONFAC 6724_1520_{ECAD152F-C586-4C2E-B7BF-29BC12628AAA}.rpt: 
Unable to connect: incorrect log on parameters. 
Details: Database Vendor Code: -1

Cause
Resolution

Check the "ADX_" ODBC data source, by logging in as the X3 Runtime account being used for the Print Server service, then go to "ODBC data sources (64-bit)"
In "User DNS" select the data source and click "Configure" Click "Next" then for the Login ID and password, use X3 and the appropriate folder password. Click "Next" a couple of times, then "Finish" You can then use the "Test Data Source" button to check the connectivity

For this issue, we found it gave the same connection error, which indicates a SQL Server connectivity issue rather than a Sage X3 problem.

To resolve this we did the following:
- Setup SQL server to listen on Static rather than Dynamic TCP port (1433)
- Set the firewall rules on the SQL server box to allow TCP port 1433 and UDP 1433

When we re-tested the ODBC connection, it then worked OK and Sage X3 printing also started working OK.


DocLink: Error: When printing "Unable to connect: incorrect log on parameters"

Steps to duplicate
Related Solutions