linked server suddenly doesn't work!!!
From: Lito Dominguez (anonymous_at_discussions.microsoft.com)
Date: 02/02/05
- Next message: DL_at_AXA: "String comparison inline query"
- Previous message: Uri Dimant: "Re: Table permissions"
- In reply to: R. van Laake: "linked server suddenly doesn't work!!!"
- Next in thread: R. van Laake: "SOLVED Re: linked server suddenly doesn't work!!!"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Feb 2005 08:14:12 -0800
1) Try pinging the remore server from the main server. If
you can then check if the target EM is registered on the
main server's EM.
2) If not register it again, relink the target server via
linked server.
3) Make sure the password you used in linking the server
have the correct access to the target database
>-----Original Message-----
>Hi,
>
>I have an ASP page working with a database DBNL. There
also is a linked
>server named OFFICE. Until an hour ago all worked fine; I
could get data
>with a statement like "select name from
office.custdata.dbo.customers".
>
>Suddenly, without **ANY** changes at all to either server
it stopped
>working. Using the Query Analyzer, when I connect to DBNL
and run the
>"select name from office.custdata.dbo.customers"
statement, I get this
>message:
>
>Server: Msg 7314, Level 16, State 1, Line 1
>OLE DB provider 'office' does not contain table
>'"custdata"."dbo"."customers"'. The table either does
not exist or the
>current user does not have permissions on that table.
>OLE DB error trace [Non-interface error: OLE DB provider
does not contain
>the table: ProviderName='office',
TableName='"custdata"."dbo"."customers"'].
>
>
>(1) The customers table *does* exist on the OFFICE
server, and works
>flawlessly (I can access it with the Enterprise Manager).
According to these
>messages, it must be a permissions issue
>
>(2) I can get into the customers table with the Query
Analyzer, and connect
>to the OFFICE server. I use the same username/password
that I use for the
>Linked Server, so that is ok. But when I connect to the
DBNL server and try
>to get into the customers table thru the Linked Server I
get the error.
>
>Who can help?? Stupid thing is it worked until an hour
ago, and nothing
>whatsoever has changed on the servers.................
>
>Thanks,
>
>Ray
>
>
>
>.
>
- Next message: DL_at_AXA: "String comparison inline query"
- Previous message: Uri Dimant: "Re: Table permissions"
- In reply to: R. van Laake: "linked server suddenly doesn't work!!!"
- Next in thread: R. van Laake: "SOLVED Re: linked server suddenly doesn't work!!!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
