I'm really grasping here. Are there performance issues when executing activities that do not involve accessing SQL Server? Loading a Word document for instance?
I'm wondering if something screwy with MDAC installed on the machine. It might be worth uninstalling whatever version is on there and reinstalling MDAC 2.6.
You'll have to have a Windows 2000 CD to do the removal.
I know you guys have put this issue away or perhaps even resolved it but I though I'd share my findings:
I was experiencing the same problem as described in this thread and decided to search UT for the answer and I found the possible solutions found on this thread not to be of any help.
Since my client has a mix of servers (Win2K Server, Novell and possibly others) I decided to install the latest Novell Client since it had to login to Novell to get it's IP address. During the install I chose the custom install choosing options such as: IP Only, Remove IPX if present, etc. Low and behold our SQL Server login went from 1 minute to .1 second. It was a world of a difference.
I know this doesn't necesserally apply to you guys or anyone else but if you are running Novell on your network this may be the answer to your slow connections to SQL Server.