I have ran into a problem with Windows Server 2003 and SQL Server 2005 using ODBC Drivers. Here is my following scenario.
I have an application that currently uses ODBC System DSN's to connect to a SQL Server 2005 database.
Application is running on Windows Server 2003 R2 (64-bit) Stardard Edition. The ODBC Driver for SQL Server is version 2000.86.3959.00. The application is 32 bit and I am using the sysWow64\odbcad32.exe to set up my DSN. (Also tried with 64-bit odbcad32.exe and doesnt work).
My SQL DB is SQL Server 2005 with Mixed Mode set (It accepts SQL Server Auth, and Windows Auth).
When I try to run my application, I chose the correct System DSN and I run into the following Error when connecting under SQL Authentication:
A database error has occured.
18452 28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection.
From my interpretation of this message, it seems as if the Driver is having difficulty parsing the SQL User name which in my case is TestUser.
When I run my application using Windows Authentication it works just fine.
Also to note: This behaviour also occurs when I run my application on a Windows Server 2008 R2 64 bit. I believe it may have something to do with the driver but I am not sure exactly what.