Remote Server issue...

From: Brett (anonymous_at_discussions.microsoft.com)
Date: 11/25/03

  • Next message: Louis Davidson: "Re: How to give execute permissions to all stored procedures in the database?" 
    Date: Mon, 24 Nov 2003 17:51:04 -0800

    I am attmepting to setup up a linked server from my
    production server (sql1) to my reporting server (sql2).
    I have replication from sql1 to sql2.

    I noticed that there is already a remote server setup on
    sql1 for sql2. It will not allow me to setup a linked
    server for sql2. Plus, I am unable to run a distributed
    query... I get the error message that the remote server
    is not configured from data access.

    How do I setup a linked server from sql1 to sql2 so that
    I have data access?

    Please advise..

    Thank you,
    Brett

    I am using SQL Server 2000 for my production and
    reporting servers.

  • Next message: Louis Davidson: "Re: How to give execute permissions to all stored procedures in the database?"

    Relevant Pages

    • Multi Instance Cluster Question
      ... Its SQL 2000 EE on ... Windows Server 2003 EE ... one ..in my case SQL2.. ... a default instance was named as SQL1. ...
      (microsoft.public.sqlserver.clustering)
    • Re: Remote Servers - Could not connect to server
      ... Disable SQL2 as Subscriber in Publisher/Distributor properties. ... Enable SQL2 as SQLSTG subscriber. ... It didn't add SQL2 as a remote server this time, ... Bill, I really appreciate your help in this. ...
      (microsoft.public.sqlserver.security)
    • RE: Remote Servers - Could not connect to server
      ... You may want to inspect sp_helpserver upon SQLSTG and SQL2, ... I would allow linked server access (I ... procedure calls (this is SQL Server 6.5 functionality) such as "EXEC ...
      (microsoft.public.sqlserver.security)
    • error 18483 & 18482
      ... as a remote login at the server. ... that the name returned is not the same as the computer name(e.g SQL1) ... to SQL1 because 'SQL2' is not defined as a remote server ...
      (microsoft.public.sqlserver.replication)
    • Re: General SQL Clustering Question
      ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... following was setup when SQL1 was the active node and was different when SQL2 ... shouldn't be any difference between the nodes either because the cluster ...
      (microsoft.public.sqlserver.clustering)