This is my first ASP.NET 2.0 project and I think this may be a simple problem to solve but I don't know what to do.
My hosting service (GoDaddy) doesn't allow remote access to their DB and I want to use the Web Administration Tool (WSAT) to manage my site. I published the WSAT found in WINDOWS\MICROSOFT.NET\FRAMEWORK\v2.0.50727 to my local web site, MySite, and to my
remote site, MySite.com, and put a link in Admin/Albums.aspx:
string myPath = Request.PhysicalApplicationPath;
string redi="http://localhost/WebAdmin/default.aspx?&applicationPhysicalPath="+myPath+"&applicationUrl=/<MySite>";//where
<MySite> is either MySite or MySite.com
Response.Redirect(redi);
For the local site this works great. But for the remote site though WSAT launches OK, the Security tab has the error:
Server cannot access application directory 'd:\hosting\MyDataBase\'. The directory does not exist or is not accessible because of security settings.
MyDataBase is the SQL server (SQL 2005) I set up on GoDaddy using the connection string provided by GoDaddy and implemented with the scripts from my local ASPNETDB.MDF and Personal.mdf as suggested by ScottGu in his blog. MySite.com works fine - I can login
as administrator and manage the alblums, etc. Users can login but because of the above error, I can't authorize them.
To manage MyDataBase on GoDaddy, I need to supply a DBUserName and a DBPassword. Is this what I'm missing for WSAT? How come the users can put their info into MyDataBase but WSAT can't access it? BTW, the provider tab in WSAT shows the provider to be
AspNetSqlProvider. (I'm using ASP.NET 2.0 in VS2005 standard edition writing in C#. GoDaddy uses IIS6 and FrontPage extensions. )
If anybody knows what I should do here, I'd sure appreciate hearing from you. Many thanks.
As well I made a registration and user management module for the stock PWSK (see my link in my sig). There are others but these are the ones I remember.
Please mark the most helpful post(s) as Answer Blog | I need more space:DropBox Referral
Thank you very much for your reply.What I've been trying to do is get my own copy of WSAT (MyWebAdmin) that I have published to my domain on GoDaddy working properly. I thought the only support I would need from GoDaddy to do this would be there own IIS.
This stategy works fine on my local machine using MyWebAdmin under MyWebSite and my local IIS. But on GoDaddy I get errors like
: "It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application
level." (Of course, I have identified MyWebAdmin as an application to GoDaddy's IIS using different permission settings.) There seems to be some kind of conflict between the web.config file for MyWebSite.com and the one for MyWebAdmin. Even
when I get beyond this, I start getting errors finding MyWebAdmin resources using paths that begin "~/". I'm way over my head here and am about to give up. But I still don't understand why such a useful and well written tool can't be made deployable. It's
an obvious need: you should be able to administer your website users over the internet when you're travelling. You can't always carry a development environment around with you.
So, I appreciate your references. As you say, there are a number available and I will try to find one that meets my needs.
Nobody seems to know how to help me get my own copy of WSAT on GoDaddy configured to work securely and properly. I have given up on that approach and have implemented the C# package developed by Peter Kellner which provides for Membership Editing using IIS.
It was easy to install and works fine on GoDaddy. It isn't as pretty as WSAT but it has all the important functionality. (It doesn't include access rule definitions but that's easy to do directly in the web.config files.) You can find Peter Kellner's package
at:
http://peterkellner.net/2006/01/09/microsoft-aspnet-20-memberrole-management-with-iis/
RogerHill
Member
5 Points
28 Posts
Problem with Web Site Administration Tool on host using SQL
Dec 22, 2008 06:39 PM|LINK
Hi,
This is my first ASP.NET 2.0 project and I think this may be a simple problem to solve but I don't know what to do.
My hosting service (GoDaddy) doesn't allow remote access to their DB and I want to use the Web Administration Tool (WSAT) to manage my site. I published the WSAT found in WINDOWS\MICROSOFT.NET\FRAMEWORK\v2.0.50727 to my local web site, MySite, and to my remote site, MySite.com, and put a link in Admin/Albums.aspx:
string myPath = Request.PhysicalApplicationPath; string redi="http://localhost/WebAdmin/default.aspx?&applicationPhysicalPath="+myPath+"&applicationUrl=/<MySite>";//where <MySite> is either MySite or MySite.comResponse.Redirect(redi);
For the local site this works great. But for the remote site though WSAT launches OK, the Security tab has the error:
Server cannot access application directory 'd:\hosting\MyDataBase\'. The directory does not exist or is not accessible because of security settings.
MyDataBase is the SQL server (SQL 2005) I set up on GoDaddy using the connection string provided by GoDaddy and implemented with the scripts from my local ASPNETDB.MDF and Personal.mdf as suggested by ScottGu in his blog. MySite.com works fine - I can login as administrator and manage the alblums, etc. Users can login but because of the above error, I can't authorize them.
To manage MyDataBase on GoDaddy, I need to supply a DBUserName and a DBPassword. Is this what I'm missing for WSAT? How come the users can put their info into MyDataBase but WSAT can't access it? BTW, the provider tab in WSAT shows the provider to be AspNetSqlProvider. (I'm using ASP.NET 2.0 in VS2005 standard edition writing in C#. GoDaddy uses IIS6 and FrontPage extensions. )
If anybody knows what I should do here, I'd sure appreciate hearing from you. Many thanks.
Roger
whighfield
Star
11721 Points
1859 Posts
Re: Problem with Web Site Administration Tool on host using SQL
Jan 04, 2009 01:57 AM|LINK
GoDaddy does not support WSAT nor do any other hosting providers that I know of.
If you need to have access to your users you will need to either code a user admin section in your web site or download a third party one.
Sue of edream.org made one I believe http://www.edream.org/BlogArticle.aspx?RecordID=115
Jeremy Wadsworth has a complete extended PWSK with a user admin section http://jeremywadsworth.com/Default.aspx?blogcategory=PWS%20Code
As well I made a registration and user management module for the stock PWSK (see my link in my sig). There are others but these are the ones I remember.
Blog | I need more space:DropBox Referral
RogerHill
Member
5 Points
28 Posts
Re: Problem with Web Site Administration Tool on host using SQL
Jan 04, 2009 05:12 PM|LINK
Hello William,
Thank you very much for your reply.What I've been trying to do is get my own copy of WSAT (MyWebAdmin) that I have published to my domain on GoDaddy working properly. I thought the only support I would need from GoDaddy to do this would be there own IIS. This stategy works fine on my local machine using MyWebAdmin under MyWebSite and my local IIS. But on GoDaddy I get errors like : "It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level." (Of course, I have identified MyWebAdmin as an application to GoDaddy's IIS using different permission settings.) There seems to be some kind of conflict between the web.config file for MyWebSite.com and the one for MyWebAdmin. Even when I get beyond this, I start getting errors finding MyWebAdmin resources using paths that begin "~/". I'm way over my head here and am about to give up. But I still don't understand why such a useful and well written tool can't be made deployable. It's an obvious need: you should be able to administer your website users over the internet when you're travelling. You can't always carry a development environment around with you.
So, I appreciate your references. As you say, there are a number available and I will try to find one that meets my needs.
Regards,
Roger
RogerHill
Member
5 Points
28 Posts
Re: Problem with Web Site Administration Tool on host using SQL
Jan 04, 2009 08:18 PM|LINK
Hello William,
I'd like to try your PWSK modules but the download links on http://thefrozencoder.ca/Page/Personal-Web-Starter-Kit-Modules.aspx
all give 404 errors. Am I doing something wrong?
Thanks,
Roger
RogerHill
Member
5 Points
28 Posts
Re: Problem with Web Site Administration Tool on host using SQL
Jan 07, 2009 05:35 PM|LINK
Update.
Nobody seems to know how to help me get my own copy of WSAT on GoDaddy configured to work securely and properly. I have given up on that approach and have implemented the C# package developed by Peter Kellner which provides for Membership Editing using IIS. It was easy to install and works fine on GoDaddy. It isn't as pretty as WSAT but it has all the important functionality. (It doesn't include access rule definitions but that's easy to do directly in the web.config files.) You can find Peter Kellner's package at: http://peterkellner.net/2006/01/09/microsoft-aspnet-20-memberrole-management-with-iis/
whighfield
Star
11721 Points
1859 Posts
Re: Problem with Web Site Administration Tool on host using SQL
Jan 09, 2009 04:00 AM|LINK
This has been fixed
Blog | I need more space:DropBox Referral
tjedwin
Member
12 Points
14 Posts
Re: Problem with Web Site Administration Tool on host using SQL
Jan 22, 2009 07:21 PM|LINK
Hi William,
I also used GoDaddy.com as my hosting company. I spent a lot time try to get my PSK web site up and running.
Can you share with me on Web Config file on "ConnectionStrings" setting?
What is the correct connection strings should I change/modify in order to make my web site up and running.
Also, How to configure the Personal and ASPNETDB in SQL Server 2005 in GoDaddy.com.
Note: I compiled and run my web site on my local machine using Visual Studio 2005 and SQL 2005.
Thanks,
Edwin
GoDaddy ASP.NET2.0