question

PhilipvanGass-2135 avatar image
0 Votes"
PhilipvanGass-2135 asked UriDimant answered

SQL Server Management Studio

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-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JoffreyNURIT-4769 avatar image
0 Votes"
JoffreyNURIT-4769 answered

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://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/authentication-in-sql-server

alt text



6648772.jpg (77.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
1 Vote"
DSPatrick answered

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




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

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"

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

UriDimant avatar image
0 Votes"
UriDimant answered

hI
Please read this article
https://docs.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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.