authentication_mode=OSA means?

02-15-2012 10:18 AM
Occasional Contributor III
When querying a network SQL Server database using "authentication_mode=OSA" when the help says: "OSA uses the operating system credentials to establish a connection with the database." does that means that my current network login is used the same way that SQL Server supports "Windows Authentication?"  So, if a login fails then the userid returned by WindowsIdentity.GetCurrent() does not have permissions to login to the database?
0 Kudos
1 Reply
Regular Contributor II
OS Authentication means that the sql server client is passing along your credentials to the database.   For SQL server that works nicely because it can use Microsoft active directory as credentials.  Credentials are only half the picture though, that just means, I know who you are and I can be sure of it because you used a domain account authentication to log onto the windows workstation.  The other half is authorizing the users in SQL Server to log on and provide them with permissions to see the data.  You can authorize only some of the people in you active directory to log onto and read or write data in the database.  You can give different permissions to people to different tables etc.  So it is possible that you are logged into the workstation using your windows domain account and that account may not be authorized to log onto the SQL server instance.
0 Kudos