|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Problems accessing the ASPNETDB.MDF fileI 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 Have you tried the workaround described at
http://www.tjitjing.com/blog/2006/05/failed-to-update-database-xxxmdf.html? Show quoteHide quote "Fritjolf" <Morten.Jacob***@edb.com> wrote in message news:1154599520.556515.169320@h48g2000cwc.googlegroups.com... > 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 > 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: Show quoteHide quote > Have you tried the workaround described at > http://www.tjitjing.com/blog/2006/05/failed-to-update-database-xxxmdf.html? > > > > "Fritjolf" <Morten.Jacob***@edb.com> wrote in message > news:1154599520.556515.169320@h48g2000cwc.googlegroups.com... > > 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 > > Do you know which account your application pool is running under? Have you
tried granting modify permissions on the directory to that account? Show quoteHide quote "Fritjolf" <Morten.Jacob***@edb.com> wrote in message news:1154797613.196502.291770@h48g2000cwc.googlegroups.com... > 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.Jacob***@edb.com> wrote in message >> news:1154599520.556515.169320@h48g2000cwc.googlegroups.com... >> > 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 >> > > 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: Show quoteHide quote > 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.Jacob***@edb.com> wrote in message > news:1154797613.196502.291770@h48g2000cwc.googlegroups.com... > > 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.Jacob***@edb.com> wrote in message > >> news:1154599520.556515.169320@h48g2000cwc.googlegroups.com... > >> > 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 > >> > > > 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. Show quoteHide quote "Fritjolf" <Morten.Jacob***@edb.com> wrote in message news:1154976924.915531.263440@i3g2000cwc.googlegroups.com... >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.Jacob***@edb.com> wrote in message >> news:1154797613.196502.291770@h48g2000cwc.googlegroups.com... >> > 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.Jacob***@edb.com> wrote in message >> >> news:1154599520.556515.169320@h48g2000cwc.googlegroups.com... >> >> > 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 >> >> > >> > > 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: Show quoteHide quote > 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.Jacob***@edb.com> wrote in message > news:1154976924.915531.263440@i3g2000cwc.googlegroups.com... > >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.Jacob***@edb.com> wrote in message > >> news:1154797613.196502.291770@h48g2000cwc.googlegroups.com... > >> > 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.Jacob***@edb.com> wrote in message > >> >> news:1154599520.556515.169320@h48g2000cwc.googlegroups.com... > >> >> > 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 > >> >> > > >> > > > Hmm... What connection string are you using to attempt to connect to the
database? Show quoteHide quote "Fritjolf" <Morten.Jacob***@edb.com> wrote in message news:1155106009.357831.21350@b28g2000cwb.googlegroups.com... > 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.Jacob***@edb.com> wrote in message >> news:1154976924.915531.263440@i3g2000cwc.googlegroups.com... >> >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.Jacob***@edb.com> wrote in message >> >> news:1154797613.196502.291770@h48g2000cwc.googlegroups.com... >> >> > 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.Jacob***@edb.com> wrote in message >> >> >> news:1154599520.556515.169320@h48g2000cwc.googlegroups.com... >> >> >> > 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 >> >> >> > >> >> > >> > > 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> Thanx again. Fritjolf Nicole Calinoiu wrote: Show quoteHide quote > Hmm... What connection string are you using to attempt to connect to the > database? > > > "Fritjolf" <Morten.Jacob***@edb.com> wrote in message > news:1155106009.357831.21350@b28g2000cwb.googlegroups.com... > > 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.Jacob***@edb.com> wrote in message > >> news:1154976924.915531.263440@i3g2000cwc.googlegroups.com... > >> >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.Jacob***@edb.com> wrote in message > >> >> news:1154797613.196502.291770@h48g2000cwc.googlegroups.com... > >> >> > 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.Jacob***@edb.com> wrote in message > >> >> >> news:1154599520.556515.169320@h48g2000cwc.googlegroups.com... > >> >> >> > 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 > >> >> >> > > >> >> > > >> > > > 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: Show quoteHide quote > Hmm... What connection string are you using to attempt to connect to the > database? > > > "Fritjolf" <Morten.Jacob***@edb.com> wrote in message > news:1155106009.357831.21350@b28g2000cwb.googlegroups.com... > > 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.Jacob***@edb.com> wrote in message > >> news:1154976924.915531.263440@i3g2000cwc.googlegroups.com... > >> >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.Jacob***@edb.com> wrote in message > >> >> news:1154797613.196502.291770@h48g2000cwc.googlegroups.com... > >> >> > 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.Jacob***@edb.com> wrote in message > >> >> >> news:1154599520.556515.169320@h48g2000cwc.googlegroups.com... > >> >> >> > 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 > >> >> >> > > >> >> > > >> > > >
Have a NTAccount, need FileSystem permissions
Machine hops - Basic Authentication Another StrongNameIdentityPermission/LinkDemand question security warning in self signed certificate Assigning Strong Name to COM dlls Access Private Key File From X509 Certificate Can SslStream be set to ignore invalid certificates? Hangs indefinitely at first call to object of IWbemServices (In case of dll) WIN 2000 deploying executable to network to be ran in logon script RE: Required permissions cannot be acquired. |
|||||||||||||||||||||||