Re: Add NT users

From: Wayne (anonymous_at_discussions.microsoft.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 01:23:58 -0800

We are not using any development tools - just settingup
the ODBC connection to enabled Access/Excel to make
connections to the SQL Server!

It is where the ODBC Admin tool (setting-up a DSN) that
has failed - any idea?

Cheers!
>-----Original Message-----
>it'd be in the application code.
>
>--
>Richard Waymire, MCSE, MCDBA
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Wayne" <anonymous@discussions.microsoft.com> wrote in
message
>news:c10501c40c3f$eb6ae260$a601280a@phx.gbl...
>> Good point - Can't remember where I last checked for
this
>> info - can't find it in the Profiler or Performance
>> Logs/Alerts.....any hints?
>>
>> >-----Original Message-----
>> >what's the connection string look like? This error
>> typically means SQL
>> >Server thought you were coming in with a standard
>> security connection...
>> >
>> >--
>> >Richard Waymire, MCSE, MCDBA
>> >
>> >This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>> >"wayne" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:ecb201c40c36$87a17810$a301280a@phx.gbl...
>> >> After adding NT users as SQL Server logins, I tried
to
>> set
>> >> them up on their PC using ODBC connections but get
the
>> >> message:
>> >>
>> >> SQL Server error: 18452
>> >> Login failed for user (null). Reason: not associated
>> with
>> >> a trusted SQL Server connection
>> >>
>> >> Can someone advise on basic checks?
>> >> (Our SQL Server is setup for MIXED MODE and I myself
can
>> >> use the NT Authentication since I belong to the SQL
>> ADMIN
>> >> group via the main DOMAIN server setup)
>> >>
>> >> thks!
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: ODBC to SQL Server Express?
    ... >Server connection, in both the system's ODBC connection manager and the ... >>>Can I create an ODBC connection to SQL Server Express? ... >>>Server Express and Visual Web Developer Express (for a database frontend ... I need to access the SQL Server Express databases via ODBC. ...
    (microsoft.public.data.odbc)
  • Re: Connection Error: ADO.Net and SQL Server 2005
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... I can connect to the server through an ODBC connection ... It is very puzzling because this client doesn't seem to have anything ...
    (microsoft.public.sqlserver.connect)
  • Re: I cannot Create an ODBC source for SQL server 2005
    ... For a couple of years - since the installation of an enterprise database using SQL server 2005 - we had no problems with the ODBC connection on clients. ...
    (microsoft.public.sqlserver.connect)
  • Re: sqlserver 2000 sp3 (on windows 2003 server) - access 2002 odbc error
    ... Can he ping the other Windows 2003 SQL Server? ... > when he creates a new odbc connection to that sqlserver he gets the ...
    (microsoft.public.sqlserver.connect)
  • Re: Weird ODBC Behavior on IIS server
    ... > uses basic authentication and connects to a SQL Server and Oracle ... > Our ASP pages appear to be connecting to the database using the users ... rather than the credentials in the ODBC DSN connection. ... > The ODBC connection on the IIS server has the "With SQL Server ...
    (microsoft.public.inetserver.iis)