Re: strange sql-server login problem

From: David G. (david_nospam_at_nospam.com)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 17:43:49 -0400

peter wrote:
> We us integrated security for our sql-servers, and since about a
> month we have a strange problem with one of the servers:
>
> Some users can no longer connect to it (through ODBC) and get an
> error : 'login failed for 'NT AUTHORITY\UNKNOWN USER'.
> These users can still connect to other sql-servers without problems,
> and some users have no problem at all connecting to the server.
>
> I've checked and double checked security, logins etc but can find no
> logic here.
>
> Any suggestions? All help would be appreciated...

Is there an actual error number returned by SQL Server? Maybe the login
timeout is set too low. 

-- 
David G.

Relevant Pages

  • Re: strange sql-server login problem
    ... > These users can still connect to other sql-servers without problems, ... > I've checked and double checked security, logins etc but can find no ... Is there an actual error number returned by SQL Server? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Security related
    ... Server or Integrated logins. ... suggest you use Integrated security if you can. ... SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... I finally discovered that there was a whole folder structure under ... Event viewer shows normal logins, but I did not have it set to record ... there are a bunch of logins for Website Accounts created by the ... order to find those files on the Web Server I had to make sure that System ...
    (microsoft.public.windows.server.networking)
  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: Enabling STARTTLS in Exchange 2003 IMAP service?
    ... For the first, if you simply want to enable encrypted logins, then once you ... I guess I don't understand the need to have that command listed. ... > This section describes a means for "upgrading" an ordinary cleartext IMAP ... In order to use it, however, the server must advertise support for ...
    (microsoft.public.exchange2000.protocols)
Loading