I have different Applications using VB 6.0, VB.NET and Compact Framework 3.5. Now my client demands LDAP-Authentification (Active Directory) for all of it.
All Applications using the SQL-2014-Server and I would like to solve this problem with a Stored Procedure that does all the magic.
Is there allready a solution that returns a "True" when I pass a UserID and Password to it ?
That would be very helpful. I tried allready to get answers from the web, but I wasn´t successfull...
you will need to change the way your application connects to SQL;
if it currently connects via SQL username and password, you have to change the application to use integrated security instead.
then SQL will automatically check if the windows token passed by the application is valid, and what it has access to.
The classic way would be to add an Active directory group, say named MyAppAccessGroup, and add the five or five hundred people that should have acces sot that active directory group.
then you add that group as a login to SQL,and then as a user in in the right database(s), and add the right permissions(data reader, writer, execute, etc.. that will allow them to have your permissions for the application.
so to be clear, AFTER someone connects to SQL with a SQL username and password SQL Server CANNOT discover their username or whether they are allowed access or not.
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!