SQL Logins using local user accounts on a clustered instance.

From: Srini (Srini_at_discussions.microsoft.com)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 15:50:01 -0700

Hi,

We have a clustered SQL server 2000. I would like to know If it is possible to create SQL login for a local NT useraccount using windows authentication on that clustered server. And later I would like to use that login as a user for one of the databases.

I could successfully add a domain user account as SQL Login using windows authentication. But when I tried to add the Local windows NT user account as an SQL login, it comes back and says something like "Can not find the user..."

If anyone knows the answer please let me know.

Thanks in advance.
Srini

Relevant Pages

  • Confused about Windows Authentication
    ... I read in the help file for MSSQL 2005 that Windows Authentication is ... I don't want the connection strings available ... Create a user account in Master that gives it the rights to do ...
    (microsoft.public.sqlserver.security)
  • RE: Create Database in VS.Net IDE
    ... Not associated with a trusted SQL ... Server connection. ... Windows Authentication, the default authentication mode for MSDE 2000 is ... administrator user account. ...
    (microsoft.public.vsnet.general)
  • Re: deny users from accessing server from Management Studio
    ... MS-ACCESS application using Windows Authentication. ... Authentication and use the SQL Login assigned to them. ... that I can turn off/disable Windows Authentication option? ...
    (microsoft.public.sqlserver.security)
  • Re: "not a trusted connection", means what EXACTLY?
    ... Does the user account have an ... associated SQL login? ... Jeff ... "Maury Markowitz" wrote in ...
    (microsoft.public.sqlserver.server)
  • Re: can login from (Windows) Admin account
    ... _Admin_ account using Windows authentication. ... mixed mode, i.e., use SQL login rather than Windows authentication. ...
    (microsoft.public.sqlserver.msde)