Linked SQL Server

Trying to link 2 servers via:
SELECT *
from OPENROWSET('SQLOLEDB','Server=SERVER;uid
=uid;pwd=pwd;
Trusted_Connection=yes;',
'SELECT * FROM Web_Configurator.dbo.MC_WS_Countries')
-or-
select * from krusty.Web_Configurator.dbo.MC_WS_Countries
Keep getting the dreaded:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I ran the following scripts and verified that the database server I'm
attempting to reach is in mixed mode:
exec sp_addlinkedserver @.server='krusty'
exec sp_addlinkedsrvlogin @.rmtsrvname = 'krusty',@.rmtuser =
'uid',@.rmtpassword = 'pwd'
How I can check each server for correct configuration? How can I get this
simple query to work?Please do not multipost, if you really want to post to more than one
group (actually one should be enough for the most questions) separate
the groups with a ";" within your newsreader application, it will be
automatically to the different groups and will prevent other from
seeing already posted responses.
Answered in .sqlserver
-Jens.
http://www.sqlserver2005.de
--