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)
    • SQL Server 2005 Verbindungsserver Fehler 37000
      ... Das ändern von Adressen funktioniert, die Neuanlage von Adressen aber nicht. ... Servern für Remoteverbindungen TCP/IP und named pipes eingestellt, ... SQL1 und SQL2 wurden neu gestartet. ...
      (microsoft.public.de.sqlserver)