I am working with the ASP.net Personal Website Starter Kit. I am trying to add more data to the db so I can modify the website. I have been able to attach the Personal db to my instance of Sql Server Express.
I found out that the database is read only. I tried to run Sql Server as Administrator but that didn't fix this problem.
I am trying to avoid rewriting the db for fear of creating a probem somewhere else in the app. I am new to asp.net and I don't want to complicate things any more than needed at this point.
Is there a way I can make this not read-only? Do I have to rewrite the db?
Oh ueah, I just remembered that if I create a new "friend"account then I should be able to upload pictures to the db. Is this the best way to do this. Am I complicating this unneccesarily with the method mentioned above?
-thanks
Gaining competency by discovering my incompetencies.
If you are attaching the database to the instance then you might have to make sure that the Network Service account in Windows has Read/Write access to the app_data folder/files in your web site. To do this properly you need to do two things, make sure
that your SQL Server instance is not running and you don't have VS/Cassini Web Server running (the little icon in the system tray is active).
Member
557 Points
1281 Posts
Can the Personal db be written to some how?
Mar 22, 2008 11:34 AM|newbie2C#|LINK
I am working with the ASP.net Personal Website Starter Kit. I am trying to add more data to the db so I can modify the website. I have been able to attach the Personal db to my instance of Sql Server Express.
I found out that the database is read only. I tried to run Sql Server as Administrator but that didn't fix this problem.
I am trying to avoid rewriting the db for fear of creating a probem somewhere else in the app. I am new to asp.net and I don't want to complicate things any more than needed at this point.
Is there a way I can make this not read-only? Do I have to rewrite the db?
Oh ueah, I just remembered that if I create a new "friend"account then I should be able to upload pictures to the db. Is this the best way to do this. Am I complicating this unneccesarily with the method mentioned above?
-thanks
Star
7692 Points
1845 Posts
Re: Can the Personal db be written to some how?
Mar 22, 2008 12:45 PM|whighfield|LINK
If you are attaching the database to the instance then you might have to make sure that the Network Service account in Windows has Read/Write access to the app_data folder/files in your web site. To do this properly you need to do two things, make sure that your SQL Server instance is not running and you don't have VS/Cassini Web Server running (the little icon in the system tray is active).
Hope this helps
Member
23 Points
30 Posts
Re: Can the Personal db be written to some how?
Apr 12, 2008 10:44 AM|igotnushooz|LINK
You can easily edit the data and design in the full version of visual studio - you can download a trial. Just go the database explorer tab.