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 . . .
Printable View
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 . . .
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.
If the server is there, then right click on it, check properties-> Security. This will indicate the security context that will be used.Quote:
When I check the linked server there are no user mappings