Cannot add new NT login

From: Bill R. (bill.reuter_at_phoenix-esi.com)
Date: 07/31/03 

Date: Thu, 31 Jul 2003 16:25:56 -0400

Running S2Ksp3 on W2K

When adding a new login, (whether through Enterprise Mgr. or stored proc
sp_grantlogin) on a Security mode SQL Server of Windows Only, I "sometimes"
cannot add a new login. They are in NT, for months. Others I can add with
no problem. If I reboot the server, I can then add the login. Some time
later, weeks?, I again cannot add a login, but I can add others.

Error message below. Any ideas? Where should I look for some help?

Server: Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 41
Windows NT user or group 'PUSNJLP\bostrke1' not found. Check the name again.

The name is in NT and I can add her to other SQL Servers with the same
security mode. Again, this is one of those "sometimes" things.I cannot
reboot the server whenever I want.

Thanks,
Bill

Relevant Pages

  • Re: Granting permission to a database - need help
    ... Windows authentication, and not use an application login, as then ... Links for SQL Server Books Online: ... USE Driver Access ...
    (microsoft.public.sqlserver.programming)
  • Re: ODBC worked until Server reboot defaulted to windows authentic
    ... I got the exact spelling of the windows login with the case and I rebooted ... The odbc source is set up in windows and that connects on the test. ... The SQL Server Mgmt studio connects also but only as Windows authentication. ...
    (microsoft.public.sqlserver.setup)
  • Re: login 101..
    ... On Windows 2003, SQL Server 2005 can enforce the Windows password complexity ... Windows authentication - SQL Server uses a special protocol to ask ... user is in the list of allowed logins, ...
    (microsoft.public.sqlserver.security)
  • Re: Granting permission to a database - need help
    ... folder and it would have the database connection info. ... Windows authentication, and not use an application login, as then ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • RE: How to create a trusted connection
    ... You need to grant access for the Windows login by referring to the books ... is set to use Windows authentication to be able to do trusted connection. ... There are two modes of authentication in SQL Server: ...
    (microsoft.public.sqlserver.security)