Associate
- Joined
- 5 Dec 2002
- Posts
- 141
I've got Windows Home Server installed and wanted to create an ASP website that I can host.
I've managed to get it up and running using WHIIST, SQL server express and Microsoft visual web developer, but am running into a few problems with permissions.
Mu only login for the WHS box is Administrator and all software installed via this account. The website is located at:
d:\shares\websites\club etc, and in the club folder I have the app_data folder which contains the two databases:
aspnetdb
club
I've managed to get everything working for access from the net, which involved sorting out the IIS_WPG user permissions which kept wanting to be inherited from the WHS system. As I say this login method works fine even if I restart the machine.
However, when I want to edit or test the site locally using WEB DEVELOPER it keeps saying that it cannot access one or both of the database because login SERVER\Administrator failed. I can get around this be adding/removing an administrator user from either the database files or its folder. Once something like the administrator permissions is changed it can be tested locally.
But, on reboot, I get the same problem again. All the folders for the website have a user group listed as SERVER\Administrators which has full permissions, which I would have thought would be good enough, But the databases still expect the Administrator user to be around somewhere.
I wouldn't mind but i can't pin down exactly what to give as this user because even if I get it working - on reboot i get the same problem and have to remove the user and add it somewhere else.
I'm hoping someone has come this problem or has suggestions.
Like I said I can get around it each time I need to make edits, but its a real pain the ****.
Please help!!!
I've managed to get it up and running using WHIIST, SQL server express and Microsoft visual web developer, but am running into a few problems with permissions.
Mu only login for the WHS box is Administrator and all software installed via this account. The website is located at:
d:\shares\websites\club etc, and in the club folder I have the app_data folder which contains the two databases:
aspnetdb
club
I've managed to get everything working for access from the net, which involved sorting out the IIS_WPG user permissions which kept wanting to be inherited from the WHS system. As I say this login method works fine even if I restart the machine.
However, when I want to edit or test the site locally using WEB DEVELOPER it keeps saying that it cannot access one or both of the database because login SERVER\Administrator failed. I can get around this be adding/removing an administrator user from either the database files or its folder. Once something like the administrator permissions is changed it can be tested locally.
But, on reboot, I get the same problem again. All the folders for the website have a user group listed as SERVER\Administrators which has full permissions, which I would have thought would be good enough, But the databases still expect the Administrator user to be around somewhere.
I wouldn't mind but i can't pin down exactly what to give as this user because even if I get it working - on reboot i get the same problem and have to remove the user and add it somewhere else.
I'm hoping someone has come this problem or has suggestions.
Like I said I can get around it each time I need to make edits, but its a real pain the ****.
Please help!!!