Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Linked Servers

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-28 : 16:31:28
JC writes "I have created a linked server on a 7.0 SQL Server to a SQL 2000 box.
Everything I do to attempt to access this linked server times out based on the 'remote login timeout' option and reports the following error:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Timeout expired]

I don't have any issues creating linked servers to/from other SQL servers.
Just this one.

I tried other login/authentication methods, but they were not successful

Any guidance would be appreciated."
   

- Advertisement -