I have an application that I am migrating from SQL 2000 to 2008. This has gone mostly smoothly. The local machines running Win XP and the VB6 application are working. One machine (only one I can get to directly) runs Win Server 2003 and it works OK. However, the workstations at the remote location are running the VB6 app on Windows 2000. Those do not work.
My question is: what might be missing or out-of-date on the Win 2000 machines, if anything, that would prevent them from working with SQL Server 2008.
Without knowing which error message(s) you're getting, or what methods you are using to connect to the SQL server I'd say your first bet is to ensure the Win 2000 machine(s) have updated Microsoft Data Access Components (MDAC) installed. You can get MDAC 2.8 SP1 from MS here.