I am new to linked servers and basically I want to query data from several
tables on server A and then insert that data into a simple table on server B.
I am hoping to do this from within a stored procedure on Server A rather
than writing a small app.

My limited research has been telling me that I need to have Active Directory
running and Kerberos support enabled of which I know we do not have running.  
That seems to be a bit of overkill for my simple task I am attempting to
accomplish.

When I create the linked server and attempt to access the Tables node I see
nothing and obtain the above noted error.  I know the password is correct
because I can connect directly to server B using this password  from within
Enterprise Manager.

Am I truly unable to do this, am I missing a small step, or should I not be
using Linked Servers at all and attempt this via another approach.

Thanks for any help.

P.S. a fellow co-worker tells me that he is using Linked Servers for a
different app but when he helps me he is unable to get this working either.  
That tells me we shouldn't need Active Directory, etc as mentioned above.