If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

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:

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