Sql 2005 data collection "login timeout expired"

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

General SQL Server Forums

New to SQL Server Programming

Sql 2005 data collection "login timeout expired"

Author

Topic

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-21 : 11:02:12

I am using a stored procedure to collect data from a remote server using openrowset 'SQLOLEDB'. But the problem is that sometimes the data collection takes place and sometimes it fails with the following error:


TCP Provider: Timeout error [258]. [SQLSTATE 42000] (Error 258)  OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired". [SQLSTATE 01000] (Error 7412)  OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Unable to complete login process due to delay in login response". [SQLSTATE 01000] (Error 7412)  OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Invalid connection string attribute". [SQLSTATE 01000] (Error 7412).  The step failed.,01:40:38,16,7412,,,,0

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-21 : 12:16:42

check the performance of query in remote server first and try to optimise it to execute faster
Also you can change the timeout value in linked server properties to avoid this issue, but it should be last option

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-22 : 06:13:10

its a simple select and insert query, nothing complex!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-22 : 06:22:24

how much time query takes when executed on remote server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources