(imported topic written by YorkLy)
Hi All, a customer with TEM v8.1 upgraded from v7.2.x is planning to move their SQL server to a different location, what would be the procedures? Customer has backup the BES database.
I have looked at the TEM Administration Guide v8.1 and found these section below changing the ODBC connection. I still think there should be more steps involved changing the SQL server to a different server on TEM server. Is there a configuration file which required some modifications?
Anyone has done this and please advise. Thanks.
Thanks.
=========================
Connecting the Console to a different Server
When a Console is installed on a Server, you have the option to connect to the local Server via the bfenterprise connection and the Master Server via the EnterpriseServer connection, by default. All stand-alone Consoles only connect to the Master Server via the EnterpriseServer connection. To enable stand-alone Consoles and the Master Server Console to connect to the new replica Server, a new ODBC System DSN must be created:
-
From Control Panel > Administrative Tools > Data Sources (ODBC), select the System DSN tab, and click Add.
-
Select the SQL Server driver, and click Finish.
-
Specify the following information on the subsequent dialog: Enter bes_ for the Name, and for the Server, where is the hostname of the new replica Server. Click Next.
-
On the following dialog, specify NT Authentication or SQL Authentication as appropriate for your deployment. If unsure, use SQL Authentication. Clear the box to Connect to SQL Server to obtain default settings. Click Next.
-
Check the top box and change the default database to BFEnterprise. Click Next, and on the following panel, click Finish.
Now when the Console is started, the drop-down menu offers you the choice between EnterpriseServer (to connect to the Master Server), (to connect to the new replica Server), and, on Tivoli Endpoint Manager Servers only, bfenterprise (to connect to the local Server).
======================
York