I am getting the following error when trying to setup security config for my .NET site, but can't get past this error. I have changed the connection string in my default website, given ASPNET user admin rights to the database, but still getting the error. What else might be going wrong?
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database."