Re: How to check user_id and password via ADO ?

From: BP Margolin (bpmargo@attglobal.net)
Date: 11/18/02


From: "BP Margolin" <bpmargo@attglobal.net>
Date: Sun, 17 Nov 2002 19:56:41 -0500


Michael,

SQL Server, when in Mixed Authentication mode, automatically checks user's
logins and password ... there is nothing that you need to do ... except make
sure that SQL Server is actually in Mixed Authentication mode and not
Windows Authentication mode.

The section "Authentication Modes" (adminsql.chm::/ad_security_47u6.htm) in
the SQL Server 2000 Books Online has additional information.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Michael" <ruihuiwen@hotmail.com> wrote in message
news:uWovxwpjCHA.1584@tkmsftngp11...
> I am trying to connect to SQL Server2000 via ASP + VB Script +ADO,
> All the users have their owen user_id and password.
> Please tell me how can I check the user_id and password while user logins?
>
> Thanks
>
>
> Michael
>
>
>
>



Relevant Pages

  • Re: losing sysadmin
    ... You can edit the registry key (This key will vary slightly for a default ... > 1)My SQL Server is in Mixed Authentication Mode. ... > 4)Now I changed the Mixed Authentication Mode to Windows ...
    (microsoft.public.sqlserver.security)
  • RE: security
    ... SQL Server has two authentication mode: ... Mixed Authentication mode. ... administrator permission. ... Server however he need to be assigned more sql server permissions to ...
    (microsoft.public.sqlserver.setup)
  • How to set SQL Server only accept SQL Server Authentication mode?
    ... How to set SQL Server only accept SQL Server Authentication mode? ... Our company will not use mixed authentication mode, how to switch SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)