|
Home > Archive > MS SQL Server > March 2006 > xp_fixeddrives across a linked server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
xp_fixeddrives across a linked server
|
|
| Jeffrey K. Ericson 2006-03-08, 8:23 pm |
| I am trying to populate a table with the results of xp_fixeddrives. I have a
cursor that pulls a list of servernames from a table and generates dynamic
SQL to run servername.master.dbo.xp_fixeddrives. It works dandy by itself but
on 2 of 6 remote servers it hangs when I issue "insert into table exec
servername.master.dbo.xp_fixeddrives". Issuing exec
servername.master.dbo.xp_fixeddrives works fine on all the linked servers. I
checked the link defs for all the servers and they are the same. All Servers
are at 2kSP3. When I attemp to cancel the query, it runs for another 10
minutes before reporting a broken connection and an ODBC error message as
follows.
Query cancelled by User
[Microsoft][ODBC SQL Server Driver]Operation canceled
[Microsoft][ODBC SQL Server Driver]Timeout expired
ODBC: Msg 0, Level 16, State 1
Communication link failure
Connection Broken
Any ideas?
| |
| John Bell 2006-03-09, 3:23 am |
| Hi
A couple of things you may want to check:
What is the service account for SQL Server on the remote servers?
What permissions does the account have?
John
"Jeffrey K. Ericson" wrote:
> I am trying to populate a table with the results of xp_fixeddrives. I have a
> cursor that pulls a list of servernames from a table and generates dynamic
> SQL to run servername.master.dbo.xp_fixeddrives. It works dandy by itself but
> on 2 of 6 remote servers it hangs when I issue "insert into table exec
> servername.master.dbo.xp_fixeddrives". Issuing exec
> servername.master.dbo.xp_fixeddrives works fine on all the linked servers. I
> checked the link defs for all the servers and they are the same. All Servers
> are at 2kSP3. When I attemp to cancel the query, it runs for another 10
> minutes before reporting a broken connection and an ODBC error message as
> follows.
>
> Query cancelled by User
> [Microsoft][ODBC SQL Server Driver]Operation canceled
> [Microsoft][ODBC SQL Server Driver]Timeout expired
> ODBC: Msg 0, Level 16, State 1
> Communication link failure
>
> Connection Broken
>
> Any ideas?
| |
| Jeff Ericson 2006-03-09, 8:23 pm |
| All the servers use the same svc account (except one) and they are all SA.
Now one thing I'm looking at is the DTC service account as I get strange DTC
related errors. The DTC accounts are setup different ways but t6he problem
is not consisten from box to box. Another interesting note, I can't run from
A to B but I can run the fully qualified query on B writing to the same table
on A.
I'm trying to avaiod running this process from each server vs a central
location.
"John Bell" wrote:
[color=darkred]
> Hi
>
> A couple of things you may want to check:
> What is the service account for SQL Server on the remote servers?
> What permissions does the account have?
>
> John
>
> "Jeffrey K. Ericson" wrote:
>
|
|
|
|
|