I don't get it. both PC's have Static IP Addresses and both have SQL Remote connection settings enabled?

One is a workstation connected to the internet using Comcast (not on a windows domain), and the other is a workstation on a bellsouth connection (not on windows domain either)

Still getting errors:

Invalid Authorization Specification.

I noticed a "Security" tab. I've tried several options there with no success either.

I appreciate your help on this.

What about "Provider String" and "Location"?

Also, did you mean "Microsoft OLE DB Provider for ODBC Drivers"?

I don't have the USERID/Password to Computer A. I use windows authentication to connect.

They are not on the same network.

BTW, Computer A uses a default instance (local)

Any help please?

On Computer A, the users can connect by using, "(local)\ABCPOS"

I have the IP Address of COmputer A, and I've tried, "x.x.x.x\ABCPOS" and still not able to connect.

I have no idea...

Is there any other way that I can connect to it? I just need to connect and run queries against the DB for sending hourly reports.