Skip to Content
0
Former Member
Jul 20, 2016 at 03:29 PM

Incorrect log on parameters

739 Views

We just installed Crystal Server 2016 ( on Windows Server 2012 R2). I installed the SQL Native Client 11 driver and created an ODBC connection to our database I have a Crystal Report that connects to a SQL Server db via the same 32-bit native client ODBC connection. The report runs fine in Crystal Reports locally on my PC. However, when deployed to Crystal Server, the report fails with the error "Error in File ~tmp2e3c8fa52a64a60.rpt: Unable to connect: incorrect log on parameters."

The database is SQL Server 2014. I remember struggling with this during initial set up at another job and thought the Native Client driver was the key. What am I missing? Should there be a connection in the Crystal Server UI? According to the PAM, SQL Server 2014 data access should use Microsoft SQL Server Native Client 11.0.