Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

The Environment:

  • 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.

share|improve this question
1  
Did you create a SQL login for TestUser? If so, does that user have the appropriate access to at least one database? –  joeqwerty Jan 17 '13 at 19:12
    
hey joe, yes all sql priviledges are set for TestUser. I don't think that this user is being recognized by SQL Server because when I look at the SQL Logs, it tries to log in with user '' when it should be TestUser. –  nav Jan 17 '13 at 20:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.