LINKED SERVER PROBLEM (help needed URGENT)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: LINKED SERVER PROBLEM (help needed URGENT)

Hybrid View

  1. #1
    Madhavi Guest

    LINKED SERVER PROBLEM (help needed URGENT)



    Hi I am working on a PRODUCTION SERVER , i know the another production Server
    Name , Login password Details, i am able to Setup NEW Server Registration
    from ENTERPRISE MANAGER and i am able to see the Database and all work. When
    i am trying to map a Linked Server on Production , i am using same user id
    and Password, while Registering it is not giving any Error message , but
    when i click on tables under the Server i am not able to see any Tables i
    am getting a ERROR MESSAGE
    ERROR : 17 SQL Server does not exist or Access Denied.

    Note: i am able to see the server and it is running fine from the Enterprise
    Manager..
    How to Fix this one.


    Thanks
    Madhavi..


  2. #2
    niv Guest

    Re: LINKED SERVER PROBLEM (help needed URGENT)


    How to join tables from different servers? <top>

    To be able to join tables between two SQL Servers, first you have to link
    them. After the linked servers are setup, you just have to prefix your tables
    names with server name, database name, table owner name in your SELECT queries.
    The following example links SERVER_01 to SERVER_02. Execute the following
    commands in SERVER_02:

    EXEC sp_addlinkedserver SERVER_01
    GO

    /* The following command links 'sa' login on SERVER_02 with the 'sa' login
    of SERVER_01 */
    EXEC sp_addlinkedsrvlogin @rmtsrvname = 'SERVER_01', @useself = 'false',
    @locallogin = 'sa', @rmtuser = 'sa', @rmtpassword = 'sa password of SERVER_01'
    GO

    SELECT a.title_id
    FROM SERVER_01.pubs.dbo.titles a
    INNER JOIN SERVER_02.pubs.dbo.titles b
    ON a.title_id = b.title_id
    GO




    "Madhavi" <madhavi@yahoo.com> wrote:
    >
    >
    >Hi I am working on a PRODUCTION SERVER , i know the another production Server
    >Name , Login password Details, i am able to Setup NEW Server Registration
    >from ENTERPRISE MANAGER and i am able to see the Database and all work.

    When
    >i am trying to map a Linked Server on Production , i am using same user

    id
    >and Password, while Registering it is not giving any Error message , but
    >when i click on tables under the Server i am not able to see any Tables

    i
    >am getting a ERROR MESSAGE
    >ERROR : 17 SQL Server does not exist or Access Denied.
    >
    >Note: i am able to see the server and it is running fine from the Enterprise
    >Manager..
    >How to Fix this one.
    >
    >
    >Thanks
    >Madhavi..
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center