SQL Server connection name change

Hi,

Anyone could help me with changing the IP of SQL server connection to the hostname of SQL server connection? I can not find where to change it.

Thanks for the help.

Check ODBC connections.

Take a look at the Migration procedure, the Database Migration section contains some information that are relevant to your question:

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Endpoint%20Manager/page/Server%20Migration?section=Database

Hi,
Thanks for reply.
But it seems quiet complicate. It is the normal steps for bigfix?
There is no change about the DB.
We just want to change IP to hostname. Is there any other easy way for bigfix to do that?

Thanks.

Quoting the article

Modify the ODBC System DSNs (bes_BFEnterprise, bes_EnterpriseServer, enterprise_setup, and LocalBESReportingServer) to point to the new SQL server instance. This modification will allow you to avoid re-installing the BigFix Server application.
*Use ODBC connection wizard to test connection
*For 64-bit Windows systems, use the 32-bit version of the ODBC tool (C:\Windows\SysWOW64\odbcad32.exe) to configure the System DSNs.

These days I believe you’d use both the 32- and 64-bit odbcad32.exe programs to update both DSNs

Hi, Jason

 OK.  Thanks for reply.
 I will try it.

Thanks.