servers

I have 3 SQL servers, lets call the s1, s2 and s3. I wanted to link s1 to s2
so I did it using the new linked server option in s2 and it worked great.
Now I want to link s1 to s3 so I open the new linked server option in s3 and
do the same thing, but when I try to run a query in s3 using a database in
s1 I get this error:
Error 7399: OLE DB Provider 'Exoledb.DataSource.1' reported an error. Quthen
tication failed.
OLEDB error trace [OLE/DB Provider 'Exoledb.DataSource.1' IDBInitialize:
:Initialize returned 0x80040e4d:
Authentication failed.].
So I did the same thing in both servers, one worked and one failed. How do I
fix the one that didn't work?
--
El que persevera insiste
Sergio Florez M.
Medelln, ColombiaHi
You may want to check the properties of each of the linked servers. The
authentication modes of the database servers (themselves) and the network
configuration of each of the servers (e.g are they both on the domain).
John
"Sergio Florez M." <sergioflorezm@.hotmail.com> wrote in message
news:%23hAfBxhVEHA.3512@.TK2MSFTNGP12.phx.gbl...
I have 3 SQL servers, lets call the s1, s2 and s3. I wanted to link s1 to s2
so I did it using the new linked server option in s2 and it worked great.
Now I want to link s1 to s3 so I open the new linked server option in s3 and
do the same thing, but when I try to run a query in s3 using a database in
s1 I get this error:
Error 7399: OLE DB Provider 'Exoledb.DataSource.1' reported an error.
Quthentication failed.
OLEDB error trace [OLE/DB Provider 'Exoledb.DataSource.1'
IDBInitialize::Initialize returned 0x80040e4d:
Authentication failed.].
So I did the same thing in both servers, one worked and one failed. How do I
fix the one that didn't work?
El que persevera insiste
Sergio Florez M.
Medelln, Colombia