I am not getting any error. I am not at an implementation level right now. I know how to implement Active Directory authentication. I am only talking about the design. The application for now uses ASPNETDB in SQL Server as an authentication store. What that means is that it uses the user data (specifically GUID) to apply roles, maintain all the timeentries, projects etc. The front end sends the logged in user name which is then used to pull the guid from the table and then used in all other stored proecdures and tables specific to the TT application.
Now when I will be using AD, the authentication store will change and obviously the ASPNETDB tables that were being used in the application specific stored procedures cannot be used. I would have to change all the stored procedures to not use GUID and possibly use just the user name sent from the front end.
What I am looking for is that if someone has already done this, or if the older version is available that used AD as authentication store, what were the steps taken and where all the change is required. Since there are different layes involved here, I want to be sure the code doesn't break when users are using it.