SQLServer / MS Access Invalid User/Password error

[lance.chisenhall@gmail.co]

Hello everyone,



I have 2 WIN10 pcs running Office 2007.

One is a point of sale pc and the other acts as a server. I have the latest version of SQL installed on the "server" along with MS Access 2007 on both PCs.
I can access my POS software (written in Access 2007) on the "server" just fine.
When i try to ope the software on the point of sale pc, I get "LOGIN_SQLServerAuthentication Failed - Invalid UserID/Password combination. Please try again".

I've verified my credentials are correct within the software and the ".ini" file, as well as verifying they are correct on SQL.

Can anyone help this newbie troubleshoot this error?

Thank you... ;-)

[pbaldy]

How are you connecting? Linked tables with DSN, DSNless connection, etc.

[lance.chisenhall@gmail.co]

How are you connecting? Linked tables with DSN, DSNless connection, etc.

Internet comes in thru cable to wifi router with additional hard wire ports.

PCs are connected to this router via CAT5 cable.

[pbaldy]

I mean connecting the Access app to SQL Server.

[lance.chisenhall@gmail.co]

I mean connecting the Access app to SQL Server.

Hi, I'm not sure. My experience with Access and Sql has (until now) been from a power user side and not a developer. Unfortunately, I'm forced to assume the later role at this time.

If you can kindly tell me how to determine what you're asking, I'll be glad to look and update you.