I have a couple Infomaker reports that I've converted from Oracle to SQL Server. I am using SNC SQL Native Client as the connection type for both and have deployed the EXEs to my users' machines. The EXEs both work fine for me on my computer and when I remote in to the user computer. However, only one works when the users try to run it themselves. The other gives the error:
Database connect failed. Application cannot be run. Error: 18456
SQLSTATE = 28000
Microsoft SQL Server Native Client 11.0
Login failed for user 'TheUserName'
Again, both are using the same connection which includes a master username and password, so I am confused as to why the error message references the individual's username, and why one EXE works and one gives that error. Any input would be greatly appreciated; thank you!