Re: Authentication for Membership Provider not working with IIS7

MoonCSD — Fri, 14 Nov 2008 12:49:16 GMT

Thanks to Rick Anderson, I was able to get this working:

http://weblogs.asp.net/nannettethacker/archive/2008/11/14/membership-provider-connections-to-remote-database.aspx

Authentication for Membership Provider not working with IIS7

MoonCSD — Thu, 13 Nov 2008 21:56:14 GMT

I have windows 2008 web server edition and IIS7, and sql server 2008 web server edition.

On my windows 2000 server and database servers, I use asp.net membership with no problems. But I am having login problems using the membership provider with 2008 and IIS7. I have no problems viewing grids and doing database things that do not require log in. It only effects the membership provider logins and other functionality.

In the app pool I did this:

Set the identity on the app pool in IIS7 to "NetworkService" I tried both Integrated and Classic.

I have forms authentication enabled and anonymous authentication with my SQLIISUser and the password inserted in the IIS7 for this website.

I have tried a connection string with both windows authentication and sql server authentication:

I was told to: update your connection string to "Integrated Security=SSPI;" not "Integrated Security=true;" - which I did.

This gives login failed for anonymous user error:

This gives log in failed for SQLIISUser.

<add name="XXConnectionString" connectionString="Data Source=xx.xx.xx.xx;Initial Catalog=XX;

Persist Security Info=True;User ID=SQLIISUser;Password=XXXXXX"

providerName="System.Data.SqlClient" />

My membership settings also include:

</appSettings>

<system.web>

</providers>

</membership>

</providers>

</roleManager>

On the SQL Server 2008 database, I have the SQLIISUser setup as a user, and given dbdatareader and dbdatawriter and public permissions on the database. I also have a "NT AUTHORITY\NETWORK SERVICE" user with db_owner access.

Again, all database connections work fine remotely, with windows authentication and with sql server authentication if only viewing data in a grid or doing inserts or updates, etc. But once I try to use the membership stuff, that's where it fails.

Please help.

Partial stack trace for login failed for sql user:

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844759

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392

System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35

Thanks!

IIS7 - Security

Re: Authentication for Membership Provider not working with IIS7

Authentication for Membership Provider not working with IIS7