Hello all

I've developing a simple ASP.NET 2.0 appl using Forms authentication with membership and roleprovider data in a remote SQL database.

My setup:

PC1: Developing PC, XP Home edition, with VS 2005,  

PC2: Deploy PC, XP Pro edition, IIS 5.1, SQL Server Express. Anonymous logon is turned OFF in IIS

I've read many good blogs about the topic (Scott Guthrie: http://weblogs.asp.net/scottgu/archive/2006/02/24/ASP.NET-2.0-Membership_2C00_-Roles_2C00_-Forms-Authentication_2C00_-and-Security-Resources-.aspx and Scott Mitchell).

I've followed guides to setup membership database in SQL Express db at PC2 using aspnet_regsql.exe. (However: Scott Guthries guide is telling how to setup remote membership db in 2000 or 2005 SQL server. I've used SQL Express 2005) When developing at PC1, I can use ASP.NET Web Site Administration Tool to setup Users and Roles in this membership database. (Data enteres can be confirmed by browsing DB). My web.config file contains these lines to "point" to the remote database instead of default SQL Express database:

The Windows account "DIMENSION4550\ASPNET" has not been granted access to SQL. You need to add it as a login, and grant it access to the "usersandroles" database.

You where right. Instead of using Win account, I did this:

1. opened for SQL account authentication in SQL
2. created an new SQL account
3. gave this SQL account least previlegies (CONNECT, SELECT and EXECUTE) in the appropreiate database
4. Used User ID + password in my connection string in the .NET solution

Voala .. worked as it should, both from development pc and after deploying. Must encrypt my connection string in web.config, but that is another story.

Thx

Rgds Jan Inge