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.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-12-01 : 01:13:29
|
| i have job that run each 15 minutes.this job connect to remote sql server with linked server.the problem is that between 6:00-7:30 am ,i get this error:"Executed as user: DRTO\ServerAdmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 06:52:00 Error: 2010-12-01 06:52:37.95 Code: 0xC0202009 Source: MMC Original Data MMC Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E14 Description: "Named Pipes Provider: Could not open a connection to SQL Server [1311]. ". An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E14 Description: "OLE DB provider "SQLNCLI10" for linked server "132.1.5.101" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".". An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E14 Description: "OLE DB provider "SQLNCLI10" for linked server "132.1.5.101" returned message "Login timeout expired".". End Error Error: 2010-12-01 06:52:37.95 Code: 0xC004706B Source: MMC Original Data SSIS.Pipeline Description: "component "MMC Source" (1)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2010-12-01 06:52:37.95 Code: 0xC004700C Source: MMC Original Data SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-12-01 06:52:37.95 Code: 0xC0024107 Source: MMC Original Data Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 06:52:00 Finished: 06:52:37 Elapsed: 37.565 seconds. The package execution failed. The step failed."is the problem on the network or on the server? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-01 : 03:50:56
|
| "Named Pipes Provider: Could not open a connection to SQL Server [1311]. ""OLE DB provider "SQLNCLI10" for linked server "132.1.5.101" : Server is not found or not accessible."Sounds like the server is not available. Does this happen every day at the same time? if so then its probably rebooting or somesuch.Did you mean to sue Named PIpes rather than TCP/IP?"OLE DB provider "SQLNCLI10" for linked server "132.1.5.101" returned message "Login timeout expired""You will probably get that if the Server is unreachable, but it might just be that the system is slow / busy at that time and is too slow allowing your connection (an if you did connect it would probably timeout whatever you were trying to do). Maybe index rebuilds or somesuch housekeeping?"Elapsed: 37.565 seconds"Seems like it tried for a decent while - as the timeout indicates |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-12-01 : 04:06:54
|
| 1.it happen everyday,at same time (between 6:00-7:30 am)2.where i change to use TCP/IP ?3.i think that netwotk is busy (not system)what should i do? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-01 : 11:39:09
|
| "2.where i change to use TCP/IP ?[i/]"SQL Server Configuration manager (on the Server) - under "Alias""3.i think that netwotk is busy (not system)"A network that is too busy to allow a login to succeed in 30 seconds is going to be unusable for anything else!"[i]what should i do?"Find out what is going on on that machine at 6:00 - 7:30If that cannot be changed then run your task at a different time. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-01 : 11:49:16
|
| Backup job is running?By that I mean something that shuts down the server, copies the files then restarts the server?I think I'm joking there.Something else runs that shuts the link between the machines during that period - some housekeeping job somewhere?what is the connectivity bewteen that job and the server?Could someone be unplugging a router somewhere - or maybe using the bandwidth exclusively to download films?Have a look in the sql server and windows logs to verify that nothing is happening on the server.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-12-01 : 12:23:52
|
| under "Alias" there are no items |
|
|
|
|
|
|
link server