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
DBRW connection to two same named instances, on different servers
-
- 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
Anthony
That's no moon - that's a space station
That's no moon - that's a space station
-
- 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
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
-
- 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
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
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
That's no moon - that's a space station
-
- MVP
- Posts: 2832
- 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
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".
-
- 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
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