Linked Server error

I am using SQL Server 2005 Express. I created few Linked servers some days back and suddenly I can no longer access the properties of our existing linked servers and I'm unable to add a new linked server. It displays an Error message Box wheneve I try to edit or add a linked server.

Cannot find Table 0 (System.Data)

Any ideas? It doesnt seem to me a permission issue as even after using 'sa' login, this error persists. There has been no change to the system recently as well.

more ▼

asked Aug 05, 2010 at 07:35 AM in Default

avatar image

Sagar Bhargava
638 26 30 34

@Sagar Bhargava Does it allow you to add a linked server with T-SQL, i.e. sp_addlinkedserver? If it does then the problem might be with SSMS, try reinstalling it on the top of existing installation (this is safe, it will not damage existing data). If it does not then the account which is used to run the SQL Server service probably has changed. For example, if you had it as a domain account with appropriate permissions and then changed it to Local System, existing linked servers might become unavailable.

Aug 05, 2010 at 12:31 PM Oleg
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

It sounds like a network issue. Firewall or DNS for starters.

more ▼

answered Aug 05, 2010 at 01:29 PM

avatar image

12.1k 30 36 42

(comments are locked)
10|1200 characters needed characters left

if you are creating link server using Oracle Database then once check the TNS Entry. may be possible the file may be alter by some one...

more ▼

answered Aug 05, 2010 at 10:01 PM

avatar image

basit 1
509 57 65 91

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 05, 2010 at 07:35 AM

Seen: 2282 times

Last Updated: Aug 05, 2010 at 08:47 AM

Copyright 2018 Redgate Software. Privacy Policy