Re: Connections errors

From: joseph (anonymous_at_discussions.microsoft.com)
Date: 11/21/03 

Date: Fri, 21 Nov 2003 08:09:24 -0800

Thanks for you post, however you are missing what the
problem is. The users connect using their SQL Server
accounts and not the NT domain account. They have been
doing that fine for a long time and I am not about to
change that. The problem is that somehow somewhere an
attempt to establish connection using the NT domain
account is occurring and we need to find how that is
happening and stop it. The attempt to connect with the NT
account is not a voluntary attemp. It is happening just
because the user has Enterprise Manager open. That is
only explanation I can find.
>-----Original Message-----
>"joseph" <anonymous@discussions.microsoft.com> wrote in
message
>news:0bfb01c3b045$d3c79410$a401280a@phx.gbl...
>> We've recently migrated to SQL 2000 and ever since we've
>> been observing connection errors that we can trace back
to
>> the user's NT domain account. The security event log on
>> the server is filling up with connection errors for
these
>> NT Domain ID's which are associate with the users that
>> have Enterprise Manager open. Somehow, enterprise
manager
>> is initiating a connection using the usrer's NT Domain
>> account which was not set up in the SQL Server. The
users
>> are assigned a SQL login name which they use without any
>> problems. The problem is with these shadow connection
>> attempts using the NT user's domain account which fail
and
>> generate an entry in the event log.
>
>It's likely that you need to grant the NT User accounts
proper sql server
>login access and database permissions.
>
>You may be seeing attempts for the NT account to connect
to the server
>itself through Windows Authentication.
>
>Steve
>
>
>.
>

Relevant Pages

  • Re: Problems changing the password for the service account in SQL
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)
  • Security context issue (weird behavior)
    ... The SQL Server is setup to use mix mode authentication. ... The users have a domain account. ... To log in to the SQL server I use an ADO connection. ... I tried to view the pages from another machine with the anonymous access ...
    (microsoft.public.data.ado)
  • Re: SQL Connection String using Domain Account
    ... Web.Config but now have the problem that the web site will not run under ... you can have a username/password set up in sql server - but this would ... The DBA has given me a Domain user account with rights to ... I am unable to get a connection to the database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Passthrough authenication w/ SQL trusted connection
    ... separate connection will be used for each security context (each user ... account will have it's own pool). ... if you are using a Windows 2000 Domain, ... backend SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Problems changing the password for the service account in SQL
    ... It is because there is BULTIN\Administrstors Login that alllow access to ... You have a domaim account group that SQL Server ... this domain account in SQL Server ...
    (microsoft.public.sqlserver.security)