thx jeffrey.  i'd like to restate the problem so that i can follow what you are saying.   and distinguish his code base changes from other changes.

server1 , db1 has dbo.view1.

server2,...

thx, what if he puts a surrogate db on the new server called A.   And it has a view that thru the linked server sends the correct query to A...

• This reply was modified 1 year ago by stan.
• This reply was modified 1 year ago by stan.

thx for making me look again phil.   hidden in all that noise was this nugget which did the trick....

thx phil.   this is more about the cell data.   not headers.   i tried reading the 3 or so options at https://stackoverflow.com/questions/868064/ssrs-repeat-tablix-left-most-row-group-value-on-each-row   .

one (row number option) doesnt really apply if you...

saving to csv doesnt quite cut it as it unpivots the usage data.

stay tuned.   my peer hasnt really shared a lot about how he got us past the registration error.   something about fat client and "lots of tricks".

in the meantime, an identical...

thx frederico, one important question before i ruin his day...what if there are multiple files all having say the customer tab?  i think i understand the rest of your answer...

thx all, i've never seen a post go to 2 pages so i was posting updates to the service acct suspicion in a prior reply where i wrote "stay tuned". ...

• This reply was modified 1 year, 1 month ago by stan.

our network team added the vm to an erp group thru a network product i've heard of before that from what i understand makes all non cloud erp's accessible to...

our network team added the vm to an erp group thru a network product i've heard of before that from what i understand makes all non cloud erp's accessible to...

yes, they are the same.  stay tuned.

i'm not sure whats going on in this thread but this is the 3rd time i'm adding this info...

our network team added the vm...

• This reply was modified 1 year, 1 month ago by stan.
• This reply was modified 1 year, 1 month ago by stan.

looks like you are correct frederico.    and i did ping the same server from my local and got a reply with no loss.  in both efforts , our domain...

also, i ran this query on both our dw and vm.  i get 5 rows on our dw for registry keys ...\tcp\ip 1 thru ip 4 and ip all.

i get...

• This reply was modified 1 year, 1 month ago by stan.

thx emperor100, i ran this and believe it eliminates protocols as the problem?  Is that correct?

thx phil, its tempting but then i have to wonder why the bogus pkg has no problems connecting to a different server from the vm using native.