Re: vs 2005 website administration tool error

Giganews Newsgroups
Subject: Re: vs 2005 website administration tool error
Posted by:  djc (noo…
Date: Wed, 1 Nov 2006

to anyone interested.

I closed the website admin tool, then I just deleted the mdf file (and the
associated transaction log file) it was accessing, reopened the website
admin tool, went to the secuirty tab, it took a moment to load (it recreated
the db files) no error but also the right content did not show. At that
moment *instead* of hitting refresh or clicking the security tab again
(which I think I may have done the first time) I closed and reopened the
website admin tool again and then all worked fine. Security tab loaded with
no issue. I don't know if that last close and reopen was necessary but thats
what I did and problem solved.

"djc" <noo…> wrote in message
> 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#



In response to

vs 2005 website administration tool error posted by djc on Tue, 31 Oct 2006