Login failes for user 'sa'

From: Marius Horak (someone_at_europe.eu)
Date: 01/05/05


Date: Wed, 5 Jan 2005 12:48:50 -0000

I spent whole day searching the net and still cannot figure out how to fix
the problem.

Two servers
A, user = sa, password = aaa
B, user = sa, password = bbb
Both have Authentication set to 'SQL Server and Windows'

In Query Analyzer (A server) I want to execute

SELECT * FROM B.MyDB.dbo.MyTable

It fails with the above error.
I added a login 'fred' to both servers and tried

EXEC sp_grantlogin 'fred'

SELECT * FROM B.MyDB.dbo.MyTable

Still the same problem. When passwords (in the development) are the same all
is fine but the live databases have different passwords.

What I want to achive is to add a trigger that will insert data from A
database to B database.
It has to be a trigger (not replication)

Thanks

MH