sp_tables_ex returns

OLE DB provider "SQLNCLI11" for linked server "DMXBIOPPVWD01" returned message "Unspecified error".

OLE DB provider "SQLNCLI11" for linked server "DMXBIOPPVWD01" returned message "Communication link failure".

OLE DB provider "SQLNCLI11" for...

after it says test ok

then get this error

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement...

so the answer is to uninstall 2014 cluster

install 2008r2 cluster

install 2014 cluster

this is a non critical box but the client has an app that wont work in 2014

so i offered compatibility mode but that was a turned down

I am...

so what they are saying is that if you run the r2 software and install it on different drives that should work

that is why am doing the sp_testinkedservers

to find out what servers on or off

before i query them

in the wonderful vm world that i live in servers turn...

it is actually taking 40 seconds and the servers are not even on

i did change the remote login from 30 seconds to 15 seconds

and now the sp_testlinkserver will...

i thought about that but I need to write to a table and the linked servers are only one way direction

what i was hoping for is servera.dbbc

what i have...

thanks for you help between your info of adding the dmb to the reports

servername\dmb_reports

works

it appears the gentleman removed the reports directory and created a new dmb_reports directory

dmb is the current management reports that is working and i can run but i can't connect...

yes they Ad services but the trusted for delegation would be a change on their side which i cant do