December 17, 2008 at 7:43 am
I have many sql servers across 3 data centre/ sites however I can only execute xp_cmdshell queries to servers local to that datacentre/ site.
Pure t-sql simple queries, e.g. @@Servername across site are fine. It is those that include xp_cmdshell don't work
e.g. EXEC MASTER..XP_CMDSHELL 'dir /p'
"Msg 64, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)"
Anyone found this before, and what rule was blocking it from working?
Regards
Rob.
December 17, 2008 at 8:08 am
Are you trying to pull information across the network via a mapped drive on a local server?
December 17, 2008 at 8:14 am
no, absolutely any xp_cmdshell would fail, e.g. "date /t".
December 17, 2008 at 8:15 am
I am just running the query in SSMS or Redgate MultiScript.
December 17, 2008 at 8:38 am
Does the SQL service account have "Act as a part of the operating system" permissions from within start--> administrative tools-->local security policy -->local security settings --> user rights assignment
December 17, 2008 at 8:52 am
It wasn't on. I turned it on but the result was the same unfortunately.
But to be clear I can run the query successfully on this and any other server in the same data centre/ location. It is only when I run it from our Administration box in another pyscially disparate location that it fails.
I wondered if it would be a Firewall issue but our engineers weren't helpful in diagnosis from this angle.
December 17, 2008 at 9:25 am
Given that you are connected to the server via SSMS there should be no firewall issues involved.
Does it show any further errors in the SQL log or the Windows Event logs?
December 17, 2008 at 9:27 am
nope, none at all. I am running SSMS via an admin box, not locally to the servers.
December 17, 2008 at 9:29 am
Right, but the admin box connects to the remote servers for you to attempt running the xp_cmdshell, correct?
December 17, 2008 at 9:30 am
yes, that's right.
December 17, 2008 at 9:36 am
Clustered servers?
December 17, 2008 at 9:37 am
any sort of server, clustered and stand alone.
December 17, 2008 at 9:56 am
Are you able to open SSMS on the actual servers themselves and attempt to execute the xp_cmdshell or are you strictly limited to attempting it from your admin box?
April 5, 2011 at 3:57 am
I'm also getting the same error while running xp_cmdshell....can someone please help...
Msg 64, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
July 18, 2012 at 6:34 am
Anyone find a solution?
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply