I'm not suggesting that this is the 'final answer'. I'm still working to try and make it work with the ConnectionString (instead of the surgical bypass written above), but I've had no luck so far, even though GoDaddy supplies code to write in that I would
have thought should have worked easily.
I'm looking for other GoDaddy newbies (ASP.NET / VWD 2005 EE / SQL Server) to collaborate with as we work on these sort of things.
Trying to get the the small business starter kit running. On godaddy with ASP.NET 1.1 i get the need to turn the customError="Off" message but my web.config says it is "Off" (capital Oh). With ASP.NET 2.0 i get Server unavailable. Got a response from godaddy.com
and they said that the site is crashing the ASP.NEt application pool as it is exceeding the allocated resources per site. This is ridiculous as the site itself to include images is 700 kilobytes!!.. Less than a damn floppy and they can allocate resources for
that?..... sorry I am shopping for another vendor at this point as I got numerous servers to include an ARCHAIC PII400 with 512 MB of ram and it works fast on that!!
Without knowing what you've done so far it's kind of hard to pinpoint the problem, but I will try to help.
1-Did you make sure site would build on your local server before copying any files?
2- Did you create all the DB tables and Procedures?
3-Did you upload the data? (I'm assuming you're using VisualStudio/VisualWebDeveloper)
I was going nuts trying to get my ClubSite going and ZOwen was great and clued me in to a wonderful tool for creating the scripts needed to create the tables, procedures and write the data. All the problems I was having stemed
from DB issues. If you don't already have it - go get it- SQL Server Hosting Toolkithttp://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost
Once you've made sure you're site is working on your local host, create a brand new (MS SQL) DB. Ensure that you select the 2.0ASP shema.
Then use the script to run against YOUR working .mdf file. Create 2 separate scripts - 1 for the tables&procedures and 1 for the data (try not to script the data in the DB for photos - will bring everything to a standstill).
Then you have to go thru the entire tables/procedures script and move any GOTO statements up to the row before (this is very important).
The copy and paste that entire edited script up to the hosted database using the tool provided. You should not receive any errors when that tool runs. Then copy and paste script for the data into the tool. Then copy all your asp files up to the
host. Make sure you have already added yourself as an administrator before the upload - so that you don't have to go thru any additional steps to add yourself or your roles on the hosted db.
Good point on #1. I too was getting mighty disappointed trying to get the connection string working with Godaddy.
They finally gave me this little script that proved my connection string was correct:
mysqltest.aspx
<%@ Import Namespace="System.Data.SqlClient" %>
<%
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString ="Server=whsql-v09.prod.mesa1.secureserver.net;uid=dbasolutions;pwd=*****;database=DB_87972;"
try
oSQLConn.Open()
catch dag as exception
response.write(dag.message)
End try
Response.write("Connection Open!")
%>
When this worked, I finally realized the program was not being recompiled on Godaddy. After recompiling locally, I was able to get it to work. Is there a setting in the config file to allow recompile on the server?
(btw: I am moving away from Godaddy since they are not asp.net friendly.)
I really appreciate the effort you have gone to so far, but I have not had success yet with your instructions. Here is what I have done to date:
Using Visual Studio 2005, SQL Express 2005 locally
1: Built site locally and tested all aspects working fine. Added myself as administrator at this point. I did not modify the content of the site in any way.
2: I am not sure what you mean by "Did you create all the DB tables and Procedures?"
3: Downloaded and ran the SQL Server Database Publishing Wizard and ran this through VS 2005 against my local copy of "Club.mdf"
Settings here were:
Drop existing objects in script = True
Schema qualify = True
Script for target database = SQL Server 2000 (the SQL Database on GoDaddy says it is version 2000)
Types of data to publish = first run through I chose Schema only, and the second time (separate target file) Data only
I can provide the output of these files if it helps. One thing I noted is that there are no GOTO statements in either of these scripts. Plenty of GO statements though.
4: Created a new SQL DB on my GoDaddy account. ASP 2.0 enabled.
5: Copied and pasted the contents of the schema script file into the GoDaddy SQL Server Web Admin tool. I got no errors with either script.
6: Edited the ConnectionStrings section of the web.config file to read:
7: Uploaded all files to GoDaddy. Every page gives me "an application error has occurred".
So far I have got 2 support replies from GoDaddy. #1: "Rename Default.aspx to default.aspx" and #2:
"Unfortunately, we will be unable to assist you as this is a scripting error" which is nice since GoDaddy suggests this Clubsite, and Microsoft lists GoDaddy as the #1 host to use for this Clubsite.
If anyone has had success with this Clubsite on GoDaddy, I would love to hear from you.
At this point in time - I am quite amazed to say - everything I have checked so far is working except that I cannot login using the administrator role which I created locally earlier.
Here is my working web.cong. Here are the steps I followed on Go Daddy
1. First, get a copy of the Go Daddy Walkthrough post on this site
2. Create your DB on Go Daddy using their SQL tool. Note the user name and password you use to create teh DB
3. Using the create scripts in the CSK, create your table, sp's, etc. changing the dbo ownership in the scripts to the ID you used to create your DB on Go Daddy.
4. Use the Go Daddy Walk Through to add your Admin ID
5. Modify your web.config to use the proper Go Daddy server, etc.
6. Post your site. I used VWD and just FTP'd it up.
Here is my working web.config.
<?xml
version="1.0"?>
remove
name="AspNetXmlSiteMapProvider"/>
<add
name="AspNetXmlSiteMapProvider"
description="SiteMap provider which reads in .sitemap XML files."
type="System.Web.XmlSiteMapProvider"
securityTrimmingEnabled="true"
siteMapFile="Web.sitemap"/>
I"m having trouble launching my site locally as well as accesing the asp.net applications. here's a copy of my web.config. Does godaddy.com allow remote access or not?
No GoDaddy doesn't allow remote access. To run your site locally you have to change your connection string to connect to your local DB. To look at/ connect to your live DB you have to use their DB manager tool. I wish they would chage to allow remote
access, it would be a lot easier but also more chance of the DB getting hacked.
ldechent
Contributor
6326 Points
1577 Posts
Re: GoDaddy
Jan 06, 2007 11:15 PM|LINK
I went to the part in the aspx page that has
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
and changed it to
ConnectionString="Server=whsql-v05.prod.mesa1.secureserver.net;uid=myusername;pwd=******;database=DB_123456"
I'm not suggesting that this is the 'final answer'. I'm still working to try and make it work with the ConnectionString (instead of the surgical bypass written above), but I've had no luck so far, even though GoDaddy supplies code to write in that I would have thought should have worked easily.
I'm looking for other GoDaddy newbies (ASP.NET / VWD 2005 EE / SQL Server) to collaborate with as we work on these sort of things.
-Larry
figgie
Member
34 Points
24 Posts
Re: GoDaddy
Mar 16, 2007 03:55 PM|LINK
posting experience here with godaddy.
Trying to get the the small business starter kit running. On godaddy with ASP.NET 1.1 i get the need to turn the customError="Off" message but my web.config says it is "Off" (capital Oh). With ASP.NET 2.0 i get Server unavailable. Got a response from godaddy.com and they said that the site is crashing the ASP.NEt application pool as it is exceeding the allocated resources per site. This is ridiculous as the site itself to include images is 700 kilobytes!!.. Less than a damn floppy and they can allocate resources for that?..... sorry I am shopping for another vendor at this point as I got numerous servers to include an ARCHAIC PII400 with 512 MB of ram and it works fast on that!!
<-- not happy with godaddy at this point.
MarValUS
Member
74 Points
29 Posts
Re: GoDaddy
Mar 16, 2007 11:51 PM|LINK
Without knowing what you've done so far it's kind of hard to pinpoint the problem, but I will try to help.
1-Did you make sure site would build on your local server before copying any files? 2- Did you create all the DB tables and Procedures? 3-Did you upload the data? (I'm assuming you're using VisualStudio/VisualWebDeveloper)
I was going nuts trying to get my ClubSite going and ZOwen was great and clued me in to a wonderful tool for creating the scripts needed to create the tables, procedures and write the data. All the problems I was having stemed from DB issues. If you don't already have it - go get it- SQL Server Hosting Toolkit http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost
Once you've made sure you're site is working on your local host, create a brand new (MS SQL) DB. Ensure that you select the 2.0ASP shema.
Then use the script to run against YOUR working .mdf file. Create 2 separate scripts - 1 for the tables&procedures and 1 for the data (try not to script the data in the DB for photos - will bring everything to a standstill). Then you have to go thru the entire tables/procedures script and move any GOTO statements up to the row before (this is very important). The copy and paste that entire edited script up to the hosted database using the tool provided. You should not receive any errors when that tool runs. Then copy and paste script for the data into the tool. Then copy all your asp files up to the host. Make sure you have already added yourself as an administrator before the upload - so that you don't have to go thru any additional steps to add yourself or your roles on the hosted db.
Good luck.
http://MarValus-Domains-Hosting.com
ClubSite: http://DisciplesOnDirt.com
I'll be working on the small business starter kit myself in a couple weeks - so if you're still stuck I will try to help you more.
Small Business Starter Kit Club Starter Kit GoDaddy
bswanson
Member
34 Points
28 Posts
Re: GoDaddy
Mar 22, 2007 11:00 PM|LINK
Good point on #1. I too was getting mighty disappointed trying to get the connection string working with Godaddy.
They finally gave me this little script that proved my connection string was correct:
mysqltest.aspx
<%@ Import Namespace="System.Data.SqlClient" %>
<%
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString ="Server=whsql-v09.prod.mesa1.secureserver.net;uid=dbasolutions;pwd=*****;database=DB_87972;"
try
oSQLConn.Open()
catch dag as exception
response.write(dag.message)
End try
Response.write("Connection Open!")
%>
When this worked, I finally realized the program was not being recompiled on Godaddy. After recompiling locally, I was able to get it to work. Is there a setting in the config file to allow recompile on the server?
(btw: I am moving away from Godaddy since they are not asp.net friendly.)
Bill
Pegasus82
Member
6 Points
3 Posts
Re: GoDaddy
Mar 26, 2007 03:08 PM|LINK
Hi MarValUS,
I really appreciate the effort you have gone to so far, but I have not had success yet with your instructions. Here is what I have done to date:
Using Visual Studio 2005, SQL Express 2005 locally
1: Built site locally and tested all aspects working fine. Added myself as administrator at this point. I did not modify the content of the site in any way.
2: I am not sure what you mean by "Did you create all the DB tables and Procedures?"
3: Downloaded and ran the SQL Server Database Publishing Wizard and ran this through VS 2005 against my local copy of "Club.mdf"
I can provide the output of these files if it helps. One thing I noted is that there are no GOTO statements in either of these scripts. Plenty of GO statements though.
4: Created a new SQL DB on my GoDaddy account. ASP 2.0 enabled.
5: Copied and pasted the contents of the schema script file into the GoDaddy SQL Server Web Admin tool. I got no errors with either script.
6: Edited the ConnectionStrings section of the web.config file to read:
<connectionStrings>
<add name="ClubSiteDB" connectionString="
Server=p3swhsql-v02.shr.phx3.secureserver.net;
Database=DB_1005155;
User ID=****;
Password=****;
Trusted_Connection=False"
providerName="System.Data.SqlClient" />
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="
Server=p3swhsql-v02.shr.phx3.secureserver.net;
Database=DB_1005155;
User ID=****;
Password=****;
Trusted_Connection=False"
providerName="System.Data.SqlClient" />
</connectionStrings>
7: Uploaded all files to GoDaddy. Every page gives me "an application error has occurred".
So far I have got 2 support replies from GoDaddy. #1: "Rename Default.aspx to default.aspx" and #2: "Unfortunately, we will be unable to assist you as this is a scripting error" which is nice since GoDaddy suggests this Clubsite, and Microsoft lists GoDaddy as the #1 host to use for this Clubsite.
If anyone has had success with this Clubsite on GoDaddy, I would love to hear from you.
club.mdf web.config Hosting ClubSite GoDaddy
Pegasus82
Member
6 Points
3 Posts
Re: GoDaddy
Mar 26, 2007 03:36 PM|LINK
I am going to answer myself here [;)]
What I had forgotten to do was to Rebuild the website locally, with the web.config file modified to suit the GoDaddy database information ie:
and then upload the files to GoDaddy.
At this point in time - I am quite amazed to say - everything I have checked so far is working except that I cannot login using the administrator role which I created locally earlier.
ckeezer
Member
153 Points
213 Posts
Re: GoDaddy
May 04, 2007 02:00 PM|LINK
After the rebuild do you have to do anything other than ftp the files to Godaddy?
Thank,
CK
Chuck
My Blog
If this post helped solve your issue, Mark it as the Answer
rhhanson63
Member
354 Points
76 Posts
Re: GoDaddy
Jun 16, 2007 03:47 AM|LINK
Here is my working web.cong. Here are the steps I followed on Go Daddy
1. First, get a copy of the Go Daddy Walkthrough post on this site
Here is my working web.config.2. Create your DB on Go Daddy using their SQL tool. Note the user name and password you use to create teh DB
3. Using the create scripts in the CSK, create your table, sp's, etc. changing the dbo ownership in the scripts to the ID you used to create your DB on Go Daddy.
4. Use the Go Daddy Walk Through to add your Admin ID
5. Modify your web.config to use the proper Go Daddy server, etc.
6. Post your site. I used VWD and just FTP'd it up.
<?xml version="1.0"?>
<
configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <location path="events_edit.aspx"><
system.web> <authorization><
allow roles="Administrators"/> <deny users="*"/></
authorization> </system.web></
location> <location path="locations_edit.aspx"><
system.web> <authorization><
allow roles="Administrators"/> <deny users="*"/></
authorization> </system.web></
location> <location path="news_edit.aspx"><
system.web> <authorization><
allow roles="Administrators"/> <deny users="*"/></
authorization> </system.web></
location> <location path="photoalbum_new.aspx"><
system.web> <authorization><
allow roles="Administrators"/> <deny users="*"/></
authorization> </system.web></
location> <location path="member_list.aspx"><
system.web> <authorization><
deny users="?"/> </authorization></
system.web> </location><
location path="member_details.aspx"> <system.web><
authorization> <deny users="?"/></
authorization> </system.web></
location> <!--<location path="Files.aspx"><system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location> --><
location path="forum_manage.aspx"> <system.web><
authorization> <allow roles="Administrators"/><
deny users="*"/> </authorization></
system.web> </location><
location path="forum_editpost.aspx"> <system.web><
authorization> <allow roles="Administrators"/><
deny users="*"/> </authorization></
system.web> </location><
location path="forum_addpost.aspx"> <system.web><
authorization> <deny users="?"/></
authorization> </system.web></
location> <location path="Admin.aspx"><
system.web> <authorization><
allow roles="Administrators"/> <deny users="*"/></
authorization> </system.web></
location> <location path="Poll_Manage.aspx"><
system.web> <authorization><
allow roles="Administrators"/> <deny users="*"/></
authorization> </system.web></
location> <location path="Poll_Answers.aspx"><
system.web> <authorization><
allow roles="Administrators"/> <deny users="*"/></
authorization> </system.web></
location> <location path="Poll_AddReaction.aspx"><
system.web> <authorization><
deny users="?"/> </authorization></
system.web> </location><
connectionStrings> <add name="ClubSiteDB" connectionString="Data Source=XXXXX-XXX.XXXX.XXXXX.XXXXXXXXXXXX.XXX;Initial Catalog=XX_XXXXXX;User ID=XXXXX;Password='XXXXXX';Trusted_Connection=False" providerName="System.Data.SqlClient"/><
remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=XXXX-vXXX.XXXX.XXXXX.XXXXXXXXXXXX.XXX;Initial Catalog=XX_XXXXX;User ID=XXXXX;Password='XXXXXXX';Trusted_Connection=False" providerName="System.Data.SqlClient"/></
connectionStrings> <system.web><
roleManager enabled="true"/> <authentication mode="Forms"/><
compilation debug="true" strict="true"> <assemblies><
add assembly="System.Xml, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> <add assembly="System.Messaging, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/><
add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> </assemblies></
compilation> <membership defaultProvider="AspNetSqlMembershipProvider"/><
siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true"> <providers><
remove name="AspNetXmlSiteMapProvider"/> <add name="AspNetXmlSiteMapProvider" description="SiteMap provider which reads in .sitemap XML files." type="System.Web.XmlSiteMapProvider" securityTrimmingEnabled="true" siteMapFile="Web.sitemap"/></
providers> </siteMap><
customErrors mode="Off" defaultRedirect="ErrorPage.htm"/> <globalization requestEncoding="utf-8" responseEncoding="utf-8"/></
system.web> <system.net><
defaultProxy> <proxy usesystemdefault="False" proxyaddress="http://wc-v01.inet.mesa1.gdg:3128" bypassonlocal="False" /></
defaultProxy> </system.net><
system.net> <mailSettings><
smtp deliveryMethod="network" from=XXXXXXXXX@XXXXXXXXXX.XXX><
network host="relay-hosting.secureserver.net" port="25" defaultCredentials="true"/>
</smtp></
mailSettings> </system.net><
appSettings> <add key="BccLimit" value="10" /></
appSettings></
configuration>jay0555
Member
32 Points
27 Posts
Re: GoDaddy
Jun 25, 2007 12:55 AM|LINK
I"m having trouble launching my site locally as well as accesing the asp.net applications. here's a copy of my web.config. Does godaddy.com allow remote access or not?
thanks,
jay0555
<connectionStrings><
add name="ClubSiteDB" providerName="System.Data.SqlClient" connectionString="server=whsql-v21.prod.mesa1.secureserver.net;database=DB_146614;
uid=xxxxxx;
pwd=xxxxxx"/><
remove name="LocalSqlServer"/><
add name="LocalSqlServer" providerName="System.Data.SqlClient" connectionString="server=whsql-v21.prod.mesa1.secureserver.net;database=DB_146614;
uid=xxxxx;
pwd=xxxxx"/></
connectionStrings>MarValUS
Member
74 Points
29 Posts
Re: GoDaddy
Jun 25, 2007 07:49 PM|LINK
No GoDaddy doesn't allow remote access. To run your site locally you have to change your connection string to connect to your local DB. To look at/ connect to your live DB you have to use their DB manager tool. I wish they would chage to allow remote access, it would be a lot easier but also more chance of the DB getting hacked.