March 22, 2012 at 8:30 am
students and faculty connect to SQL Server from home to complete assignments. Rather than create a sql login for each user I would like to be able to somehow use their Windows AD login information so they can login to SQL remotely. Is this possible? If I add their Windows accts to SQL Security, they can't login remotely because there is no AD to authenticate them, whether I add them individually or as a group. My goal is for users to be able to use the same credentials they would use for Windows, and if they change their Windows password, their SQL password would automatically sync up with that so they don't need different credentials for each.
March 22, 2012 at 10:10 am
I do not know of a way to handle this case natively from within SQL Server. One way to handle this outside SQL Server might be to create an application for your users to use whenever changing their password that would reset their Active Directory password and their SQL Server login password simultaneously, to keep their passwords in sync. It would require some re-training and could potentially be done inconsistently by some users, causing a new set of issues, but that would solve your specific issue.
It may even be possible to override the default set of steps Windows carries out when a user changes their password through Windows, where you could extend what is done to also change the SQL login password. This is not something I have done, and it is a little outside my domain of knowledge as it would require some Windows programming, and possibly some Group policy adjustments, but in theory I think that it is possible.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 23, 2012 at 11:37 am
OPC thank you so much for this information! At least now I know I'm not missing some obvious solution. I'll investigate your suggestion.
March 23, 2012 at 11:43 am
Anytime! While I could not provide an easy path or complete solution, I am happy to assist 🙂
If you do not mind, if you decide to implement something, whether it be a new application for your users to change their password or something else, it would be most appreciated if you posted your solution so myself and others can learn and benefit.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply