Change Reference to TM1 Database server

[schlemiel29]

I have to care about an existing tm1 server. On it there are a sql server, tm1 database and web services are installed. Now a new server should be used for tm1 database. I know how to install tm1 software and copying existing database. But where i have to change references to the new tm1 server? I think the web services need it, but where? An ini file?

[Martin Ryan]

I think you're referring to the tm1s.cfg file which is typically in the Data directory. Some people (e.g. me) put it one directory above the Data directory.

If you have TM1 web you'll need to update that config file too. I don't have TM1 Web myself, but I'd assume that file is in C:\inetpub\tm1web

You'll also need to re-setup the ODBC connections to your SQL database. This is done through ODBC manager in Windows. The TI process will then use this ODBC connection to access your SQL database.

HTH,
Martin

[Harvey]

For TM1Web, you can update the values in the Web.Config file, in the (by default) inetpub/wwwroot/TM1Web folder on the web server. The values you are after are:

Code: Select all

    <!-- If set, users will not be asked to enter Admin Host during login. -->
    <add key="AdminHostName" value="" />
    <!-- If set, users will not be asked to select a TM1 Server to connect to during login. -->
    <add key="TM1ServerName" value="" />

You can leave both these values blank, and allow users to select either the admin host, sever name, or both, in the TM1Web login screen.

Chances are there are many other places you might need to update references to the admin host.

It might be the best idea to leave the admin host running on the old machine and just point it to the new instance of the TM1 server. You can do this by leaving the admin host service installed on the old server and putting a reference to that machine in the tm1s.cfg file in the admin host property.

This way, users will not need to update their admin host and most likely will not notice the difference after the move to the new server.