linked servet to informix error with oledb

hello everybody
I set up a linked server with odbc for infomix
but cant make a linked server with oledb
and I cant insert into infomix tablesCan you share out what is your linked server object configuration in your front end server?sql

servers SQL2000 to SQL2005

Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked server.
I have done this before and am replicating what I did then but I can`t get it
to connect. However when I connect via query analyser using the same
credentials it connects with no issues. Has anyone seen this before ?
Si
Si,
Is there any difference in the Security tab of the linked server properties
from your model linked server?
Is Kerberos properly activated on both the SQL2005 and SQL200 boxes? (What
OS?)
Do you get any useful error messages when you try to use the linked server?
RLF
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:E71D6BEE-B7AC-4D6A-B48F-611AFAE89FE3@.microsoft.com...
> Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked
> server.
> I have done this before and am replicating what I did then but I can`t get
> it
> to connect. However when I connect via query analyser using the same
> credentials it connects with no issues. Has anyone seen this before ?
> Si

servers SQL2000 to SQL2005

Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked server
.
I have done this before and am replicating what I did then but I can`t get i
t
to connect. However when I connect via query analyser using the same
credentials it connects with no issues. Has anyone seen this before ?
SiSi,
Is there any difference in the Security tab of the linked server properties
from your model linked server?
Is Kerberos properly activated on both the SQL2005 and SQL200 boxes? (What
OS?)
Do you get any useful error messages when you try to use the linked server?
RLF
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:E71D6BEE-B7AC-4D6A-B48F-611AFAE89FE3@.microsoft.com...
> Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked
> server.
> I have done this before and am replicating what I did then but I can`t get
> it
> to connect. However when I connect via query analyser using the same
> credentials it connects with no issues. Has anyone seen this before ?
> Si

servers SQL2000 to SQL2005

Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked server.
I have done this before and am replicating what I did then but I can`t get it
to connect. However when I connect via query analyser using the same
credentials it connects with no issues. Has anyone seen this before ?
SiSi,
Is there any difference in the Security tab of the linked server properties
from your model linked server?
Is Kerberos properly activated on both the SQL2005 and SQL200 boxes? (What
OS?)
Do you get any useful error messages when you try to use the linked server?
RLF
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:E71D6BEE-B7AC-4D6A-B48F-611AFAE89FE3@.microsoft.com...
> Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked
> server.
> I have done this before and am replicating what I did then but I can`t get
> it
> to connect. However when I connect via query analyser using the same
> credentials it connects with no issues. Has anyone seen this before ?
> Sisql

servers in 2005

Hi,
I just can't found the Linked Servers under Security in SQL Server 2005 EE.
Can someone get me some help?
Regards,
-Chen
Server Objects folder.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Chen" wrote:

> Hi,
> I just can't found the Linked Servers under Security in SQL Server 2005 EE.
> Can someone get me some help?
> Regards,
> -Chen
sql

server: Can't create server but I can connect from one server to the other

I have 3 servers in this equation
server1 server2 and link1
I can create a linked server between server1->link1
I get an error when I try and do the exact same thing
between server2->link1
Error:
TCP Provider: An existing connection was forcibly closed by the remote
host.
Login failed for user reader
OLE DB provider "SQLNCLI" for linked server "link1" returned message
"Communication link failure". (Microsoft SQL Server, Error:10054)
So then I went through some troubleshooting on server2
Patch levels of windows and sql server seem to be exactly the same as
server1
I can remote to server2 and register link1 and it connects fine and
also allows
me to run queries.
Any ideas?
On Jun 21, 7:26 pm, Mandible <elliottj...@.gmail.com> wrote:
> I have 3 servers in this equation
> server1 server2 and link1
> I can create a linked server between server1->link1
> I get an error when I try and do the exact same thing
> between server2->link1
> Error:
> TCP Provider: An existing connection was forcibly closed by the remote
> host.
> Login failed for user reader
> OLE DB provider "SQLNCLI" for linked server "link1" returned message
> "Communication link failure". (Microsoft SQL Server, Error:10054)
> So then I went through some troubleshooting on server2
> Patch levels of windows and sql server seem to be exactly the same as
> server1
> I can remote to server2 and register link1 and it connects fine and
> also allows
> me to run queries.
> Any ideas?
Are you registerting with TCP IP protocol. Check whether this enabled
on server2 .
Check for any firewall settings which may not be allowing to connect
throgh link server . I hope you enabled remote access allowed on both
the systems

server: Can't create server but I can connect from one server to the other

I have 3 servers in this equation
server1 server2 and link1
I can create a linked server between server1->link1
I get an error when I try and do the exact same thing
between server2->link1
Error:
TCP Provider: An existing connection was forcibly closed by the remote
host.
Login failed for user reader
OLE DB provider "SQLNCLI" for linked server "link1" returned message
"Communication link failure". (Microsoft SQL Server, Error:10054)
So then I went through some troubleshooting on server2
Patch levels of windows and sql server seem to be exactly the same as
server1
I can remote to server2 and register link1 and it connects fine and
also allows
me to run queries.
Any ideas?On Jun 21, 7:26 pm, Mandible <elliottj...@.gmail.com> wrote:
> I have 3 servers in this equation
> server1 server2 and link1
> I can create a linked server between server1->link1
> I get an error when I try and do the exact same thing
> between server2->link1
> Error:
> TCP Provider: An existing connection was forcibly closed by the remote
> host.
> Login failed for user reader
> OLE DB provider "SQLNCLI" for linked server "link1" returned message
> "Communication link failure". (Microsoft SQL Server, Error:10054)
> So then I went through some troubleshooting on server2
> Patch levels of windows and sql server seem to be exactly the same as
> server1
> I can remote to server2 and register link1 and it connects fine and
> also allows
> me to run queries.
> Any ideas?
Are you registerting with TCP IP protocol. Check whether this enabled
on server2 .
Check for any firewall settings which may not be allowing to connect
throgh link server . I hope you enabled remote access allowed on both
the systems

server using NT authentication

Hi,
I have successfully set up linked servers using SQL authentication. However,
I can't figure out how to configure a linked server using NT authentication.
I would appreciate it if anyone could help with this matter.
Sincerely,
Shan
Think you just want the users crrent security context on the security tab.
"Shan" wrote:

> Hi,
> I have successfully set up linked servers using SQL authentication. However,
> I can't figure out how to configure a linked server using NT authentication.
> I would appreciate it if anyone could help with this matter.
> Sincerely,
> Shan
>