Re: Add NT users

From: Richard Waymire [MSFT] (rwaymi_at_online.microsoft.com)
Date: 03/18/04 

Date: Wed, 17 Mar 2004 16:58:36 -0800

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: Unknown Issue with Media Player *Ripping Issues*
    ... Analog, is disabled, on that dialog... ... And if this is down to a problem with the connection and etc, ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windowsmedia.player)
  • Re: SQL Connection Strings
    ... "William Vaughn" wrote: ... the query plan is not going to change based on rights. ... What makes you think the SP or SQL Server will get confused? ... See Chapter 9 in my book or my blog for more info on connection issues ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection Problems
    ... >Program Manager ... >> Repository to SQL Server 2000. ... >> confers no rights. ...
    (microsoft.public.sqlserver.olap)
  • Re: accessing remote database
    ... The DBA then grants rights to a selected few stored procedures or views but NOT to any underlying tables. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... My manager argues that accesing through Web Service is more secure because clients don't have connection string embeded in application. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Connection Strings
    ... The connection string does not change. ... "William Vaughn" wrote: ... the query plan is not going to change based on rights. ... What makes you think the SP or SQL Server will get confused? ...
    (microsoft.public.dotnet.framework.adonet)