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 »

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: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

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

Post by Paul Segal »

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 »

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
tomok
MVP
Posts: 2831
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 »

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: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

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

Post by Paul Segal »

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