I'm trying to add a Login control (following along in the book) and when I go to the Web Site Administration Tool's Security Tab the following error message pops up:

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: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 5110 and the SqlException message is: The file "G:\INETPUB\tmpSite\DEV2\APP_DATA\ASPNETDB_TMP.MDF " is on a network path that is not supported for database files. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Creating the ASPNETDB_127e8a8c253b46ac895368529c502985 database...

When I click the button to choose the Data Store, I select Single Provider, and the only option available is AspNetSqlProvider. When I click on Test it says it Successfully established a connection to the database.

Is there a way I can fix this, or do I have to log in to the machine that's holding the site and attempt to create this from there, or do it the old way pre-2.0 way?

Your help is much appreciated.

I think you have to look into Memership Providers. A membership provider needs to be set up on the host server.

Hi,

I'm having the same problem. Were you able to resolve it?

As far as I remember I was unable to solve this (it was back in March when I was working on it and have since changed jobs). I recall just setting up the connections and doing it the old way, where they would type in their user name and password (making sure to mask the password) and I would query that against the database.

I don't recall their being any problems with that.