• Drew...

    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...)