Login failed for user 'sa' linked server

If the server on 192.168.100.1 is configured to only accept windows authentication, you have to change that setting.

it is in mixed mode

what version is installed on that server?

enterprice on local and personal edition on remote
i have one more remote location just like the same config, things are workig fine there.

sql 7? sql 2000? sql 2005?
which service pack?

what windows version and service pack?

sql 2000  enterprice on local , sql 2000  personal edition on remote
os - xp professional same on both
sp2 same on both

service pack for remote sql server is shown as RTM

which means no service pack

if you add login sa to the linked server, it means that you have to be logged into the local server with logon sa. You are probably logged into the local server with NT authentication, and mapped sa is not used.

as soon as i installed sp3 my tools (enterprise manager, query analizer etc..) are stopped working, its getting loded to the memory and running but not showing up on the screen , even i can access it using enterprise manager on other machines. What to do? by the way the other problem "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection" got solved as soon as installed sp3. pl suggest wt to do.

so original problem solved, now the tools problems?

I have not yet seen myself the tools stopping to "work" / display, so I have no suggestion there (except reinstalling the tools)

Thanks angelIII