Copying from XP to Server 2003 was originally the case, so I just installed VWD on the server, deleted the original PWSSK, then created the new one and get the DATABASE IS READ ONLY error. I also checked in Security settings in IIS, Windows Authentication
is chosen. Also, in the file structure, the .mdf files in the APP_DATA folder have 'WRITE' and 'SPECIAL PERMISSIONS' checked for the internet guest account.
in windows 2003 sql needs the "network service" account, in windows xp I believe it uses the "aspnet" account. The thing is though, is that once sql 2005 gets these permissions it becomes a pain to get them back... I found the best way is to create the app_data
folder before copying to 2003 and setting the permissions beforehand so it inherits them correctly
I removed the PWSSK that I created in XP and created a new one (in the same folder) with Visual Web Dev on the server itself. Would that still cause the problems in SQL Express?
backer
Member
45 Points
9 Posts
Re: 404 Error in Personal Site
May 27, 2005 03:10 PM|LINK
Copying from XP to Server 2003 was originally the case, so I just installed VWD on the server, deleted the original PWSSK, then created the new one and get the DATABASE IS READ ONLY error. I also checked in Security settings in IIS, Windows Authentication is chosen. Also, in the file structure, the .mdf files in the APP_DATA folder have 'WRITE' and 'SPECIAL PERMISSIONS' checked for the internet guest account.
Any other suggestions?
Rafa
Participant
1236 Points
250 Posts
Re: 404 Error in Personal Site
May 27, 2005 06:37 PM|LINK
backer
Member
45 Points
9 Posts
Re: 404 Error in Personal Site
May 27, 2005 07:44 PM|LINK
-Ben
backer
Member
45 Points
9 Posts
Re: 404 Error in Personal Site
May 27, 2005 08:38 PM|LINK
Rafa
Participant
1236 Points
250 Posts
Re: 404 Error in Personal Site
May 27, 2005 08:46 PM|LINK
in windows 2003 sql needs the "network service" account, in windows xp I believe it uses the "aspnet" account. The thing is though, is that once sql 2005 gets these permissions it becomes a pain to get them back... I found the best way is to create the app_data folder before copying to 2003 and setting the permissions beforehand so it inherits them correctly
backer
Member
45 Points
9 Posts
Re: 404 Error in Personal Site
May 31, 2005 03:38 PM|LINK
I removed the PWSSK that I created in XP and created a new one (in the same folder) with Visual Web Dev on the server itself. Would that still cause the problems in SQL Express?
Rafa
Participant
1236 Points
250 Posts
Re: 404 Error in Personal Site
May 31, 2005 03:49 PM|LINK