Mixed Mode Authentication (SQLMembershipProvider )in TFS 2010

I'm new to TFS 2010 (Team Foundation Server 2010) and I'm looking forward to authenticate users in TFS using M开发者_JAVA技巧ixed Mode Authentication. I mean using Windows Mode Authentication and SQL Authentication with SQLMembershipProvider and SQLRoleProvider.

Is this possible?

Thanks in advance!

Gonzalo

---

The users that you add to the authorization of TFS, are not the users in SQL Server.

The user that is accessing the database is the service account of TFS.