Console points to the wrong system DSN - Win7 64bit

Usage and Config Platform
1

(imported topic written by kurtastbury91)

Recently we reinstalled our BigFix server and setup a new SQL instance on a dedicated SQL server. So our new server points to that instance and logs you in with NT credentials.

Here is my question. On my laptop (Win7 32bit) I had to create a new system DSN that matched the information in the “bfenterprise” system DSN on the BES before the correct option showed up in the drop down list when starting the console. Since then I’ve had no problem opening the database from it’s new location just by selecting “bfenterprise” instead of “EnterpriseServer.” However, on another PC (Win7 64bit) when we add the new system DSN it still doesn’t show up in the drop down list when opening the Console. This seems to happen regardless of what order we add the system DSN and install the Console in.

Does this make sense to anyone? How can we add “bfenterprise” to the Console drop down list on the Win7 64bit PC?

2

(imported comment written by JackCoates91)

this article should help: http://support.microsoft.com/kb/942976

3

(imported comment written by kurtastbury91)

That worked great! Many thanks! From my boss especially.