We have an XP Pro SP3 client machine that connects to a database on MS SQL Server 2000 SP2 on a non-standard port. I migrated the database to a different server and need to update the System DSN. Easy enough on most machines, but on this machine, for one non-administrator, it insists on reverting back to "Dynamically determine port," which of course tries to use 1433 instead of our port. And this is a System DSN, not User.
We've searched through the registry and verified that there are no entries trying to use 1433. If you have the non-admin log in and run ODBC Data Source Administrator with admin credentials, the settings are correct.
Run it as the non-admin user and it's back to dynamic.
We've completely deleted the DSN and added it back under a different name and the same thing occurs. What am I missing?