Home Forums SQL Server 7,2000 Security Windo authentication &SQL7/SQL2000 in a applic RE: Windo authentication &SQL7/SQL2000 in a applic

  • Shas3, you're right. there is that I am thinking. We need a blind login to have the right to connect to the database. But question now is : how can I kown how to get the Windows user name ?

    the name is on the registry but is the path at this place ?

    HKCU\Software\Microsoft\Active Setup\Installed Components\{44BBA840-CC51-AACF-AAFA-00AA00B6015C} ?

    We do not forget our clients could be either WIN NT, WIN 2000, WIN XP.

    IF the client decides to stay in SQL Mixed mode, means that the customer could connect either in Win authentication (without asking him the signon screen) or Sql authentication(asking him signon screen).

    Others questions : We manage users(by creating logins) that work with our application by one other application that give some rights to each user.

    How can we create WIndows authentication login like in Enterprise Manager that propose which domain, which user

    to choose. Is there a Windows DLL to show this kind of information or something else ?

    thanks for your answer.