Search code examples
sql-serverauthenticationsingle-sign-onwifclaims-based-identity

Setting up custom principal to impersonate Sql Server user

What do I need to do in order to use custom principal (Preferrably a claim based one) to impersonate a Sql Server user.

        var claims = new List<Claim>
            {
                /* What do I need in here? */
            };

        var claimsIdentity = new ClaimsIdentity(
            claims, "Basic", "UserName", ClaimTypes.Role);

        Thread.CurrentPrincipal = new ClaimsPrincipal(claimsIdentity);

In the end I want SQL Server to trust my application layer, and the principal/role that it defines.

Solution

  • SQL Server does not support that.