Re: Logon failed for user '(null)'. Not associated with trusted connec

Check for differences in MDAC versions on the PCs. There was
an issue with earlier MDAC versions where ODBC connections
would ignore the authentication mode and just use windows
authentication no matter what you selected. You can use the
component check to check mdac installations. It's available
at:
http://msdn.microsoft.com/data/mdac/downloads/default.aspx

-Sue

On Wed, 4 May 2005 03:05:11 -0700, "Squirrel"
<Squirrel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Hi,
>
>I have set up system dsn's with an sql server driver on windows 2000 to use
>SQL Server Authentication (NOT Windows Authentication) on a number of client
>PC's. When I use these to connect to an sql server database (which allows
>mixed mode authentication) via excel, I get the following message on some
>(but not all) client PC's.
>===============
>Connection failed
>SQLState 28000
>SQL Server Error 18452
>[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
>'(null)'.
>Reason: Not associated with a trusted SQL Server connection.
>================
>
>When I click on OK, another SQL Server login pop-up box appears with the
>"Use trusted connection" checkbox pre-checked. If I uncheck this then it
>allows me to put in the correct user/password combination.
>Why does this happen when the DSN was set up to use a User/password
>combination in the first place?. It's as though it tries to connect with
>Windows Authentication regardless of how it is originally set up.
>Anybody have any ideas?.
>
>Thanks,
>Andy

.

Relevant Pages

  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: C# connection string using Windows NT Authentication
    ... you indicate that you are using Windows ... If you are connecting to a local instance of SQL Server on your ... it sounds much less like a connection string ... you'll need to resort to SQL Authentication. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Problems Using Laptop As SQL Server - Log On Failed
    ... > connected to the network and no password for windows. ... > the name of the laptop as name of the SQL Server. ... > trusted SQL Server connection ... you have to change the authentication mode... ...
    (microsoft.public.sqlserver.msde)
  • Re: No Windows, Only SQL Server Authentication
    ... To establish a Windows authenticated connection from OSQL, ... SQL Server programatically. ... Your connection string needs to specify the type of authentication desired. ...
    (microsoft.public.sqlserver.security)
  • Re: That $%#@ "Trusted Connection" Thing Again...
    ... SQL Server ODBC Driver Ignores Authentication ... What is the connection string you are using? ... Have you run Component checker to ...
    (microsoft.public.sqlserver.security)
Loading