Unable to connect to datasource through Web Site Administration tool

Oct 22, 2012 at 8:50 PM

Hi I have been following the tutorial up to page 83 of the pdf document but when i try to create an admin user with the ASP.NET website administration tool. I get the follwoing response on clicking the security tab.

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.

I am using sqlcompact 4.0 as datastore.