Unanswered: Login problems with Microsoft SQL Server 2000a
I am trying to access my SQL via Microsoft Access XP.
MS SQL Server 2000a is running on Windows 2003 and I am using SQL Authentication.
Every time I query is ran, and sometimes there are half a dozen back to back, I get an error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Followed by a login prompt. I then enter the correct information, and uncheck "use trusted connection" and click OK. It will then proceed successfully.. until the next query comes along and the same error and dialog appears with the updated information seemingly erased entirely, requiring me to enter my info once again.
I have checked my version of MDAC and installed every possible windows and office update.
Any ideas? Or if no one knows, perhaps someone knows an informative site that could educate me on the basics of setting it all up to use Windows Authentication?