our company was using a Client-Server System(VB & SQL)the Authentication,Roles and User rights are all implemented at the back end,then we migrate to N-Tier Application.
For Phase1 the security at the Back-End will stay as it's(at SQL Data Base).
For Phase2 we will manage the security at the Middle-Tier.
the DataBase needs to authenticate the client and register the Machine and User Names in some tables.
i go through some articles and i understood that if my Server Application(COM+) acts as a Client to external Resources(SQL Data Base) this is known as Impersonation.
i need a step by step guide to implement Impersonation.!!!
now i imported all my DLL's into one Package(COM+)as server application and Export an Application Proxy to my Clients but the DataBase alway recognize the Middle-Ware Machine Name and the User who is starting the Application and i don't know how to configure out so my DB Admin get the Client UserName and HostName.