vs 2005 website administration tool error

Giganews Newsgroups
Subject: vs 2005 website administration tool error
Posted by:  djc (noo…@nowhere.com)
Date: Tue, 31 Oct 2006

vs2005, xp pro sp2, sql 2005 express

I know I can just edit the web.config manually to accomplish my task but I
wanted to try out this new feature. When trying to go to the 'security' page
I this error:

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 1802 and the SqlException message is: CREATE DATABASE failed. Some
file names listed could not be created. Check related errors. Cannot create
file 'C:\INETPUB\WWWROOT\APP_DATA\ASPNETDB_TMP.MDF' because it already
exists. Change the file path or the file name, and retry the operation.
Creating the ASPNETDB_<clipped> database...

note: i removed a long string of characters and replaced with <clipped>.
Also, I am logged in with admin priveleges so I assume its not a permission
issue as it suggests may be the cause.

1) I don't know where the server name is specified to know if its wrong
(just choose Website -> ASP.NET configuration)
2) don't know how to tell if the 'role manager' is enabled, or if I want it
to be
3) when I go to the 'choose data store button' as it suggests the
AspNetSQLProvider is the only option and the 'test' is successful. If I go
to the 'select a provider for each feature' then AspNetSqlMembershipProvider
and AspNetSqlRoleProvider are selected and both 'tests' succeed.
4) In general I was wondering: seeing that it is trying to create/access a
.mdf file I was wondering if the website administration tool feature works
on its own within VS or if an sql server installation is required? For
instance I did not see a database that uses this aspnetdb_tmp.mdf store file
when looking at my sql 2005 express server with the management studio?

I am new to the 2005 versions of VS and SQL (and not real experienced with
the older versions anyway) so I certianly intend on getting a good book and
reading it cover to cover. I was however hoping to at least get something up
and running now so I could begin playing with it... any input would be
greatly appreciated... any book recommendations are welcome to, focused on
VS and SQL 2005 Express, not neccesarily asp/vb/c#

Replies