Re: Problems accessing the ASPNETDB.MDF file



Hi again.

It's:
<connectionStrings>
<add name="ConnectionString" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename='D:\Utvikling\webroot\Test\MasterContentPlus\App_Data\WebBase.mdf';Initial
Catalog='WebBase';Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

But keep in mind that this is my db file.
The ASPNETDB.MDF file, I have no connection string to in my config
file. It's defined in the default security stuff, I think...

Thanx again.

Fritjolf

Nicole Calinoiu wrote:
Hmm... What connection string are you using to attempt to connect to the
database?


"Fritjolf" <Morten.Jacobsen@xxxxxxx> wrote in message
news:1155106009.357831.21350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi and thanx again.

I've never even seen the application pool. Guess you now by now I'm
quite new to this. *hehe*

The user is: Network Service. This user has all rights to the app_data
directory, but still doesn't work...

Fritjolf

Nicole Calinoiu wrote:
In IIS Manager, display the properties dialog for the application pool to
which your application belongs. The app pool context account is shown on
the Identity tab.

If you can't use IIS Manager on the server, you can access the account
name
by reading the value of WindowsIdentity.GetCurrent().Name from within
your
application's code. However, given that you were presumably able to
modify
file permissions on your application's directory, it seems likely that
you
would be able to verify the app pool identity account via IIS Manager as
well.



"Fritjolf" <Morten.Jacobsen@xxxxxxx> wrote in message
news:1154976924.915531.263440@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I would guess it was running under NetworkService or aspnet account,
but I can't say for sure. How do I check that?

Fritjolf

Nicole Calinoiu wrote:
Do you know which account your application pool is running under?
Have
you
tried granting modify permissions on the directory to that account?


"Fritjolf" <Morten.Jacobsen@xxxxxxx> wrote in message
news:1154797613.196502.291770@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanx for your reply.

I've tested this for an hours in all possible ways. Still readonly,
still the same error messages and still no closer to my goal.

Any other tips?

Thanx in advance,
Fritjolf


Nicole Calinoiu wrote:
Have you tried the workaround described at
http://www.tjitjing.com/blog/2006/05/failed-to-update-database-xxxmdf.html?



"Fritjolf" <Morten.Jacobsen@xxxxxxx> wrote in message
news:1154599520.556515.169320@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi.

I have serious problems trying to authenticate users with the
build
in
functionality in asp.net 2.0. In the process of trying to debug
this
problem I've made a very simple webtest application.

Hardware and software info:
- I'm using VS2005 and I'm developing on XP
- I'm using a local DB file for some data (placed in the app_data
folder)
- After running asp.net configuration and adding a few users the
ASPNETDB.MDF file is generated.
- The form contains a grid view, just viewing a table named
Person.
This data is viewed without any problems.
- I added a logon control. I can login when I run it at my XP
development machine, but after deployment I can't log in anymore.
I
just get the default message that my login attempt was not
successful.
I deploy it to a Windows 2003 server standard edition.
- I added a signup wizard. When I try and run this I get the
error:

"Failed to update database
"E:\WEBROOT\DBDEPLOYTEST1\APP_DATA\ASPNETDB.MDF" because the
database
is read-only. " and
"Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and
location
of
the exception can be identified using the exception stack trace
below.
"

I see no reason for pasting in the stack trace.

- To debug even more I added a grid view based on the table:
aspnet_Users located in the problem file: ASPNETDB.MDF. This
actually
shows me that the users I created on my development machine
exists,
but
I can NOT log in with these users.

I've tried adding all rights to aspnet and the iusr_ user on the
app_data folder. Did nothing...

I can't figure out where the problem is. I would REALLY
appreciate
some
help.

Thanx,

Fritjolf





.



Relevant Pages

  • Re: Workgroup Manager: screwed up home directories
    ... It sounds like you configured your server as an Open Directory Master. ... I can login on the one account that was created locally (aka: ... Config" manual with 90% of it related to how to disable something on the ... very little about actual security. ...
    (comp.sys.mac.system)
  • Re: Still Cannot Connect From Other PCs...
    ... the laptop is NOT in the domain, ... configured as a USER account. ... >> (anyone who saw an earlier post, my partner brought me our MSDN MSSQL Server ... >> Component Config... ...
    (microsoft.public.sqlserver.setup)
  • RE: Strategic approach to recreating an existing user
    ... for her and transfer existing files over (excluding the KDE config ... When I create a new account to test these issues in, ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: Help with connection string
    ... The connection string looks correct. ... Is that E drive accessible to the user account under whose context the ... IIS process is running (if your website has Anonymous enabled, ... connect to an unpassworded Access 2007 database for use in a small ...
    (microsoft.public.inetserver.asp.db)
  • Re: dynamic connection string
    ... Aside from the use of the sa account, ... If i replace the variable being supplied to Data Source with a hard ... coded server name, the connection string does work. ...
    (microsoft.public.inetserver.asp.db)

Quantcast