So it's back to basics time.
ASP.NET requires database aspnetdb.mdb file in directory root\App_Data and it needs to contain the data & stored procedures created when reg_sql.exe is run to create the database.
option 1 create a database through hosting control panel called aspnetdb
Result: empty database (i.e. no tables or stored procedures) named aspnet_data.mdb created in the root\db folder (which cannot be moved)
Option 2 load database file created on my pc to App_Data directory
Result: the database is created where I want it with the name I want with the tables & procedures I want ...... but the database is NOT registered as a SQL database in either the summary list of what I have in my website nor int the database list (accessed through host control panel -> domain -> databases) & therefore I cannot set up a user & password for this database
So neither work - sorry if it is going over old ground but through speaking with people on microsoft forum it would seem that this is essential to getting the Login process running.
|