x

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

Sagar Bhargava gravatar image

Sagar Bhargava
358 24 25 27

@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

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 36

(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

basit 1 gravatar image

basit 1
499 51 61 84

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1947
x108

asked: Aug 05, 2010 at 07:35 AM

Seen: 1935 times

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