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

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

From: "Proman" <proman@163.com>
Date: Sun, 14 Jul 2002 13:33:46 +0800

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: Microsoft Web Data Administrator
    ... > login USING WINDOWS NT Integrated Security.... ... if you can not connect using SQL Server authentication at all, ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL 2005 Express security
    ... delivering the database as a file with the install package. ... Where can I find information on how to set up the install package and the ... Express 2005 is installed to use SQL Server Authentication? ...
    (microsoft.public.sqlserver.security)
  • Re: 2000k connect from outside domain
    ... You cannot fill in the user name and password because by doing so you are telling the login process to use SQL Server Authentication rather than windows authentication, and you would need a SQL Server authenticated login to do so. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... Changing a Windows password is always completely invisible to SQL Server. ... The Windows login is completely separate from a SQL Server login, ... If you are using SQL Server Authentication, then one doesn't even have to ...
    (microsoft.public.sqlserver.security)
  • Programmatically create DSN usind SQL Server Authentication
    ... I am trying to programmatically create a DSN on a target system for SQL ... Server using SQL Server Authentication. ... is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
Loading