SQL Server Management Studio

Philip van Gass 1 Reputation point
2020-01-10T13:17:59.373+00:00

When a user logs into SQL Server Management Studio, there is a choice between Windows Authentication and SQL Server Authentication.
How do I find the location of the Windows Authentication Library on my computer ?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,522 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Dave Patrick 425.7K Reputation points MVP
    2020-01-10T14:52:17.017+00:00

    QnA currently only supports the products listed in right-hand pane (more to be added). Better to reach out to subject matter experts in dedicated forums over here.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

    1 person found this answer helpful.
    0 comments No comments

  2. Joffrey NURIT 206 Reputation points MVP
    2020-01-10T14:10:43.88+00:00

    Hi

    Windows Authentication use your window account for connecting to your SQL Server database.
    Have you install your SQL Server with Windows authentication only? Or Windows authentication + SQL account?
    Your database is linked to an Active Directory, or just install with local accounts?

    Your login is depending on the choices you've made.
    If you install SQL Server on your personal machine, and your personal account is "master" on this database, just click windows authentication and it works.
    It is the same problem if you install SQL Server, link this to AD and set you as administrator.

    SQL Server supports three types of logins:

    A local Windows user account or trusted domain account. SQL Server relies on Windows to authenticate the Windows user accounts.

    Windows group. Granting access to a Windows group grants access to all Windows user logins that are members of the group.

    SQL Server login. SQL Server stores both the username and a hash of the password in the master database, by using internal authentication methods to verify login attempts.

    Source documentation:
    https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/authentication-in-sql-server

    alt text

    0 comments No comments

  3. Vaibhav Chaudhari 38,471 Reputation points
    2020-01-11T07:57:30.85+00:00

    I am not sure about the library but if you are planning to connect to SQL using some code. You can provide the authentication mode in connection string. Set Integrated security to True for Windows auth.

    connectionString="Data Source=MyServer\SQLInstance;Initial Catalog=TestDB;Integrated Security=true"

    0 comments No comments

  4. Uri Dimant 206 Reputation points
    2020-06-11T04:13:47.697+00:00

    hI
    Please read this article
    https://learn.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode?view=sql-server-ver15

    I think you mean by WA library , it is a folder that windows creates for the user who logs in into computer, but you do not need to choose the user whEn you connect via SSMS , it is populated automatically

    0 comments No comments