topic Re: authentication_mode=OSA means? in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/authentication-mode-osa-means/m-p/751219#M19916 <HTML><HEAD></HEAD><BODY><SPAN>OS Authentication means that the sql server client is passing along your credentials to the database.&nbsp;&nbsp; For SQL server that works nicely because it can use Microsoft active directory as credentials.&nbsp; 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.&nbsp; The other half is authorizing the users in SQL Server to log on and provide them with permissions to see the data.&nbsp; You can authorize only some of the people in you active directory to log onto and read or write data in the database.&nbsp; You can give different permissions to people to different tables etc.&nbsp; 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.</SPAN></BODY></HTML> Wed, 15 Feb 2012 18:43:44 GMT AlexanderGray 2012-02-15T18:43:44Z authentication_mode=OSA means? https://community.esri.com/t5/arcobjects-sdk-questions/authentication-mode-osa-means/m-p/751218#M19915 <HTML><HEAD></HEAD><BODY><SPAN>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?"&nbsp; So, if a login fails then the userid returned by WindowsIdentity.GetCurrent() does not have permissions to login to the database?</SPAN></BODY></HTML> Wed, 15 Feb 2012 18:18:57 GMT https://community.esri.com/t5/arcobjects-sdk-questions/authentication-mode-osa-means/m-p/751218#M19915 GeorgeFaraj 2012-02-15T18:18:57Z Re: authentication_mode=OSA means? https://community.esri.com/t5/arcobjects-sdk-questions/authentication-mode-osa-means/m-p/751219#M19916 <HTML><HEAD></HEAD><BODY><SPAN>OS Authentication means that the sql server client is passing along your credentials to the database.&nbsp;&nbsp; For SQL server that works nicely because it can use Microsoft active directory as credentials.&nbsp; 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.&nbsp; The other half is authorizing the users in SQL Server to log on and provide them with permissions to see the data.&nbsp; You can authorize only some of the people in you active directory to log onto and read or write data in the database.&nbsp; You can give different permissions to people to different tables etc.&nbsp; 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.</SPAN></BODY></HTML> Wed, 15 Feb 2012 18:43:44 GMT https://community.esri.com/t5/arcobjects-sdk-questions/authentication-mode-osa-means/m-p/751219#M19916 AlexanderGray 2012-02-15T18:43:44Z