Integrating SQL Server login RRS feed

  • Question

  • Hello everybody,


    I actually does not know where to put my thread. But i believe that all of you would advise me on the matter that i faced.


    I actually planned to propose a single sign on (SSO) methodology to my client.


    I have about 30 application - all in web based - developed using Visual Studio .NET (VB.NET). And  the database using SQL Server 2005.


    The thing is, I would like to integrate the login for the these 30 applications using the AD login - which is the login used to logged in the windows.


    And also, these 30 application's connections to the database also using the AD login and password as well. Including the Exchange.


    It seems like once we create a new account in AD and put all the applications that he/she can access and his/her rights, it will then automatically create the login in SQL Server. Not stored in table but in SQL Server login (under security folder).


    My web based application connect to the database using INF file.


    My questions are:


    1) Can this proposal be done instead of just as a logical view?


    2) Can you guys help me in-terms of giving me the techniques or the manuals?



    Thank you in advance.

    Wednesday, October 15, 2008 2:51 AM


All replies