WCF Service and SQL Server Authentication
How do I configure my system to authenticate WCF users on an SQL Server when I do not wish to Impersonate the actual user on the WCF service and use these credentials on the SQL Server? This would require far too much SQL Server management.
The fact is that I am developing a system where users through some WPF user interface can retrieve and modify data in a remote database through a WCF service, but I can't seem to figure out how to configure IIS, web.config, SQL Server etc. to support my requirements. Notice that the IIS and the SQL Server is not on the same machine.
Since the members of the system comes and goes I will not manage the users on the SQL Server directly. These will be managed at the service level. I tried this using Impersonation on the service and it worked fine when the only user is me (since I am created as user in the database). I want to login to the SQL Server through one user account preferably using the Windows Authentication in SQL Server, but I cannot seam to make it work.
So how can I make some WCF request run as a specific Windows user?
Really hope you can and will help,