thx ed b.  what if we forget about the surrogate db.   and all we have is what shows below.   can he avoid changes to his code base on db2?

server1 ,...

we arent always the most transparent group but from what i could tell a mismatch of oracle credential info finally got us past the long running open query.   specifically it...

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 month, 4 weeks ago by  stan.
• This reply was modified 1 month, 4 weeks 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...

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 2 months, 1 week 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 2 months, 1 week ago by  stan.
• This reply was modified 2 months, 1 week 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 2 months, 1 week ago by  stan.