DBRW connection to two same named instances, on different servers

Post Reply
AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

DBRW connection to two same named instances, on different servers

Post by AnthonyT » Mon Feb 26, 2018 9:53 am

I may be having a mental block, but I am struggling

I am using Excel to connect to two different servers - both having the same name - but on two different servers

I have an instance called Fred - one on a Pre Prod box, the other on a Prod box. There is no chance of changing the name

Normally, on the same worksheet, you can connect to multiple instances - if their names are different - but here I am trying to compare a Prod and Pre Prod instance's objects - to make sure they align

Any ideas appreciated
Anthony

That's no moon - that's a space station

Paul Segal
Community Contributor
Posts: 243
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: DBRW connection to two same named instances, on different servers

Post by Paul Segal » Tue Feb 27, 2018 8:17 am

This won't work in Perspectives. It will use the server instance with the first named admin host in options (so, if admin hosts is set to server1;server2 both with instances called Fred, then the server1 Fred will take precedence). For access from Excel, you won't be able to do what you want. It might be possible in PAX but I haven't tried it yet.
Paul

AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Re: DBRW connection to two same named instances, on different servers

Post by AnthonyT » Tue Feb 27, 2018 9:48 am

Thanks Paul

I've tried every way possible to connect to theses instances - to compare objects relationship / size / existence etc - without success. Just wondered if someone had managed it using an Admin Host prefix or something

I guess not
Anthony

That's no moon - that's a space station

User avatar
tomok
MVP
Posts: 2447
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: DBRW connection to two same named instances, on different servers

Post by tomok » Tue Feb 27, 2018 12:02 pm

You probably should have talked to a qualified consultant before setting up your environments. Anyone worth their weight in salt would have advised you not to name your services the same for this very reason. If I were you I would push back on the "There is no chance of changing the name".
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Paul Segal
Community Contributor
Posts: 243
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: DBRW connection to two same named instances, on different servers

Post by Paul Segal » Tue Mar 06, 2018 11:33 am

Although under some (carefully controlled) circumstances it can be a useful fail-over device. If server1:fred isn't available, and if server1;server2 are the admin hosts, then server2:fred will become available. Obviously it depends on how data is loaded, replicated, etc, as to how up-to-date server2:fred is, but it does work.
Paul

Post Reply