I am creating a linked server as Using SSMS.
I am cautiously only adding one linked server at a time.
I call it MonitorTest and its a SQL Server.
On the Security tab, I add a Local SQL login and as the Remote User I specify a SQL Admin Account (windows account) that has all the necessary permissions. I specify that connections will not be made for logins not defined.
On the Server Options page, I specify the True values for RPC and RPC Out.
I get the SQL Server error:-
'The linked server has been created but failed a connection test......
Error 7416 Access to the remote server is denied because no lohin-mapping exists...)