Adding Users in MOSS 2007 after Forms Authentication is enabled

How to add Users to MOSS 2007 after Forms Authentication is enabled

After enabling forms authentication in your MOSS 2007 site you can add user from your SQL database as a Administrator alone. For other users to access your site you need to do some small change in your machine.config file located at

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG

By default your machine.config file as the following connection string which is pointing to SQL express database.

<connectionStrings> <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=DataDirectoryaspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /> </connectionStrings>

change this connection string to your SQL database connection string which you already using for your forms authentication your MOSS 2007 site.

for example i'm using

<connectionStrings> <clear /> <add name="LocalSqlServer" connectionString="Server=SERVERNAME;Integrated Security=SSPI;Database=aspnetdb;" providerName="System.Data.SqlClient" /> </connectionStrings>

Now this will connect to your profile database which is used for Forms authentication in MOSS 2007.

And now to over come the following error

Go back to site Error: Access Denied
Current User You are currently signed in as:

Open your central administrator of your MOSS 2007 and select the Application Management tab. Under the Application Security select Policy for Web application after selecting just click on the add user button and proceed through the navigation and Choose Users you want to add and set rights for them in the process.

Another way is login with your site administrator. select Site Actions, then Site Settings, then People And Groups. Select the New button to add a user to the site. This will also works.