Re: How to disable the Windows NT login authenticate at SQL-Server 2000 login Form ? @Thanks

From: Proman (proman@163.com)
Date: 07/15/02 

From: "Proman" <proman@163.com>
Date: Mon, 15 Jul 2002 20:46:05 +0800

Thanks, I am already do it.

"Jasper Smith" <jasper_smith9@hotmail.com> 写入消息新闻
:ugKic8zKCHA.2748@tkmsftngp13...
> Remove the BUILTIN\Administrators login
>
> HTH
> Jasper Smith
>
> "Proman" <proman@163.com> wrote in message
> news:uaJxmfvKCHA.1900@tkmsftngp11...
> > Hello.
> > Use Ms SQL Server 2000, There are two way to login, The first is Windows
> NT
> > Authentication, The second is SQL Server Authentication, If you choose
> > Windows NT Authentication, you can open the Database without user name
and
> > password. If you choose SQL Server authentication, you can input 'sa'
and
> > password.
> > Now I programm for a company. The software run at a PC(Windows2000, SQL
> > Server2000), the software is a business security data manager software.
> Run
> > at only one PC. But the pc will used by other people. I think the
Database
> > only open by my Software. or If other one will open Database by SQL
> > Server2000 managment tool, must input 'sa' and password.
> > I don't know how to disable Windows NT authenticate. Must input 'sa' and
> > password?
> > Thanks.
> >
> >
> >
>
>

Relevant Pages

  • 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: 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)
  • Re: Windows NT user or group not found.
    ... out what SQL Server thinks the login name is vs. what Windows thinks the ... When the SQL Server collation and the Windows collation are different, ... The following example uses the Param2 parameter to get the SID from Windows ...
    (microsoft.public.sqlserver.connect)
  • RE: How to create a trusted connection
    ... What do you mean by "creating a Windows login"? ... To login SQL Server 2000 using trusted connection, grant the Windows ... Group" in SQL Server Books Online to get the concept, ...
    (microsoft.public.sqlserver.security)
  • Re: Connecting to SQL from a Windows Service
    ... There is probably some way to debug this, but that's deeper Windows knowledge than I can dredge up right now. ... I looked into the Event Log and found that when my service ... 1st Login succeeds. ... You can try turning on login auditing in SQL Server and then check the ...
    (microsoft.public.sqlserver.connect)
Loading