Linked server error in SSMS

Hi all
I have installed Sql Server 2005 + Sp2 developer edition. Once trying to add
a linked server in SSMS Server Objects => Linked Servers => New Linked
Server I'm getting the error immediately saying " Cannot show requested
dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
under Linked servers is also empty. However I could add a linked server
successfully using t-sql sp_addlinkedserver. I got the feeling that some
files are corrupt on my PC, but I don't know which. I tried to uninstall and
put the server back again and it did not help either. I installed Sql Server
from the same disk onto the other machine and it works fine. Has anybody got
an idea how to resolve my problem?
Many thanks
DariusDarius
Hmm, I tried succefully create a linked server throu SSMS to SQL Server
2000. Pehaps something got corrupted during the installation of SSMS...
"Darius" <nospam@.mail.com> wrote in message
news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
> Hi all
> I have installed Sql Server 2005 + Sp2 developer edition. Once trying to
> add a linked server in SSMS Server Objects => Linked Servers => New Linked
> Server I'm getting the error immediately saying " Cannot show requested
> dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
> under Linked servers is also empty. However I could add a linked server
> successfully using t-sql sp_addlinkedserver. I got the feeling that some
> files are corrupt on my PC, but I don't know which. I tried to uninstall
> and put the server back again and it did not help either. I installed Sql
> Server from the same disk onto the other machine and it works fine. Has
> anybody got an idea how to resolve my problem?
> Many thanks
> Darius
>
>|||Hi Uri
I believe something is corrupted on my PC (drivers, etc.), I successfully
can create linked server on the other machines. The error appears straight
after I click on "New Linked Server", it does not even show any dialog box..
I reinstalled the Sql Server from the scratch but there were no difference.
Just don't know where to start looking at...
Darius
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
> Darius
> Hmm, I tried succefully create a linked server throu SSMS to SQL Server
> 2000. Pehaps something got corrupted during the installation of SSMS...
>
> "Darius" <nospam@.mail.com> wrote in message
> news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>|||Hi
Have you tried to search on "Google" for this error message?
"Darius" <nospam@.mail.com> wrote in message
news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
> Hi Uri
> I believe something is corrupted on my PC (drivers, etc.), I successfully
> can create linked server on the other machines. The error appears straight
> after I click on "New Linked Server", it does not even show any dialog
> box.. I reinstalled the Sql Server from the scratch but there were no
> difference. Just don't know where to start looking at...
> Darius
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
>|||yep, this is the first thing I do before posting to newsgroups. Anyway, will
post the solution when/if I manage to solve that problem.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uxr7xplgHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hi
> Have you tried to search on "Google" for this error message?
>
> "Darius" <nospam@.mail.com> wrote in message
> news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
>