Using 'sp_addlinkedsrvlogin' problem (SQL7.0)

[gravyboy]

When I use this in SQL7 - QA it says that it is completed. When I check the linked server there are no user mappings . . . . I am giving the linked login 'god' rights - 'cos it's gonna do some heavy-duty work later on.

Please help . . .

[RSINGH]

I tend to do this through EM. It explains the different security context's better. Without seeing the parameters you pass - its hard to tell what level you've set this to. You want to set a security context to that of a sys admin, so add it as any member in that role.

When I check the linked server there are no user mappings

If the server is there, then right click on it, check properties-> Security. This will indicate the security context that will be used.