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


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.


vasu said…
If the users are created ( signed up) using the front end dynamically, how can we add those users to webapplication policy, dynamically?

Popular posts from this blog

ASP.NET website "Cannot read configuration file due to insufficient permissions" in IIS 7 and Windows Server 2008

Error occurred in deployment step 'Install app for SharePoint': The System Account cannot perform this action.

None of the selected features can be installed or upgraded. Setup cannot proceed since no